| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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? |
|
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combination stock and scatter chart | Charts and Charting in Excel | |||
| Scatter chart without numerical values | Charts and Charting in Excel | |||
| Line chart or scatter chart?? | Excel Discussion (Misc queries) | |||
| Line chart or scatter chart?? | Excel Discussion (Misc queries) | |||
| equation for smoothed XY Scatter line | Charts and Charting in Excel | |||
Linear Mode
