Scatter Chart with Smoothed Lines

[Guest]

Does anyone know what function Excel uses to create smooth lines connecting
the points in a scatter plot? Is it a cubic spline?

 

[Bernard Liengme]

Here are results of a Google newsgroup search
http://groups.google.ca/groups?as_q...81&as_maxd=25&as_maxm=1&as_maxy=2006&safe=off


The simple answer seems to be "yes"

 

[Jon Peltier]

Near the bottom of this page, Brian Murphy of XLRotor claims it's a Bezier
curve:

http://www.xlrotor.com/resources/files.shtml

He's done a bunch of analysis to back it up.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

 

[Guest]

Excellent! Given that Excel is calculating the Bezier curves, why isn't this
excellent interpolating tool offerred as a standard function?

 

[Jon Peltier]

I'm sure it's because the built-in bezier drawing routines are buried so
deep, it would be a huge effort to extract any of the information, and
translate it into chart axis scales.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______