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