How to Easily Add a Line of Best Fit in Google Sheets

Last Modified: February 2, 2024 - 3 min read

Julian Alvarado

Adding a line of best fit to a chart in Google Sheets can be a useful way to visualize trends and relationships in your data. A line of best fit is a straight line that represents the general trend in a dataset, and it can help you make predictions and identify patterns that might not be immediately obvious.

Whether you’re analyzing sales data, tracking social media metrics, or trying to understand the relationship between two variables, adding a line of best fit to your chart in Google Sheets can help you gain insights and make informed decisions. 

This blog will examine how to add a line of best fit in Google Sheets.

Understanding the Basics of a Line of Best Fit

A line of best fit, also known as a trendline or regression line, is crucial for representing trends in a scatter plot. It simplifies identifying data patterns and relationships, aiding in predictions and insightful decision-making.

Purpose of a Line of Best Fit

The line of best fit is essential for identifying data patterns. It helps evaluate relationships between variables, enhancing your understanding of data trends and aiding in accurate predictions.

Interpreting the Line of Best Fit

Interpreting this line involves understanding its slope and y-intercept. The slope indicates the relationship between variables – positive for direct relationships, negative for inverse ones. The y-intercept denotes the dependent variable’s value when the independent variable is zero.

Step-by-Step Guide to Adding a Line of Best Fit in Google Sheets

Adding a line of best fit in Google Sheets is a useful tool for analyzing data and identifying trends. Follow this step-by-step guide to add a line of best fit to your data in Google Sheets.

Data Input

The first step is to input your data into a Google Sheets spreadsheet. Make sure to organize your data properly before adding a line of best fit. 

The data should be in two columns, with the independent variable in the first column and the dependent variable in the second column.

monthly data entered in two columns labeled 'Month' and 'Sales (in $1000s)'

Creating a Scatter Plot

After inputting your data, the next step is creating a scatter plot. 

Select your data, including headers.

spreadsheet ai
Free AI-Powered Tools Right Within Your Spreadsheet

Supercharge your spreadsheets with GPT-powered AI tools for building formulas, charts, pivots, SQL and more. Simple prompts for automatic generation.

A Highlighted table in Google Sheets with months listed from January to December and corresponding sales in $1000s and customer traffic numbers.

Navigate to the menu of your spreadsheet and click “Insert” > “Chart.” 

Screenshot of inserting a chart into Google Sheets

Open the Chart type drop-down and select  “Scatter.”

Close-up of a Google Sheets line chart option in the chart type selection menu, for visualizing trends in data.

Your graph will automatically update to a scatter plot. 

Scatter chart in Google Sheets showing the relationship between monthly sales in $1000s and customer traffic, awaiting a trendline.

Implementing the Line of Best Fit

Click on the scatter plot and navigate to “Customize” > “Series” > “Trendline” > “Linear” to add the line of best fit. 

Google Sheets scatter chart displaying sales in $1000s against customer traffic with a linear trendline showing an upward trend.


Adding a line of best fit in Google Sheets is a simple and useful tool for analyzing data. By following this step-by-step guide, you can easily add a line of best fit to your data and identify trends.

For more advanced data analytics with your business data, consider exploring Coefficient!

Sync Live Data into Your Spreadsheet

Connect Google Sheets or Excel to your business systems, import your data, and set it on a refresh schedule.

Try the Spreadsheet Automation Tool Over 350,000 Professionals are Raving About

Tired of spending endless hours manually pushing and pulling data into Google Sheets? Say goodbye to repetitive tasks and hello to efficiency with Coefficient, the leading spreadsheet automation tool trusted by over 350,000 professionals worldwide.

Sync data from your CRM, database, ads platforms, and more into Google Sheets in just a few clicks. Set it on a refresh schedule. And, use AI to write formulas and SQL, or build charts and pivots.

Julian Alvarado Content Marketing
Julian is a dynamic B2B marketer with 8+ years of experience creating full-funnel marketing journeys, leveraging an analytical background in biological sciences to examine customer needs.
350,000+ happy users
Wait, there's more!
Connect any system to Google Sheets in just seconds.
Get Started Free

Trusted By Over 20,000 Companies