finding the equation of the trendline

Copper Contributor

How do I find the equation of the trendline line on the graph (under “more options”) along with the r squared value (coefficient of determination).

3 Replies


For a linear trendline, see the LINEST function 

For an exponential trendline, there is a similar LOGEST function.


You could simply display the values on the chart or calculate them as @Hans Vogelaar suggests.



Right-click the trendline | Format trendline:


Last two checkboxes in this menu: