Zero values in Pie Charts

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

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

--
Regards
Frank Kabel
Frankfurt, Germany

"Nosnibor" schrieb im Newsbeitrag
...
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?


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

--
Regards
Frank Kabel
Frankfurt, Germany

"Nosnibor" schrieb
im Newsbeitrag
...
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

.

Hi
AFAIK there's no easier way. sorry

--
Regards
Frank Kabel
Frankfurt, Germany


Nosnibor wrote:
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?


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

--
Regards
Frank Kabel
Frankfurt, Germany

"Nosnibor" schrieb im
Newsbeitrag ...
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

.

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

In article ,
says...
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