G
Guest
Does anyone know what function Excel uses to create smooth lines connecting
the points in a scatter plot? Is it a cubic spline?
the points in a scatter plot? Is it a cubic spline?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
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"
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"
J
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/
_______
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/
_______
G
Guest
Excellent! Given that Excel is calculating the Bezier curves, why isn't this
excellent interpolating tool offerred as a standard function?
excellent interpolating tool offerred as a standard function?
J
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/
_______
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/
_______