How to Automate Copying of trendline equation to a cell
 

I want to figure out have excel take an equation for a trendline out of a
chart and paste it into a set of cells to calculate new values.

For example I have data at time 100, 200, 300 and 500, but want to
automatically have the equation of the trendline fitting my data copy over to
a set of cells where the intermadiate data for time 25,50,75 etc will be
calculated.
I typically fit a polonomial trendline?

How to Automate Copying of trendline equation to a cell
 

Polynomial, non-linear, Trendline Coefficients
and Regression Analysis

http://www.tushar-mehta.com/excel/ti...efficients.htm
http://people.stfx.ca/bliengme/ExcelTips/Polynomial.htm
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Kmartin" wrote in message
...
I want to figure out have excel take an equation for a trendline out of a
chart and paste it into a set of cells to calculate new values.

For example I have data at time 100, 200, 300 and 500, but want to
automatically have the equation of the trendline fitting my data copy over
to
a set of cells where the intermadiate data for time 25,50,75 etc will be
calculated.
I typically fit a polonomial trendline?