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

  • Thread starter Thread starter DeanP
  • Start date Start date
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.
 
Back
Top