View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.charting
Bob Bob is offline
external usenet poster
 
Posts: 972
Default Showing Data Labels with 0 as blank

Jon,
I already tried your suggestion whereby if my formula evaluates to a zero,
it changes the cell to "" (rather than showing zero). But the Data Label
still shows "0" (rather than blank)
Bob


"Jon Peltier" wrote:

Manually or with a formula, change the zero in the source data to a blank
("" or " ").

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


"Bob" wrote in message
...
When selecting Values for Data Labels, is there a way to make the label
associated with a column/bar that has a zero value display as blank rather
than "0"?
Any help would be greatly appreciated.

Thanks,
Bob