Graph with 0%

  • Thread starter Thread starter Question Boy
  • Start date Start date
Q

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
 
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.
 
Use personal format for data labels :

0%,,,
or
general,,,


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