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

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

Guest

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to change series plotting order without changing legend order? 6
Values plotted incorrectly on Line Chart 3
User Selectable Series and Number of Series for Line Chart 2
Radar chart with Area and Lines 1
multiple series bar and line chart 2
XY scatter plot with more than 32000 rows in Excel 2003 0
Different data series in table than in the line chart 1
To plot 3 series each with 90000 data in single Line or XY chart. 4

Back
Top