How to Make Two Graphs in One Chart in Google Sheets

Showing two different sets of data on a single chart in Google Sheets is one of the most effective ways to tell a compelling story, revealing trends and connections that might otherwise be missed. This guide will walk you through a few different methods for making a single chart with two graphs, helping you compare different metrics and build more insightful reports.

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 Combine Graphs in Google Sheets?

Before diving into the "how," it's helpful to understand the "why." While creating separate charts is easy, combining them into one offers some significant advantages that can make your dashboards much more powerful.

• Direct Comparison: The most obvious benefit is the ability to directly compare the performance of two different metrics over the same period. For example, you can plot your website traffic next to your sales revenue to see how they influence each other month-over-month.
• Revealing Relationships and Correlations: Are your marketing campaigns driving actual sales? By plotting ad spend (as a column chart) and conversion rates (as a line chart), you can instantly spot correlations. Seeing both metrics move - or not move - in relation to each other tells a much richer story than looking at them in isolation.
• Visualizing Data on Different Scales: This is a big one. Let's say you want to compare your monthly ad spend in thousands of dollars with your click-through rate, which is a small percentage. On a standard chart, the ad spend data would dwarf the percentage, rendering the click-through rate a flat, unreadable line at the bottom. Combo charts with a secondary axis solve this problem perfectly.
• Saving Dashboard Space: If you're building a dashboard, real estate is prime. Combining related metrics into a single, cohesive chart keeps your report clean, uncluttered, and easier for your audience to digest. Instead of two or three separate widgets, you have one that tells the full story.

First, Prepare Your Data

The foundation of any good chart is well-organized data. Before you even think about clicking 'Insert Chart,' take a moment to structure your data correctly. For a combo chart, the setup is straightforward but essential.

You need a shared category for your X-axis and at least two corresponding data series for your Y-axis (or axes). Most often, the shared X-axis will be a time period, like dates, months, or quarters. The other columns will contain the numerical data you want to plot.

Here's a typical layout for tracking monthly store visitors against total sales:

Example Data Structure:

• Column A: Month (Jan, Feb, Mar, Apr, May, etc.)
• Column B: Store Visitors (5200, 5800, 6500, 7100, 6900)
• Column C: Total Sales ($) (25000, 27500, 32000, 35000, 33000)

Make sure each column has a clear header. Google Sheets uses these headers to automatically title your axes and create legends, which saves you a ton of time later.

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

Method 1: Creating a Basic Combo Chart

A combo chart is Google Sheets' dedicated feature for plotting multiple series that might require different chart types. The most common combination is columns and lines. Let's start with a classic example: comparing sales revenue with the number of units sold.

Let's use this data:

Here's how to create the chart a column/line combo chart:

1. Select your data: Click and drag to highlight all the cells containing your data, including the headers (e.g., A1 through C7).
2. Insert the chart: Go to the menu and click Insert > Chart.
3. Choose the chart type: Google Sheets is pretty smart and will likely suggest a Combo chart. If it doesn't, navigate to the Setup tab in the Chart editor on the right side of your screen. Click the 'Chart type' dropdown and scroll down to select Combo chart.

Initially, both 'Units Sold' and 'Revenue' will appear as columns crammed together. That's okay - we'll fix it in the next step.

Customizing the Series Type

To make this chart readable, you need to change one of the data series to a different type, like a line. This is where the magic happens.

1. With your Chart editor still open, click the Customize tab.
2. Click on the Series drop-down menu.
3. By default, it will be set to 'Apply to all series.' Click the chooser and select the data series you want to change - for example, 'Revenue.'
4. You'll now see customization options just for the Revenue series. Find the dropdown menu for Type and change it from Columns to Line.

Instantly, your chart transforms. Now you have a clear column graph representing 'Units Sold' and an overlaying line graph showing the trend of 'Revenue'. This immediately makes the relationship between the two metrics much easier to analyze.

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

Method 2: Using a Secondary Axis for Different Scales

Now, let's tackle the most common challenge: two datasets with vastly different scales. Imagine trying to compare your monthly website sessions (in the tens of thousands) with your conversion rate (a small percentage between 1% and 5%).

Here's our sample data:

If you plotted both of these on a single Y-axis, the 'Conversion Rate' line would be so close to zero that it would be completely useless. The secondary axis is the solution.

Follow the same steps as Method 1 to create a basic combo chart (putting 'Website Sessions' as columns and 'Conversion Rate' as a line). You'll see the flat line problem immediately.

Here is how to fix it by adding a right axis:

1. In the Chart editor, go to the Customize tab and open the Series section.
2. Select the series that's being flattened - in this case, 'Conversion Rate'.
3. Look for the Axis dropdown menu. By default, it's set to 'Left axis'. Click it and choose Right axis.

That's it! A new Y-axis appears on the right side of the chart, scaled specifically for your 'Conversion Rate' data. The 'Conversion Rate' line is now perfectly visible, plotting its own trend against the 'Website Sessions' columns. Now you can analyze both trends properly, seeing how your site traffic growth corresponds with your conversion efficiency.

Customizing Your Chart for a Professional Look

Creating the chart is only half the battle. A clean, well-labeled chart is critical for your audience to understand the story you're telling. Here are a few must-do customizations:

1. Add Clear Titles and Labels

Your chart needs a clear title, and both of your Y-axes must be labeled. Leaving a secondary axis unlabeled is one of the biggest mistakes you can make, as it leaves viewers guessing what the line represents.

• Go to the Customize > Chart & Axis Titles section in the Chart editor.
• Chart title: Give your chart a descriptive name, like "Monthly Website Sessions vs. Conversion Rate."
• Vertical axis title: Label your left axis, for example, "Total Website Sessions."
• Right axis title: This is the important one. Label your right axis clearly, such as "Conversion Rate (%)."

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

2. Adjust Series Formatting

A little color and formatting go a long way.

• In the Customize > Series section, you can select each series and change its appearance.
• Color: Change the column and line colors to match your brand or to create better visual contrast.
• Line style: For line graphs, you can change the line thickness, make it dashed, and add circular or triangular points to mark each data point more clearly.

3. Clean Up Gridlines and Backgrounds

Less is often more. By default, Google Sheets adds lots of gridlines that can make a chart look busy.

• Under Customize > Gridlines and Ticks, you can reduce the clutter.
• Consider removing the minor gridlines or changing the gridline color to a very light gray so they don't overpower your data. It helps the columns and lines pop.

Final Thoughts

Combining two graphs into a single combo chart is a powerful feature in Google Sheets for anyone who works with data. It allows you to create dense, information-rich visuals that reveal trends and correlations, all while keeping your dashboards clean and easy to understand. Mastering the use of a secondary axis, in particular, will elevate your reporting skills significantly.

Of course, building great marketing and sales reports often starts long before you get to the chart-making step. It involves hours of logging into different platforms, exporting CSVs, and manually wrangling data. At Graphed, we felt this pain, which is why we built a tool to automate it. Instead of manually pulling data, you can connect your sources (like Google Analytics, Shopify, or Facebook Ads) in a few clicks, and then just ask for what you want in plain English - such as, "show me a chart comparing ad spend and revenue by a campaign last month" - and receive a live, interactive dashboard instantly.