View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.charting
Jerry W. Lewis
 
Posts: n/a
Default interpolating non-linear curves in excel graphs

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?