Pie Chart (excel 2003)

  • Thread starter Thread starter Guest
  • Start date Start date
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]"";
 
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...
 
Back
Top