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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


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

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()

"Jon Peltier" wrote:

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


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

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?




"vaz" wrote:

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()

"Jon Peltier" wrote:

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


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