Using numerical information from trendline equation

[BryanDamon]

I would like to be able to grab the coefficients from an excel graph
trendline equation. Is this possible, the number seems to be available to
copy and paste but I would like to be able to use it in a cell in the
worksheet. If possible I would like to be able to have cells linked to the
equations coefficients, Rsquared value, regression type, and if polynomial
equation order.
Thanks,
Bryan H

 

[Jerry W. Lewis]

Tushar Mehta has enhanced VBA code by David Braden to extract
coefficients from the chart trendline.
http://groups.google.com/group/microsoft.public.excel.charting/msg/0eda30f29434786d
You must format the displayed equation to display enough figures for the
coefficients to be useable (I recommend scientific notation with 14 decimal
places).

Alternately, you can use LINEST to fit polynomials
http://people.stfx.ca/bliengme/ExcelTips/Polynomial.htm

Jerry

 

[BryanDamon]

AWESOME!
Exactly what I needed, thanks Jerry!

Tushar Mehta has enhanced VBA code by David Braden to extract
coefficients from the chart trendline.
http://groups.google.com/group/microsoft.public.excel.charting/msg/0eda30f29434786d
You must format the displayed equation to display enough figures for the
coefficients to be useable (I recommend scientific notation with 14 decimal
places).

Alternately, you can use LINEST to fit polynomials
http://people.stfx.ca/bliengme/ExcelTips/Polynomial.htm

Jerry