Zero values in Pie Charts

[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

 

[Frank Kabel]

Hi
have a look at
http://andypope.info/charts/piezeros.htm

 

[Nosnibor]

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?

 

[Frank Kabel]

Hi
AFAIK there's no easier way. sorry

 

[Tushar Mehta]

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