ignoring "n.a" cells in a data series

[K. Georgiadis]

is there any way to ignore "n.a." (not applicable) cells
in a data series, so that they don't get charted as
zeroes?

 

[Frank Kabel]

Hi
use the formula
=NA()
for these kind of values

 

[Jon Peltier]

Is it an Area chart? Frank's suggestion works almost uniformly, but not
in Area charts.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______