How to Add Best Fit Line in Excel?

Select your data range

Insert a scatter plot

Click the data points in the chart

Right-click and choose Add Trendline

Select Linear trendline

Format the trendline if needed

Optionally check Display Equation on chart

Optionally check Display R-squared value on chart

Suggested for You

Trending Today