Table of Contents
To add multiple trendlines to a chart in Google Sheets, follow these steps:
1. Select the data range for which you want to add trendlines.
2. Click on the “Insert” tab and then select “Chart” from the dropdown menu.
3. Choose the chart type that you want to use for the data.
4. In the “Customize” tab, click on the “Trendline” option.
5. A trendline will appear on the chart. To add another trendline, click on the existing trendline and a menu will appear.
6. Select “Add Trendline” and choose the type of trendline you want to add (linear, exponential, etc.).
7. The new trendline will be added to the chart.
8. Repeat steps 5-7 to add as many trendlines as you need.
9. You can customize each trendline by clicking on it and adjusting the settings in the menu that appears.
10. Once you are satisfied with the trendlines, click “Apply” to save the changes to your chart.
Add Multiple Trendlines to Chart in Google Sheets
The following step-by-step example shows how to create a chart in Google Sheets with multiple trendlines.
Step 1: Enter the Data
First, let’s enter some values that show the total sales of two different products during various years:
Step 2: Create the Chart
To create a chart to visualize the sales of each product by year, highlight the values in the range A1:C11. Then click the Insert tab and then click Chart:
By default, Google Sheets will insert a line chart:
To turn this into a scatterplot, click the Setup tab within the Chart editor panel and choose Scatter chart as Chart type:
The chart will automatically be turned into a scatterplot:
The blue dots show the sales of product A each year and the red dots show the sales of product B each year.
Step 3: Add Multiple Trendlines
In the Chart editor panel that appears on the right side of the screen, use the following steps to add a trendline to the blue dots:
- Click the Customize tab.
- Then click the Series dropdown.
- Then choose Product A Sales from the dropdown list.
- Then check the box next to Trendline.
Repeat this process, except choose Product B Sales from the dropdown:
The trendlines for Product A Sales and Product B Sales will both be added to the chart:
Note that within the Customize tab you can also modify the color, line thickness and opacity of each trendline.
Also note that Google Sheets uses a linear trendline by default, but within the Customize tab you can also choose to use exponential, polynomial, or other trendlines.
Additional Resources
The following tutorials explain how to perform other common tasks in Google Sheets:
Cite this article
stats writer (2024). How can I add multiple trendlines to a chart in Google Sheets?. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-can-i-add-multiple-trendlines-to-a-chart-in-google-sheets/
stats writer. "How can I add multiple trendlines to a chart in Google Sheets?." PSYCHOLOGICAL SCALES, 29 Jun. 2024, https://scales.arabpsychology.com/stats/how-can-i-add-multiple-trendlines-to-a-chart-in-google-sheets/.
stats writer. "How can I add multiple trendlines to a chart in Google Sheets?." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-can-i-add-multiple-trendlines-to-a-chart-in-google-sheets/.
stats writer (2024) 'How can I add multiple trendlines to a chart in Google Sheets?', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-can-i-add-multiple-trendlines-to-a-chart-in-google-sheets/.
[1] stats writer, "How can I add multiple trendlines to a chart in Google Sheets?," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, June, 2024.
stats writer. How can I add multiple trendlines to a chart in Google Sheets?. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.