|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
January 24th, 2006, 11:07 PM
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
January 25th, 2006, 01:31 PM
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
January 27th, 2006, 04:34 AM
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
January 31st, 2006, 05:49 PM
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
January 31st, 2006, 06:18 PM
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?
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| mix chart types | Ken Murray | Powerpoint | 7 | April 28th, 2006 02:50 AM |
| Combination stock and scatter chart | ArtZ | Charts and Charting | 1 | January 8th, 2006 07:59 PM |
| Scatter Chart Data Point Highlighting | rvExcelNewTip | Charts and Charting | 6 | January 8th, 2006 05:21 PM |
| Leader Lines Connecting Chart to Box | TOMB | Charts and Charting | 1 | May 7th, 2005 06:00 PM |
| Pie chart with 'anchored' lines to text box | TOMB | Charts and Charting | 0 | May 4th, 2005 09:14 PM |
Linear Mode
