|
Scatter Chart with Smoothed Lines
Does anyone know what function Excel uses to create smooth lines connecting
the points in a scatter plot? Is it a cubic spline? |
Scatter Chart with Smoothed Lines
Here are results of a Google newsgroup search
http://groups.google.ca/groups?as_q=...0 06&safe=off The simple answer seems to be "yes" -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "rachsull" wrote in message ... Does anyone know what function Excel uses to create smooth lines connecting the points in a scatter plot? Is it a cubic spline? |
Scatter Chart with Smoothed Lines
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/ _______ "Bernard Liengme" wrote in message ... Here are results of a Google newsgroup search http://groups.google.ca/groups?as_q=...0 06&safe=off The simple answer seems to be "yes" -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "rachsull" wrote in message ... Does anyone know what function Excel uses to create smooth lines connecting the points in a scatter plot? Is it a cubic spline? |
Scatter Chart with Smoothed Lines
Excellent! Given that Excel is calculating the Bezier curves, why isn't this
excellent interpolating tool offerred as a standard function? "Jon Peltier" wrote: 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/ _______ "Bernard Liengme" wrote in message ... Here are results of a Google newsgroup search http://groups.google.ca/groups?as_q=...0 06&safe=off The simple answer seems to be "yes" -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "rachsull" wrote in message ... Does anyone know what function Excel uses to create smooth lines connecting the points in a scatter plot? Is it a cubic spline? |
Scatter Chart with Smoothed Lines
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/ _______ "Waterboy" wrote in message ... Excellent! Given that Excel is calculating the Bezier curves, why isn't this excellent interpolating tool offerred as a standard function? "Jon Peltier" wrote: 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/ _______ "Bernard Liengme" wrote in message ... Here are results of a Google newsgroup search http://groups.google.ca/groups?as_q=...0 06&safe=off The simple answer seems to be "yes" -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "rachsull" wrote in message ... Does anyone know what function Excel uses to create smooth lines connecting the points in a scatter plot? Is it a cubic spline? |
| All times are GMT +1. The time now is 08:05 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com