Chart series split over more than 1 line - dont plot #n/a

I have a chart series which is based upon cells in more than 1 line, some of the cells in the series have #n/a (using an if to force #n/a if the cell value is zero) in them, i do not wish to plot these values, and the moment these are being plotted as zeros, the chart series source reads as follows :

=SERIES(,,('T5'!$H$77:$T$77,'T5'!$I$80:$T$80,'T5'! $I$84:$T$84,'T5'!$I$87:$Q$87),2)

if the series was all on one line the #n/a values arent plotted, but with the series split like this then the #n/a cells are plotted. It seems to be just having the series split like this that plots the zeros.

Any ideas?

Is your chart an Area type chart? The nice things we say here about NA()
not being plotted in a chart are not true for Area Charts. I just tried
your situation, a discontiguous non collinear set of Y values, and the
NA() interpolated across values in a Line chart but plotted as zero in
an Area chart.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
http://PeltierTech.com/Excel/Charts/
_______

allycat898 wrote:

I have a chart series which is based upon cells in more than 1 line,
some of the cells in the series have #n/a (using an if to force #n/a
if the cell value is zero) in them, i do not wish to plot these
values, and the moment these are being plotted as zeros, the chart
series source reads as follows :

=SERIES(,,('T5'!$H$77:$T$77,'T5'!$I$80:$T$80,'T5'! $I$84:$T$84,'T5'!$I$87:$Q$87),2)


if the series was all on one line the #n/a values arent plotted, but
with the series split like this then the #n/a cells are plotted. It
seems to be just having the series split like this that plots the
zeros.

Any ideas?

Yes it is a Line chart (i'm using Excel 2000)