Showing Data Labels with 0 as blank

[Guest]

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

 

[Jon Peltier]

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

- Jon

 

[Guest]

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]

Then you could try a custom number format, something like this:

0;;;

which will only show positive numerical values. More formats here:

http://peltiertech.com/Excel/NumberFormats.html

- Jon

 

[Guest]

That did the trick. Thanks!

Then you could try a custom number format, something like this:

0;;;

which will only show positive numerical values. More formats here:

http://peltiertech.com/Excel/NumberFormats.html

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