Zero values in scatter or line chart

[miller291]

I searched the forum and didn't find anything helpful so I thought I would ask the question.

I have a large series of data with formulas that yield a zero value. I want to graph the data with a scatter and/or line graph but ignore the zero values and essentially interpolate between the value before and after the zero value.

How do I do this?

Thanks in advance.

 

[Jon Peltier]

Change the formulas so that instead of zero or text (which is plotted as zero, and "" is text not a blank), they return NA() or #N/A. A line or XY plot will not draw a marker for #N/A, and will interpolate any connecting line between the points on either side.

For more info, read Mind the Gap - Charting Empty Cells.