How To Create An Excel Scatter Plot With Linear Regression Trendline. Now first calculate the intercept and slope for the regression equation. 3 Select the checkbox for Display R squared value on chart.
The Data Analysis tab comes using an add-in function.
Then we can create the trendline. Now first calculate the intercept and slope for the regression. As you may notice the regression equation Excel has created for us is the same as the linear regression formula we built based on the Coefficients output. As you can see the equation shows how y is related to x.