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
 
Back
Top