way to interpolate around zero value in XY-scatter chart?

[Dr. Stupid]

I want to set chart preferences to interpolate a line between data
points flanking a zero value, but I don't want to have to delete the
zero from the table (leaving a blank cell) to make this happen. Is
there a trick?

 

[Salmon Egg]

I want to set chart preferences to interpolate a line between data
points flanking a zero value, but I don't want to have to delete the
zero from the table (leaving a blank cell) to make this happen. Is
there a trick?

Try inserting a tiny number instead of zero. 1E-15 worked as a cell entry
for me although I did not try to plot. If you are a purist and insist on
true zero, use an application such as Maple or Mathematica.

Bill
-- Fermez le Bush--about two years to go.

 

[Dr. Stupid]

Try inserting a tiny number instead of zero. 1E-15 worked as a cell entry
for me although I did not try to plot. If you are a purist and insist on
true zero, use an application such as Maple or Mathematica.

Bill
-- Fermez le Bush--about two years to go.

That wouldn't work. Excel would connect the line down to a point
representing a very small number just as it would to zero.

I'm talking about interpolating between two points flanking the zero
point. Excel does this, but apparently only if the cell is empty.

I need the zero value to remain in the table for "bookkeeping" (I have
a lot of data) but I don't want the graph line to dip to zero (or to a
very small number) every time a zero value appears in a data set.

Incidentally, this is not a best-fit line situation either.

 

[Bob Greenblatt]

I want to set chart preferences to interpolate a line between data
points flanking a zero value, but I don't want to have to delete the
zero from the table (leaving a blank cell) to make this happen. Is
there a trick?

If you simply do not want that value to be plotted, instead of zero change
the cell to #NA().