Weird...right below 'Format Data Labels' is another entry: 'Clear'.
And...that did it. Agony. Also, I have found that where the entries come
from--on anther sheet-make sure I 'Delete' unwanted entries and NOT use the
Space Bar to do it.
Make sense? Two heads...etc.

If Zeros show up in ANY graph, use the 'Clear' to suppress. Must be
'Conditional Formatting' for charts.

----------------------------------------------------------------------------------------

"Bernard Liengme" wrote:

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.