How to Add a Trendline in Google Sheets

The Google Sheets logo.

First, add a chart to your Google sheet. You can then edit the chart—in the Chart Editor, select the “Customize” tab in the sidebar, select “Series,” check the “Trendline” box, and customize your trendline’s settings.

If you want a simple visual to help your audience see the direction of the data in your chart, consider a trendline. You can add different types of trendlines in Google Sheets and customize their appearance.

About Trendlines in Google Sheets

You can add a trendline to a bar graph, column chart, line graph, or scatter chart. You can select a specific series for the trendline or apply one to all the series in the chart.

RELATED: How to Make a Bar Graph in Google Sheets

There are six types of trendlines you can use depending on how you want to display the line:

  • Linear: Use this for data that mostly follows a straight line.
  • Exponential: Use this for data that increases and decreases in proportion to its value.
  • Polynomial: Use this for data that fluctuates.
  • Logarithmic: Use this for data that increases and decreases quickly and then levels out.
  • Power Series: Use this for data that increases and decreases in proportion to its value at the same rate.
  • Moving Average: Use this to help even out unstable data.

Add a Trendline in Google Sheets

Once you have the chart you want to use and are ready to add the trendline, double-click the chart or click the three dots on the top right and select “Edit Chart” to open the Chart Editor sidebar.

Edit Chart in the chart menu

Go to the Customize tab in the sidebar and expand the Series section.

Series section on the Customize tab of the Chart Editor

At the top of the section, use the drop-down box to choose the series you want to use for the trendline. You can choose “Apply to All Series” or select a particular one in your chart.

If you want to customize a trendline for each series, simply select one at a time and follow the steps below for each.

Select a chart Series

Scroll to the bottom of the Series section and check the box for Trendline.

Trendline box checked

You’ll see the trendline appear on your chart. From there, use the Type drop-down box directly beneath to select the kind of trendline you want to use.

Trendline type selection

If you select Polynomial, you can pick the degree. If you select Moving Average, you can pick the Average Type and Period.

Polynomial and Moving Average trendline types

Once you have your trendline set up, you can customize its appearance.

Customize a Trendline in Your Chart

With the Chart Editor sidebar open and the Series section expanded on the Customize tab, you’ll see options to customize the trendline.

RELATED: How to Switch Chart Axes in Google Sheets

You can select a Line Color using the palette drop-down box. This is handy if you want the trendline to stand out.

Line color palette for a trendline

Next, you can adjust the Line Opacity using the drop-down box. Pick from zero to 100% to make the line more or less bold.

Opacity options for a trendline

You can then pick the Line Thickness using the drop-down box. Select one, two, four, or eight pixels for the width of the line.

Line Thickness options for a trendline

Finally, you can add a label for your trendline to the chart legend if you like. Select the type in the Label drop-down box. If you choose “Custom,” enter the text for the label in the next box.

Custom label for a trendline

You can also choose “Use Equation” to display the trendline type’s equation as the label and optionally display the R squared for how closely the trendline fits the chart data.

Show R squared box checked for a trendline

When you finish adding and customizing your trendline, use the “X” on the top right of the Chart Editor sidebar to close it.

If you want an added visual to help your viewers capture the direction of your data, a trendline in Google Sheets is the way to go.

For more, check out how to save or publish a chart or learn how to make a table using a chart in Google Sheets.

By Janet J

Leave a Reply