Thread: Showing Data Labels with 0 as blank
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
  
Posts: 6,582
Default Showing Data Labels with 0 as blank
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



Reply With QuoteReply With Quote