This is a discussion on Zero values in scatter or line chart within the Excel Questions forums, part of the Question Forums category; I searched the forum and didn't find anything helpful so I thought I would ask the question. I have a ...
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.
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.
Peltier Technical Services, Inc.
Try Peltier Tech Charts for Excel