Conditional Formatting - Data Labels

[JEFF]

Hello,

Is is possible to supress Data Labels (Values) via conditional formatting?
I tried an IF Statement that returned a blank ("" or " ") if the condition is
true. However, the value of zero still appears unless I completely delete
the cell's contents.........

Thanks.

 

[John Mansfield]

I don't know of a way to achieve via conditional formatting. However, the
formulas as shown in these examples may help.

http://www.cellmatrix.net/index.php/bar_chart_exclude_zero_values/

http://www.cellmatrix.net/index.php/pie_chart_exclude_zero_values/

 

[Jon Peltier]

Use a custom number format that omits zero values. These ignore everything
but positive values

0.00;;;
0;;;

More on number formats:

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

- Jon