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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
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()
 
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?
 
Back
Top