How do I stop chart from plotting null values as zeros in excel 20

[suebee]

Blank (null) values plot as zeros in my charts. In excel 2003 I used
tools-options-active chart-plot empty cells as but I can't figure out how to
do this in excel 2007.

 

[Jon Peltier]

On the Chart Tools > Design tab, click on Select Data, then click the Hidden
and Empty Cells button on the dialog (bottom left corner). Note that this
only works for true blank cells, not for formulas which return "". This is
not a blank, but a short piece of text, which Excel evaluates as zero.

- Jon

 

[vaz]

also if u have formulas u can return NA(). excel won't plot it. when u do
this u might want to change ur chart type to force excel to pick the new NA()

 

[RNW]

You solved part of my problem.

But if I've got a chart plotting cell A1 that says:

=IF(ISBLANK(K13),na(),K13)

Thanks to vaz, my chart won't plot anything if K13 is blank, but my cell A1
now says "#NA". Any way to make my cell plot nothing and show nothing? Just
to make it look neater?