Forum Discussion

Copper Contributor

Sep 25, 2020

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

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 th...

Platinum Contributor

Sep 26, 2020

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.

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.

Erica_Roberson

Copper Contributor

Feb 02, 2021

Riny_van_Eekelen

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

Bethann0622
Copper Contributor
May 16, 2024
HI my name is Beth Lindsay and I am having the same problem you are having with a trendline my excel does not give me the version he showed either I have no add button on the rt of my chart so how the heck are we supposed to do our projects for Math I need a trendline for my scatter boxErica_Roberson
Riny_van_Eekelen
Platinum Contributor
Feb 03, 2021
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.