Chart Best Fit Line Equation Export

[JNEWBURY2280]

I am creating a line graph with a best fit line and displaying the equation of the line to interpolate a value by inputting values for X.

Is there a way to export that formula so I don't have to do hand calculations?

[MrShorty]

You can use the LINEST() formula directly in the spreadsheet to return the coefficients of the trendline: http://office.microsoft.com/en-us/ex...010069838.aspx

[JNEWBURY2280]

It Worked! Thanks!