trendline equation

Copper Contributor

how do I get an equation for my scatter plot linear trend line? there isn't anything coming up in the format chart area to create an equation.

1 Reply

@acmaldo Duplication of this thread?

https://techcommunity.microsoft.com/t5/excel/how-to-get-quot-more-trendline-options-quot/m-p/1715637... 

Can you not select and rigth-click (or two-finger click on a touch pad) the trend line and then "Format trend line..."?

Screenshot 2020-09-30 at 07.06.41.png

On a Mac myself with the most recent MS365 version. Can't recall if older Mac versions did not have the  "More Trendline Options..." item in the menu. What version are you on?