I need help with adding trendline and finding the r squared value

%3CLINGO-SUB%20id%3D%22lingo-sub-1715308%22%20slang%3D%22en-US%22%3EI%20need%20help%20with%20adding%20trendline%20and%20finding%20the%20r%20squared%20value%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1715308%22%20slang%3D%22en-US%22%3E%3CP%3EFor%20my%20biology%20class%2C%20I%20had%20to%20conduct%20an%20experiment%20and%20put%20down%20all%20my%20information%20on%20excel.%20I%20had%20to%20put%20in%20all%20the%20data%20and%20create%20a%20scatter%20plot%2C%20after%20i%20did%20that%20I%20had%20to%20add%20a%20trendline%20and%20then%20find%20the%20r%20squared%20value.%20I%20don't%20know%20if%20I'm%20doing%20it%20wrong%20or%20something%20is%20wrong%20with%20my%20version%20of%20excel%2C%20but%20I%20desperately%20need%20help.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1715308%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1715574%22%20slang%3D%22en-US%22%3ERe%3A%20I%20need%20help%20with%20adding%20trendline%20and%20finding%20the%20r%20squared%20value%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1715574%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F809765%22%20target%3D%22_blank%22%3E%40vamihe30%3C%2FA%3E%26nbsp%3BAdd%20a%20trend%20line%20by%20selecting%20any%20data%20point.%20On%20the%20%22Chart%20design%22%20ribbon%2C%20look%20for%20the%20button%20shown%20(Add%20chart%20element)%20in%20the%20picture%20below%20to%20add%20the%20trend%20line.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%202020-09-26%20at%2006.11.33.png%22%20style%3D%22width%3A%20307px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F222366i2C67FB2B4B302452%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Screenshot%202020-09-26%20at%2006.11.33.png%22%20alt%3D%22Screenshot%202020-09-26%20at%2006.11.33.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EOnce%20you%20have%20added%20the%20trend%20line%2C%20click%20on%20it%20and%20a%20%22Format%20Trendline%22%20window%20will%20appear.%20Select%20%22display%20R-squared%20value%20on%20chart%22%20at%20the%20bottom.%26nbsp%3B%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%202020-09-26%20at%2006.09.08.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F222365i54F71ED9126451C9%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Screenshot%202020-09-26%20at%2006.09.08.png%22%20alt%3D%22Screenshot%202020-09-26%20at%2006.09.08.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

For my biology class, I had to conduct an experiment and put down all my information on excel. I had to put in all the data and create a scatter plot, after i did that I had to add a trendline and then find the r squared value. I don't know if I'm doing it wrong or something is wrong with my version of excel, but I desperately need help.

3 Replies

@vamihe30 Add a trend line by selecting any data point. On the "Chart design" ribbon, look for the button shown (Add chart element) in the picture below to add the trend line.

Screenshot 2020-09-26 at 06.11.33.png

Once you have added the trend line, click on it and a "Format Trendline" window will appear. Select "display R-squared value on chart" at the bottom. Screenshot 2020-09-26 at 06.09.08.png

@Riny_van_Eekelen 

Screen Shot 2021-02-02 at 2.59.38 PM.png

 Mine doesn't give me that option at all. It only says "chart" 

@Erica_Roberson You're working in Excel for the Web. Trendlines can't be added or edited on that platform. But you can create your chart in the desktop version. The trendline and R2 will show in the on-line version. They will change as your data changes, but as said, you can't edit them.