Pie Chart (excel 2003)

S

ShaneDevenshire

If you mean on the pie then double click the data labels and choose the
Number tab, choose Custom and enter the following code on the Type line on
the right:

0%;[=0]"";
 
X

Xueling

Thanks! It does look better.

But is there a way to not show the data lable of those 0% as well?

ShaneDevenshire said:
If you mean on the pie then double click the data labels and choose the
Number tab, choose Custom and enter the following code on the Type line on
the right:

0%;[=0]"";


--
Cheers,
Shane Devenshire


Xueling said:
How do I hide the 0% of the pie chart so that they only show the relevant %?
Click to expand...
Click to expand...
 
Top