Trendline Issue in Microsoft Excel

Copper Contributor

Hello! I've looked up how to add a trendline (or line of best fit) into my Excel Sheet for a graph, but I still have no idea where to find it. There is supposed to be a little plus in the top right corner of the graph when you click on it, but I don't get it when I try clicking it. I think it's because I have a different version of Excel, but I'm not sure. I've added a photo of my excel sheet so you can see what mine looks like. If anyone has any suggestions on how to a trendline over my scatterplot, that would be appreciated!! Screen Shot 2020-10-01 at 12.22.58 PM.png

2 Replies

@AmyHoadley

 

Press right mouse button over any dot of the scatter plot, you will find it in the pop up menu near the bottom

 

@AmyHoadley 

On which version of Excel you are? I see you have data types, my guess for such version you shall have Chart menu icons.

image.png