Using numerical information from trendline equation

B

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
 
B

BryanDamon

AWESOME!
Exactly what I needed, thanks Jerry!

Jerry W. Lewis said:
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top