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.