Forum Discussion

AmyHoadley's avatar
AmyHoadley
Copper Contributor
Oct 01, 2020

Trendline Issue in Microsoft Excel

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!!

Charting
excel

2 Replies

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Oct 03, 2020

    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.

  • Ramiz_Assaf's avatar
    Ramiz_Assaf
    Iron Contributor
    Oct 03, 2020

    AmyHoadley

     

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

     

Resources