Trend line equation
 

How can I automatically capture the coefficients of a trend line equation
from an excel chart, to use in other calculations?

Trend line equation
 

cturner08 -

One approach is to use worksheet functions. See John Walkenbach's page at
http://spreadsheetpage.com/index.php...dline_formulas

- Mike Middleton
Web http://www.MikeMiddleton.com
Email



"cturner08" wrote in message
...
How can I automatically capture the coefficients of a trend line equation
from an excel chart, to use in other calculations?

Trend line equation
 

See
http://people.stfx.ca/bliengme/ExcelTips/Polynomial.htm
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"cturner08" wrote in message
...
How can I automatically capture the coefficients of a trend line equation
from an excel chart, to use in other calculations?