Graph with 0%

[Question Boy]

is there a way, even with vba, to get graphs not to display 0%. I have pie
charts set on a table whose value are dynamic and in some instances they can
equeal 0. I need to stop the chart from displying 0% as a data label in
those instances only, but still display the others.

Thank you,

QB

 

[John Mansfield]

Yes, Andy Pope has an example on his site . . .

http://www.andypope.info/charts/piezeros.htm

 

[Researcher08]

I use Excel 2003, so I hope this still applies. After you make your chart,
double click on the offending 0% label. The cursor should change to text.
Simply delete the text of the label.

 

[Mais qui est Paul]

Use personal format for data labels :

0%,,,
or
general,,,


by VBA
Selection.NumberFormat = "0%,,,"
or
Selection.NumberFormat = "general,,,"