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



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.

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