Showing Data Labels with 0 as blank
 

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

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

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

Showing Data Labels with 0 as blank
 

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

0;;;

which will only show positive numerical values. More formats he

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

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


"Bob" wrote in message
...
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

Showing Data Labels with 0 as blank
 

That did the trick. Thanks!


"Jon Peltier" wrote:

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

0;;;

which will only show positive numerical values. More formats he

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

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


"Bob" wrote in message
...
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