If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
Chart series split over more than 1 line - dont plot #n/a
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? |
#3
|
|||
|
|||
Chart series split over more than 1 line - dont plot #n/a
Yes it is a Line chart (i'm using Excel 2000)
|
Thread Tools | |
Display Modes | |
|
|