How to Graph Multiple Data Sets in Google Sheets

Comparing different trends in one place can instantly reveal what’s working, what's not, and where surprising correlations exist. While it might sound complicated, Google Sheets makes graphing multiple data sets in a single chart surprisingly straightforward. This guide will walk you through a few common methods, like creating combo charts, line charts with multiple series, and stacked visualizations, to help you tell a more complete story with your data.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Why Visualize Multiple Data Sets in One Chart?

Plotting multiple sets of data together isn’t just about making your reports look more complex, it’s about providing context and discovering insights you’d miss by looking at them separately. When you combine related metrics in one visual, you can instantly compare performance, identify relationships, and tell a clearer story.

Here are a few common scenarios where this is incredibly useful:

• Marketing Campaign Analysis: Visualize your ad spend against website traffic and conversions to see the direct impact of your budget changes.
• Sales Performance: Track the monthly sales revenue of several different products on a single line chart to see which one is growing fastest.
• Website Analytics: Compare your overall website sessions to your conversion rate on a combo chart to understand how traffic volume affects user behavior.
• Content Engagement: Plot blog pageviews alongside newsletter sign-ups to see which articles are most effective at driving lead generation.

In all these cases, the combined chart gives you an at-a-glance understanding that isolated numbers simply can’t provide.

Setting Up Your Data for Success

Before you even think about creating a chart, the single most important step is organizing your data properly. A clean data set is the foundation of a readable and accurate chart. Messy data guarantees a messy chart.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

The Golden Rule of Data Organization

The key principle is this: your data should be arranged in clear columns. Your very first column should almost always be your shared x-axis label — typically time (Day, Week, Month) or categories (Product Name, Traffic Source). Every subsequent column should contain a different numerical data set (a series) that you want to plot.

For example, if you want to compare the sales of three different products over four months, your data should look like this:

With this structure, Google Sheets will instantly understand that 'Month' is your label and each 'Product Sales' column is a separate series to be plotted against it.

Method 1: Creating a Combo Chart for Different Scales

The combo chart is your best friend when you want to compare two types of data that are measured on wildly different scales. A classic example is plotting website traffic (measured in thousands or millions) against your conversion rate (measured as a small percentage). If you put them on the same axis, your conversion rate line will look completely flat and useless.

Step-by-Step Guide to a Combo Chart

1. Select your data: Click and drag your cursor to highlight all the cells containing the data you want to plot, including the column headers.
2. Insert the chart: Go to the top menu and click on Insert > Chart. Google Sheets will generate a default chart based on its best guess.
3. Choose ‘Combo chart’: The Chart editor panel will appear on the right side of your screen. Under the Setup tab, click the Chart type dropdown and scroll down to select the Combo chart option.
4. Assign a second axis: This is the critical step. Navigate to the Customize tab in the chart editor.

You’ll immediately see a second y-axis appear on the right side of your chart, and your previously flat line will now be properly scaled and visible. You can also change the Type for each series here, allowing you to represent traffic with columns and conversion rate with a line, all in the same visual.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Method 2: Plotting Multiple Series on a Line Chart

A line chart is perfect for comparing similar metrics over time. If your data sets share a similar scale (like traffic from different sources or sales from different products), this method provides a very clean and easy-to-read comparison.

Step-by-Step Guide to a Multi-Line Chart

1. Select your organized data: Just as before, highlight your entire data range, including headers.
2. Insert the chart: Go to Insert > Chart. For time-based data with multiple columns, Google Sheets is pretty smart and will often default to a line chart, but you can always select it manually.
3. Change to a Line Chart: If Sheets guessed wrong, use the Chart type dropdown in the Chart editor and select Line chart.
4. Format for clarity: With multiple lines, details matter. Go to the Customize tab to make your chart more readable:

Method 3: Using Stacked Column or Bar Charts

Stacked charts are fantastic when you want to show not only how different parts compare to each other but also how they contribute to a whole. For example, you can see your total monthly revenue and, within each month's column, see the breakdown of how much came from Product A, B, and C.

Step-by-Step Guide to a Stacked Chart

1. Select your data table.
2. Navigate to Insert > Chart.
3. Choose a Stacked Chart: In the Chart type dropdown, you’ll find options like Stacked column chart and Stacked bar chart. Select the one that fits your data.
4. Consider the '100% Stacked' option: You will also see a 100% stacked column chart. This variant is useful when you care more about the relative proportion of each component rather than the raw total. It makes every column the same height (100%) and shows the percentage contribution of each segment. This is great for showing changes in market share or traffic sources over time.

Quick Troubleshooting and Pro Tips

Even with the best setup, charts can sometimes go rogue. Here are a few common issues and tips to fix them.

Problem: "My chart looks like a mess, or one series is missing."

This is almost always a data selection problem. In the Chart editor, go to the Setup tab and double-check the Data range. You can click the grid icon to re-select your range manually and ensure you haven't accidentally missed a column or included empty rows.

Problem: "The horizontal axis isn't grouped correctly."

If you're plotting data on an x-axis and your labels aren't aggregating, check the Setup tab. You may need to check the box next to Aggregate for your first column to group the values correctly (e.g., show one 'January' data point instead of multiple ones).

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Pro Tip: Graphing Non-Adjacent Columns

What if you want to compare your first column (e.g., a date) with your third and fifth columns, skipping the ones in between? You don't need to create a new table. Simply select the columns you want to plot this way:

• Click and highlight your first column (e.g., column A).
• Hold down the Ctrl (on Windows/ChromeOS) or Command (on Mac) key on your keyboard.
• While holding the key, click and highlight the other columns you want to include (e.g., columns C and E).
• Once all desired columns are selected, go to Insert > Chart, and Google Sheets will only graph the data you selected.

Final Thoughts

Visualizing multiple data sets in Google Sheets comes down to organizing your data logically in columns and then choosing the right chart — like a combo chart for different scales, a line chart for trends, or a stacked chart for parts of a whole. By customizing attributes like a second axis, titles, and legends, you can build clear, compelling visuals that turn raw numbers into actionable insights.

Of course, the whole process of exporting data from different platforms, cleaning it up in spreadsheets, and manually building these charts can still take up hours every week. That’s precisely why we built Graphed. We wanted a way to connect all our sources — like Google Analytics, Shopify, and Facebook Ads — in one click and get these cross-platform insights instantly. Instead of wrangling columns, you can just ask, "Show me a chart comparing last month's ad spend from Facebook vs. Google, plotted against total Shopify revenue." We handle connecting the data and building the live dashboard for you in seconds.