Plotting Null's

[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

 

[Bernard Liengme]

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"