Problem with Trendline

  • Thread starter Thread starter Keith
  • Start date Start date
K

Keith

Hello,

I added a polinomial trendline to my graph. The line describes the very
well, but I've been unable to figure out how to extract the numbers in the
trend line, ans show them in a table. How is this done?

Also, is there any help which gives some detail about how the Escel
polinomial trendline graph works?

Thanks very much,

Keith
 
Hi Tushar,
Thank you very much. I looked at the link you sent, and it looks like it
will work very well. I appreciate your help.
Keith
 
You are welcome. Glad to be of help.

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

Hi Tushar,
Thank you very much. I looked at the link you sent, and it looks like it
will work very well. I appreciate your help.
Keith
Click to expand...
[snip]
 
Alternately, David Braden has posted VBA code to extract the
coefficients directly from the chart into cells

http://groups.google.com/[email protected]

The advantage of this latter approach is that LINEST uses a numerically
poor algorithm that can give inaccurate results with some data sets.
The chart trendline (extracted by Braden's code) is much better numerically.

Jerry
 
Back
Top