Using numerical information from trendline equation



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.
Bryan H


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.
You must format the displayed equation to display enough figures for the
coefficients to be useable (I recommend scientific notation with 14 decimal

Alternately, you can use LINEST to fit polynomials


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