I do have data points for one of the lines between 40 and 60 but not for
the other. The line I don't have a data points for is linear (intercept
= 0, slope=1, data points 0 and 100) it represents an "ideal" and I am
measureing how close the other data fits to the ideal. Moreover, the
data is not linear in whole, but could be considered linear between 40
and 60. Does that help?
MrShorty Wrote:
The chart itself is not going to readily be able to do this. The
"smooth curve" is just a spline, and may or may not represent reality.
I'm also not aware of any way to extract interpolated values from
Excel's spline. Best bet, IMO, will be to obtain the area between the
curves in the spreadsheet from which the data were plotted. Do you
have data points between 40 and 60? What kind of curve (linear,
exponential, etc.) do you expect?
--
prd02003
------------------------------------------------------------------------
prd02003's Profile:
http://www.excelforum.com/member.php...o&userid=25762
View this thread:
http://www.excelforum.com/showthread...hreadid=391727