ignoring "n.a" cells in a data series

K

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?
 
J

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/
_______
 
Top