Zero values in Pie Charts

  • Thread starter Thread starter Nosnibor
  • Start date Start date
N

Nosnibor

I create a series of Pie charts each month which will
inevitably have some zero values. Each time I have to
update the labels via Chart Options and then delete the
zero ones.
Is there a shortcut to this which will get Excel to show
only the labels and %s where the value is greater than
zero. I currently use Excel 97 however am being upgraded
to XP in May.

Thanks
 
Thanks Frank
I had a look at this - it seems a very complicated way of
doing something which you would think is very
straightforward.

Are there any other ways?
 
If Andy's solution is too complicated, consider hiding the rows with
the zero values. Also, set the chart options to show only visible
data. To set the option: select the chart, then select Tools |
Options... | Chart tab | check 'Plot visible cells only'

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 

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

Do not display Value label if value = zero 1
pie charts automatically exclude zero values 1
Pie Chart and Zero Value Labels 1
Zero Values on a Pie Chart 2
Excel Can a pie of pie chart use animation/transitions? 1
Pie chart-remove series w/out changing percent in pie 1
Pie charts - 0 values 2
pie chart areas reflect magnitude 5

Back
Top