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)))