Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community

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: