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 %?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top