The chart smoother appears to fit Bezier curves
http://www.xlrotor.com/Smooth_curve_...ample_file.zip
which in most instances is not greatly different than cubic splines
http://groups.google.com/group/micro...2966520eccdb1f
Jerry
"chris" wrote:
I'm generally quite happy with how excel graphs the moderately
non-linear x-y data I supply it - the curves pass through all the data
points with a pleasing fit.
I'd just like to be able to get excel to interpolate on the graph for
me. For instance, the curve passes through the points (x1, y1) and
(x2, y2) which I supplied. How do I get excel to calculate and supply
the value y3 from the point (x3, y3) on the curve it generated when I
specify the value of x3?