Or use a number format without an entry for zero:

General;General;;@
0.00;0.00;;@
0%;0%;;@

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


"Bernard Liengme" wrote in message
...
I take it you mean you are using values as data labels but do not want 0 to
be displayed.
Right click the Data Labels in chart; use Format Data Labels
Use a Custom Format of General; General; [White]General and set the font
background to transparent
Change [White] to whatever colour you use for the plot area so the 0 is
invisible
best wishes


--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Harry" wrote in message
...
Each bar in chart shows a value. I do NOT want the value of ZERO to show.