Excel: Empty cell in 2007

Y E S ! ! !

Brilliant ! I've been struggling with this since yesterday, awesome stuff.

(I used the #N/A method - it still seemed to count " " as Zero)


Ta - Nathan.

This does not work in Excel 2007. It labels the bars with #N/A. I tried NA(), " ", and "" but the space and empty string both show zeros. The only thing I found that worked was to delete the formula entirely out of any cell with a zero result.

****** ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! *************
Found a better solution! Leave your formulas and let them return the zeros.
Then in your chart, add data labels, then format the labels to hide the zeros. Got to Edit Labels, Number options, and use a Custom format and enter 0;;; then click Add. You might have to change the 0 to 0.0 or 0% or whatever is appropriate for your data values.
The format string syntax is:
positive value format; negative value format; zero value format; text value format.

Gr8 work You made my day!! thx.