We rebuilt the editor. Less panel hunting. More shaping.

Guide

How To Add Line Of Best Fit In Google Sheets

Follow these steps to add a line of best fit to your data in Google Sheets. This guide will walk you through the process step-by-step, ensuring that your data visualization is accurate and professional.

Interactive tour · Open canonical tour

  1. Select your scatter plot in Google Sheets.

  2. Click on the three-dot menu in the chart’s top-right corner.

  3. Choose Edit chart to open the Chart Editor.

  4. Go to the Customize tab and expand the Series section.

  5. Check the box for Trendline to add a line of best fit.

  6. Choose the type (Linear, Exponential, etc.) and customize its color or thickness.

  7. Optionally, display the R² value to measure the trendline’s accuracy.