Trendline Issue in Microsoft Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-1735285%22%20slang%3D%22en-US%22%3ETrendline%20Issue%20in%20Microsoft%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1735285%22%20slang%3D%22en-US%22%3E%3CP%3EHello!%20I've%20looked%20up%20how%20to%20add%20a%20trendline%20(or%20line%20of%20best%20fit)%20into%20my%20Excel%20Sheet%20for%20a%20graph%2C%20but%20I%20still%20have%20no%20idea%20where%20to%20find%20it.%20There%20is%20supposed%20to%20be%20a%20little%20plus%20in%20the%20top%20right%20corner%20of%20the%20graph%20when%20you%20click%20on%20it%2C%20but%20I%20don't%20get%20it%20when%20I%20try%20clicking%20it.%20I%20think%20it's%20because%20I%20have%20a%20different%20version%20of%20Excel%2C%20but%20I'm%20not%20sure.%20I've%20added%20a%20photo%20of%20my%20excel%20sheet%20so%20you%20can%20see%20what%20mine%20looks%20like.%20If%20anyone%20has%20any%20suggestions%20on%20how%20to%20a%20trendline%20over%20my%20scatterplot%2C%20that%20would%20be%20appreciated!!%20%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screen%20Shot%202020-10-01%20at%2012.22.58%20PM.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F223377iDF64C1BD369483FB%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22Screen%20Shot%202020-10-01%20at%2012.22.58%20PM.png%22%20alt%3D%22Screen%20Shot%202020-10-01%20at%2012.22.58%20PM.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1735285%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1742408%22%20slang%3D%22en-US%22%3ERe%3A%20Trendline%20Issue%20in%20Microsoft%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1742408%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F816631%22%20target%3D%22_blank%22%3E%40AmyHoadley%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPress%20right%20mouse%20button%20over%20any%20dot%20of%20the%20scatter%20plot%2C%20you%20will%20find%20it%20in%20the%20pop%20up%20menu%20near%20the%20bottom%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

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
Highlighted

@AmyHoadley

 

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

 

Highlighted

@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