How to Add Multiple Trendlines in Google Sheets

Creating a chart in Google Sheets is simple, but visualizing the underlying direction of your data requires a trendline. While adding one trendline is straightforward, adding several to a single chart to compare different data series can seem tricky at first. This tutorial will show you exactly how to add multiple trendlines in Google Sheets, allowing you to easily compare the momentum of different product lines, marketing campaigns, or any other data you're tracking.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Why Is Adding Multiple Trendlines Useful?

A single trendline on a chart is great for seeing the overall direction of one set of data. Is it going up, down, or staying flat? But often, the real insights come from comparison. Imagine you're a marketing manager looking at website traffic from three different channels: Google, Facebook, and Twitter.

By plotting all three on a single line chart and adding a separate trendline for each, you can instantly see:

• Which channel is growing the fastest?
• Is one channel showing accelerating growth (an exponential trend) while another is growing at a slow and steady pace (a linear trend)?
• Is one channel's growth starting to flatten or decline?

This comparative view gives you far more context than looking at three separate charts. It turns a simple data visualization into a powerful analytical tool, helping you see not just what happened, but how different parts of your business are performing relative to one another.

How to Add Multiple Trendlines: The Step-by-Step Method

The key to adding multiple trendlines is to treat each data series within your chart independently. You don't add all the trendlines at once, you add them one by one for each line on your graph.

Let's walk through an example. Suppose we're tracking quarterly sales for three fictional products: Alpha, Beta, and Gamma.

Here’s our sample data:

Quarter,Product Alpha Sales,Product Beta Sales,Product Gamma Sales Q1 2023,500,800,1200 Q2 2023,550,820,1150 Q3 2023,620,850,1180 Q4 2023,710,950,1120 Q1 2024,800,980,1100 Q2 2024,880,1050,1050

Our goal is to create one line chart showing the sales data for all three products, each with its own unique trendline.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Step 1: Create Your Chart

First, highlight all your data, including the headers. In our case, that’s cells A1 through D7. With the data selected, go to the Google Sheets menu and click Insert > Chart.

Google Sheets will usually default to a pretty good chart type. For this kind of data, a Line chart or a Scatter chart is ideal because they clearly show data points over time, making them perfect for trend analysis.

Step 2: Open the Chart Editor

Your new chart will appear on the sheet, and the Chart editor sidebar should open automatically on the right. If it doesn't, just double-click anywhere on the chart to open it.

Make sure you're on the Customize tab in the editor.

Step 3: Add a Trendline to the First Series

In the "Customize" tab, find and click on the Series dropdown menu. This is where you control the appearance of each line on your chart.

By default, "Apply to all series" might be selected. Click this dropdown and select your first data series. In our example, let's start with "Product Alpha Sales."

Once you’ve selected a specific series, a new set of options will appear below it. Scroll down and you'll see a checkbox for Trendline. Check it!

Instantly, a trendline will appear on your chart for just the Product Alpha data. You can now customize its appearance:

• Type: Choose between Linear, Exponential, Polynomial, Logarithmic, Power series, or Moving average. For sales data that's growing steadily, Linear is a great starting point.
• Line color: It's a good practice to make the trendline a slightly different shade or the same color as its corresponding data line to keep things clean.
• Line thickness: You can make the trendline thicker or thinner to either stand out or be more subtle.
• Show R²: Checking this box displays the "R-squared" value on your chart. This is a statistical measure of how well the trendline fits your data (a value closer to 1 means a better fit).

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Step 4: Repeat for Each Additional Series

Now, this is the most important part. To add the next trendline, simply go back to the top of the Series section.

Click the series dropdown menu again (which currently says "Product Alpha Sales") and select your next data series, "Product Beta Sales."

Then, scroll down and check the Trendline box. Customize its color and thickness as needed. Repeat this simple process for your final series, "Product Gamma Sales."

That's it! You now have a single, clean chart showing the performance of three different products, each with a distinct trendline tracking its trajectory. In our example, you'd clearly see that Product Alpha has the steepest positive growth, while Product Gamma's trend is heading slightly downward, providing an immediate and powerful insight.

Choosing the Right Type of Trendline

Google Sheets offers a few different trendline models. Choosing the right one helps you tell a more accurate story with your data.

• Linear: Best for data that is increasing or decreasing at a constant rate. Think of a simple, straight line. This is great for things like a consistent monthly increase in subscribers or steady sales growth.
• Exponential: Use this when your data is growing or shrinking at an accelerating rate. The line will be a curve. This is perfect for modeling viral growth, compound interest, or any value that multiplies over time.
• Polynomial: This one is more flexible and can be used for datasets that have a few ups and downs. A polynomial trendline can have curves and bends, making it useful for tracking data with seasonality or cycles (e.g., higher sales in Q4).
• Moving Average: This isn't a predictive model like the others. Instead, it smooths out short-term noise to help you identify the overall trend more clearly. It's excellent for stock prices or volatile website traffic, where daily spikes can hide the bigger picture.

An Advanced Trick: The Calculated Column Workaround

What if you want to show a trendline for the total sales, in addition to the trendlines for each individual product, all on the same chart? The default Series editor doesn't have an option for this. But there's a clever workaround.

1. Create a Helper Column: In your data table, create a new column called "Total Sales." In the first cell of that column (cell E2 in our example), enter a formula to sum the sales of all three products: =SUM(B2:D2) Then, drag this formula down to calculate the total for each row.

2. Add the New Data to Your Chart: Double-click your chart to open the Chart editor. Go to the Setup tab. Click on the Data range field. You’ll need to adjust the range to include your new "Total Sales" column. If your original range was A1:D7, change it to A1:E7.

Now you'll see a fourth line on your chart representing Total Sales.

3. Add a Trendline to the Total... and Hide the Line: Go back to the Customize > Series tab. Select your new "Total Sales" series from the dropdown. Check the Trendline box to add a trendline for the total sales data. But wait - now the chart might look too crowded with four lines.

Here’s the magic trick. While still in the "Total Sales" series options, change the Line thickness to 0 px. The "Total Sales" line will vanish, but its trendline will remain! This leaves you with a clean chart showing the three individual product lines, their respective trendlines, and a single, overarching trendline showing the direction of total sales.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Best Practices for Clear Visualizations

• Focus on a Clear Story: Adding too many lines and trendlines can make a chart impossible to read. Stick to three to five data series at most for a single comparison.
• Use Color Strategically: Don't rely on the defaults. Assign distinct, easy-to-differentiate colors to each series. Try to make the trendline a darker shade of the color of its data line.
• Label Everything: Always give your chart a descriptive title (e.g., "Quarterly Sales Trend by Product"). Ensure your legend and axis labels are clear and easy to understand.

Final Thoughts

Adding multiple trendlines to a Google Sheets chart is a straightforward process once you know to adjust each series individually. It’s a powerful technique for moving beyond simple data presentation and into comparative analysis, enabling you to spot winners, laggards, and growth opportunities at a glance.

While mastering these tricks in Google Sheets is incredibly useful, we know the process of preparing data and fiddling with chart settings can sometimes feel like a chore. At Graphed, we’ve made it our mission to eliminate this friction. Instead of manually editing series and building reports, you can connect your data sources (like Google Analytics, Shopify, or your CRM) and simply ask for what you want in plain English. Requesting "a line chart comparing sales trends for Product Alpha, Beta, and Gamma" will instantly generate a real-time, shareable dashboard, letting you get straight to the insights without all the clicks.