how do i extract the formula from a trendline in Excel?

D

DeanP

I have a lot of data with an order 6 polynomial trendline. I know I can see
the equation used to plot the trendline by displaying the equation on the
chart, but is there a way to output this equation to a cell instead? I would
like to analyse the data, but copying each equation for each set of data into
cells (and having to rewrite them as formulae that excel will recognise) will
take a long time. Thanks.
 
J

Jon Peltier

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

Similar Threads

using polynomial trendline equations 2
Ploynomial Trendline Equation Changes After Copy Paste 11
Trendline equation calculation 3
How to Automate Copying of trendline equation to a cell 1
Trendlines 8
Newbie trouble with polynomial trendline equation 2
Excel 2007 Trendline Equations Incorrect 6
Trendline Not The Same as Equation Displayed 2

Top