Pie Chart (excel 2003)

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I hide the 0% of the pie chart so that they only show the relevant %?
 
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...
 
You must log in or register to reply here.

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

Similar Threads

Excel Can a pie of pie chart use animation/transitions? 1
Change pie chart start point or orientation 1
pie chart areas reflect magnitude 5
Extra Slice in Pie in Pie chart 4
Excel 3-D Pie Chart Flaw & Test 3
Is it possible to put explanatory text at bottom of pie chart? 1
Pie Chart displayed on top of a Pie Chart 7
Pie chart-remove series w/out changing percent in pie 1

Back
Top