View Single Post
  #5   Report Post  
David J. Braden
 
Posts: n/a
Default

Excel apparently uses Bezier curves to smooth its graphs. I *guess* it sets
up a lot of interpolation points for the purpose of charting any of its
trendlines.

If you are at all comfortable with using VBA, you might want to download my
cubic spline code (posted under Braden; watch out for the unintended line
breaks. See
http://groups-beta.google.com/group/...c412511748ebc9

An advanced search under the topic "cubic spline", author "Braden", group
"microsoft.public.excel.*" will yield more info.

HTH
Dave Braden

"lsu-i-like" wrote
in message ...

why is a polynomial trend line different from the original graph that
excel produces?


--
lsu-i-like
------------------------------------------------------------------------
lsu-i-like's Profile:
http://www.excelforum.com/member.php...o&userid=14317
View this thread: http://www.excelforum.com/showthread...hreadid=392879