Thanks Jon.
The zero value no longer shows but the Data Label is still there. Is there a
way to remove the Data Label if the Value is Zero?
Therese
"Jon Peltier" wrote:
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?