Plotting Null's

  • Thread starter Thread starter Pal
  • Start date Start date
P

Pal

I am trying to x-y plot a data set.
at times I have zeros where no data is needed in a standardized format.
I don't what to show these zeros when I print the worksheet so I used
something like a1: if(z10=0,"",z10)
But My chart line disappears when it has "" in its range.
How can I plot the line and not show null in my text?

Thanks in advance
Pal
 
The empty cells should display NA() so change formula to if(z10=0,NA(),z10)
OR
Select chart, use Tools|Options; open Chart tab and look at "plot empty
cells"
 
Back
Top