I am charting growth over a span of 6 decades for several groups. Data points vary in time for the groups over this span so I am using interpolation (#N/A) to fill gaps. My question is does this interpolation default to linear interpolation?
I am charting growth over a span of 6 decades for several groups. Data points vary in time for the groups over this span so I am using interpolation (#N/A) to fill gaps. My question is does this interpolation default to linear interpolation?
Assuming I understand your scenario (an example chart + data set in a spreadsheet would help illustrate this kind of question), then I would say that the "default" method of drawing the lines on the chart is indeed to assume that the available points are connected by straight lines, so the "missing" points are linearly interpolated.
If you go into the "format data series" dialog and select the optional "smoothed" line toggle, you can have the points connected by a smooth "spline" curve.
Originally Posted by shg
great, thanks for the help!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks