---
title: "How To Add Line Of Best Fit In Google Sheets"
h1: "How To Add Line Of Best Fit In Google Sheets"
description: "Learn how to add a line of best fit in Google Sheets with our step-by-step guide. Enhance your data analysis and visualize trends effortlessly."
route: "/learn/how-to-add-line-of-best-fit-in-google-sheets"
canonical: "https://www.layerpath.com/learn/how-to-add-line-of-best-fit-in-google-sheets"
---

# 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 Layerpath tour

Canonical tour: https://share.layerpath.com/e/cm8rliril007sl50canmesj0m/tour

Tour id: cm8rliril007sl50canmesj0m

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.