Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
smoothing lines
6 views
Skip to first unread message
Anne
Dec 23, 2003, 2:29:51 PM12/23/03
to
In the scatter plot option, lines can be smoothed. what
is the formula used for the smoothing, what is the
smoothing technique called, and is there any documentation
of the calculations used in Excel for smoothing the lines?
thanks.
is the formula used for the smoothing, what is the
smoothing technique called, and is there any documentation
of the calculations used in Excel for smoothing the lines?
thanks.
J.E. McGimpsey
Dec 23, 2003, 3:08:01 PM12/23/03
to
AFAIK, the method is unpublished. I've seen various assertions that
the method uses cubic splines, though with some tweaks.
the method uses cubic splines, though with some tweaks.
There are dozens of threads on this in the archive:
http://google.com/advanced_group_search?q=group:*excel*
Use "smooth chart" (no quotes) as a search term. Look for posts by
David Braden, Jerry W. Lewis and Jon Peltier, among others.
In article <009c01c3c98b$22624ad0$a501...@phx.gbl>,
Jerry W. Lewis
Dec 24, 2003, 7:27:34 AM12/24/03
to
Excel's chart smoother appears to use Bezier curves. Brian Murphy has
posted code for Bezier curves.
posted code for Bezier curves.
http://www.xlrotor.com/excel_stuff.htm
In most cases, the difference between Bezier curves and cubic splines is
minimal. An example where the difference is noticeable is
http://www.google.com/groups?threadm=3E7291CA.7020907%40no_e-mail.com
David Braden has posted code for cubic splines
http://www.google.com/groups?selm=3A11AD33.B1438202%40rochester.rr.com
Jerry
0 new messages