Graph with 0%
 

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

Graph with 0%
 

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

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

--
John Mansfield
cellmatrix.net


"Question Boy" wrote:

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

Graph with 0%
 

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.
"Question Boy" wrote:

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

Graph with 0%
 

Bonsour® "Question Boy" wrote:

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.

Use personal format for data labels :

0%,,,
or
general,,,


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


--
--
@+
;o)))