How To Add Multiple Trendlines In Google Sheets

In this tutorial, you will learn how to add multiple trendlines in Google Sheets.

When working with multiple data sets in Google Sheets, you might display more than one data set in the same chart to compare trends. Fortunately, Google Sheets makes it easy to add more than one data set to a chart and display trend lines for each.

Follow the steps below to learn how.

Insert a Scatter Plot in Google Sheets

If you already have a scatter plot with multiple data sets in Google Sheets, you can skip this section. If not, here’s how to insert one:

Step 1

Select the data range you want to plot, including all data series. Be sure to include the headers as these will be used to label the axes in the plot

Step 2

Open the Insert menu, and select the Chart option

Step 3

In the Chart Editor sidebar, click on the Chart Type dropdown menu and select the Scatter Chart option

Step 4

Your scatter plot will be inserted

Adding Multiple Trendlines

Once you have a scatter plot with multiple data sets in your Google Sheet, here’s how to add trendlines for each data set:

Step 1

Select the scatter plot, then click on the 3 dot menu icon in the corner. Select Edit Chart from the menu that appears

Step 2

In the Chart Editor sidebar, switch to the Customize tab, then click on the Series section to expand it

Step 3

In the dropdown menu at the top of the section, choose a data set to add a trendline to

Step 4

Scroll to the bottom of the Series section and check the box labeled Trendline

Step 5

Make any changes you would like to the trendline type and appearance settings

Step 6

Repeat Steps 3-5 as many times as needed to add trendlines to all desired series

Summary

Example Spreadsheet: Make a copy of the example spreadsheet

In this tutorial, I covered how to add multiple trendlines in Google Sheets. Want more? Check out all the Google Sheets Tutorials.

Get more Google Sheets stuff

Subscribe to our mailing list and get interesting Google Sheets stuff and updates to your email inbox.

Thank you for subscribing.

Something went wrong.