View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Bernard Liengme Bernard Liengme is offline
external usenet poster
 
Posts: 4,393
Default In bar chart using values-NOT show the value of zero

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.