Use a custom number format that doesn't show zeros, for example, one of
these:
$0.00;($.00);;@
0.0%;-0.0%;;@
0;0;;@
For more about number formats, see
http://peltiertech.com/Excel/NumberFormats.html
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. -
http://PeltierTech.com
_______
"Therese" wrote in message
...
It annoys me to see the Data Label still appears for zero value in a
chart.
Is there a way to put in condition that if value is zero then do not show
the
Data Labels?