software

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

Here are results of a Google newsgroup search
groups.google.ca/groups?as_q=...0 06amp;safe=offThe simple answer seems to be quot;yesquot;
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

quot;rachsullquot; gt; wrote in message
...
gt; Does anyone know what function Excel uses to create smooth lines
gt; connecting
gt; the points in a scatter plot? Is it a cubic spline?
Near the bottom of this page, Brian Murphy of XLRotor claims it's a Bezier
curve:

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
PeltierTech.com/
_______

quot;Bernard Liengmequot; gt; wrote in message
...
gt; Here are results of a Google newsgroup search
gt; groups.google.ca/groups?as_q=...0 06amp;safe=off
gt;
gt;
gt; The simple answer seems to be quot;yesquot;
gt; --
gt; Bernard V Liengme
gt; www.stfx.ca/people/bliengme
gt; remove caps from email
gt;
gt; quot;rachsullquot; gt; wrote in message
gt; ...
gt;gt; Does anyone know what function Excel uses to create smooth lines
gt;gt; connecting
gt;gt; the points in a scatter plot? Is it a cubic spline?
gt;
gt;
Excellent! Given that Excel is calculating the Bezier curves, why isn't this
excellent interpolating tool offerred as a standard function?

quot;Jon Peltierquot; wrote:

gt; Near the bottom of this page, Brian Murphy of XLRotor claims it's a Bezier
gt; curve:
gt;
gt; www.xlrotor.com/resources/files.shtml
gt;
gt; He's done a bunch of analysis to back it up.
gt;
gt; - Jon
gt; -------
gt; Jon Peltier, Microsoft Excel MVP
gt; Peltier Technical Services
gt; Tutorials and Custom Solutions
gt; PeltierTech.com/
gt; _______
gt;
gt; quot;Bernard Liengmequot; gt; wrote in message
gt; ...
gt; gt; Here are results of a Google newsgroup search
gt; gt; groups.google.ca/groups?as_q=...0 06amp;safe=off
gt; gt;
gt; gt;
gt; gt; The simple answer seems to be quot;yesquot;
gt; gt; --
gt; gt; Bernard V Liengme
gt; gt; www.stfx.ca/people/bliengme
gt; gt; remove caps from email
gt; gt;
gt; gt; quot;rachsullquot; gt; wrote in message
gt; gt; ...
gt; gt;gt; Does anyone know what function Excel uses to create smooth lines
gt; gt;gt; connecting
gt; gt;gt; the points in a scatter plot? Is it a cubic spline?
gt; gt;
gt; gt;
gt;
gt;
gt;

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
PeltierTech.com/
_______quot;Waterboyquot; gt; wrote in message
...
gt; Excellent! Given that Excel is calculating the Bezier curves, why isn't
gt; this
gt; excellent interpolating tool offerred as a standard function?
gt;
gt; quot;Jon Peltierquot; wrote:
gt;
gt;gt; Near the bottom of this page, Brian Murphy of XLRotor claims it's a
gt;gt; Bezier
gt;gt; curve:
gt;gt;
gt;gt; www.xlrotor.com/resources/files.shtml
gt;gt;
gt;gt; He's done a bunch of analysis to back it up.
gt;gt;
gt;gt; - Jon
gt;gt; -------
gt;gt; Jon Peltier, Microsoft Excel MVP
gt;gt; Peltier Technical Services
gt;gt; Tutorials and Custom Solutions
gt;gt; PeltierTech.com/
gt;gt; _______
gt;gt;
gt;gt; quot;Bernard Liengmequot; gt; wrote in message
gt;gt; ...
gt;gt; gt; Here are results of a Google newsgroup search
gt;gt; gt; groups.google.ca/groups?as_q=...0 06amp;safe=off
gt;gt; gt;
gt;gt; gt;
gt;gt; gt; The simple answer seems to be quot;yesquot;
gt;gt; gt; --
gt;gt; gt; Bernard V Liengme
gt;gt; gt; www.stfx.ca/people/bliengme
gt;gt; gt; remove caps from email
gt;gt; gt;
gt;gt; gt; quot;rachsullquot; gt; wrote in message
gt;gt; gt; ...
gt;gt; gt;gt; Does anyone know what function Excel uses to create smooth lines
gt;gt; gt;gt; connecting
gt;gt; gt;gt; the points in a scatter plot? Is it a cubic spline?
gt;gt; gt;
gt;gt; gt;
gt;gt;
gt;gt;
gt;gt;