removing 0 value data labels

Hi All

How would I remove 0 Value data labels from a chart using
vb script?

No need for VBA. You can make a custom number format for the labels.
Select the whole set of labels, press CTRL+1 to format, and on the
number format, select Custom in the left hand list, and add a format
like one of these:

0;0;;@
0.0;0.0;;@

There are four items in a custom format, by default the formats for
positive, negative, and zero values, and for text. Leave off the format
for zeros, and the label will not appear.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


wrote:

Hi All

How would I remove 0 Value data labels from a chart using
vb script?