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

@pippins_2586 

For a linear trendline, see the LINEST function 

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

@pippins_2586 

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

image.png

@pippins_2586 

Right-click the trendline | Format trendline:

 

Last two checkboxes in this menu:

Patrick2788_0-1698183999018.png