How to Combine 2 Graphs in Tableau

Want to see how your ad spend impacts website traffic on the same chart? Or maybe compare your revenue to your profit ratio without flipping between two different graphs? Combining charts in a single view helps you spot connections and tell a more powerful data story. This tutorial will walk you through the two most effective ways to combine graphs in Tableau: using a dual-axis and a shared-axis.

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 the First Place?

Jumping between separate charts makes it tough to identify relationships. When you bring two related metrics into one shared space, you can immediately start asking smarter questions. It’s all about context. Seeing a spike in sales is nice, but seeing that it happened right after a marketing campaign spend increased is a real insight.

Combining graphs helps you:

• Compare metrics with different scales: Track revenue (in hundreds of thousands) against click-through rate (a small percentage) without one dwarfing the other.
• Identify correlations: Does your website session duration go up when you publish new blog posts? Putting them on the same timeline makes the connection obvious.
• Save dashboard space: Instead of two separate visuals taking up valuable real estate, you can create one compact, information-rich chart.

The Core Methods: Dual-Axis vs. Shared-Axis

Tableau offers two primary methods for merging graphs. Knowing which one to use depends on the data you’re working with.

Dual-Axis Charts

This is your go-to method when you want to compare two different measures that have very different scales. A classic example is plotting sales figures (which could be in the thousands or millions) against profit ratio (which is a percentage). A dual-axis chart assigns one measure to a left-side Y-axis and the second measure to a right-side Y-axis, letting each have its own distinct scale while sharing the same X-axis (usually a time period).

Use a dual-axis chart when:

• You're comparing measures of different types (e.g., currency and percentages, or counts and averages).
• You want to use different chart types for each measure (like combining a bar chart with a line graph).

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

Shared-Axis (or Combined-Axis) Charts

Unlike a dual-axis chart, a shared-axis chart uses a single Y-axis for multiple measures. This works best when your measures share the same scale and unit. For example, if you wanted to compare your planned sales target against your actual sales, both would be measured in dollars and would fit perfectly on the same axis.

Use a shared-axis chart when:

• You're comparing measures with the same unit and a similar scale (e.g., Sales vs. Target Sales, or Website Traffic vs. Returning Visitors).
• You want to see how different segments of a single measure compare, like breaking down total sales by product category on the same line graph.

How to Create a Dual-Axis Chart: A Step-by-Step Guide

Let's build a common business dashboard view: comparing total sales (shown as a bar chart) with profit ratio (shown as a line graph) over time. This will clearly show months where high sales didn’t necessarily translate to high profitability.

For this example, we’ll be using Tableau's sample "Superstore" dataset.

Step 1: Create Your First Chart (Sales Over Time)

First, let's create a simple bar chart showing sales per month.

1. Drag Order Date from the Data pane onto the Columns shelf. Right-click the pill and make sure it's set to Month (you can choose the continuous "MONTH(Order Date)" for a smooth line or the discrete "Month" for separate bars per month).
2. Drag the Sales measure onto the Rows shelf.

You should now have a basic bar chart showing sales for each month.

Step 2: Add Your Second Measure

Now, let's bring the profit ratio into the view. It will initially appear as its own chart.

1. Drag the Profit Ratio measure onto the Rows shelf, placing it to the right of the existing SUM(Sales) pill.

Tableau will now display two separate charts, stacked vertically. The top one shows sales and the bottom one shows the profit ratio.

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 3: Create the Dual Axis

This is where the magic happens. We'll merge these two charts into one view.

1. On the Rows shelf, right-click the Profit Ratio pill.
2. Select Dual Axis from the dropdown menu.

The two charts will now overlay each other. You'll see two Y-axes appear — one on the left for Sales and a new one on the right for Profit Ratio.

Step 4: Adjust Mark Types

Right now, Tableau is probably displaying both measures as circles or bars, which isn't very clear. Let’s change one to a line graph for better readability.

1. Look at the Marks card. You will now see tabs for "All," "SUM(Sales)," and "SUM(Profit Ratio)." This lets you control each measure independently.
2. Click on the SUM(Sales) Marks card. Click the dropdown menu and select Bar.
3. Now click on the SUM(Profit Ratio) Marks card. Click the dropdown menu and change it to Line.

You now have a clean, easy-to-read chart with sales as bars and profit ratio as an overlaid line.

Step 5 (Optional but Recommended): Synchronize Your Axes

Sometimes, the two axes need to be aligned to tell an honest story. If you're comparing two measures that should share a common baseline (like sales and target sales), you must synchronize them. For measures with completely different scales (like dollars and percentages), this isn’t always necessary. However, it's a good practice to know how.

1. Right-click on the right-hand axis (in our case, the Profit Ratio axis).
2. Select Synchronize Axis.

This ensures that the gridlines and scales align logically.

How to Create a Shared-Axis Chart

What if you want to compare Sales across different regions on the same line chart? This is a perfect job for a shared axis, since you’re using one measure (Sales) broken down by a dimension (Region).

Step 1: Create a Basic Line Chart

1. Drag Order Date to the Columns shelf (set it to continuous Month).
2. Drag Sales onto the Rows shelf.

This gives you a single line representing total sales over time.

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 2: Add a Dimension to Separate the Lines

The simplest way to create multiple lines on a shared axis is by using a dimension to break down the single line.

1. Find the Region dimension in your Data pane.
2. Drag Region onto the Color tile on the Marks card.

And that’s it! Tableau automatically splits the single Sales line into four separate lines — one for each region — and assigns them different colors. You now have a single, shared Y-axis representing sales, but with multiple lines for easy comparison.

Common Pitfalls and Best Practices

While combining graphs is powerful, a few simple rules will keep your visualizations clear and honest.

• Don’t Overclutter: Just because you can combine charts doesn't mean you should layer five different metrics onto one another. In most cases, two or three measures are the maximum for a readable chart. Any more, and the story becomes lost in a tangle of lines and bars.
• Use Color and Mark Types Strategically: Use distinct colors so your audience can easily tell which line or bar belongs to which measure. Combining bars with lines is also a classic trick because it is visually clean and easy to interpret. A bar can represent a volume (like sales), while a line can represent a rate or trend (like profit margin).
• Beware of Misleading Scales: With dual-axis charts, showing two axes with vastly different, unsynchronized ranges can create the illusion of a strong correlation where none exists. Always double-check that your chart is representing the data fairly, and make sure your axes are clearly labeled so readers understand what they are looking at.

Final Thoughts

You’ve now learned the key methods for combining graphs in Tableau, whether you're using a dual-axis for different scales and mark types or a shared-axis for comparing similar measures. These techniques are fundamental for turning flat data points into compelling visuals that reveal deeper business insights and drive better decisions.

Of course, we know that spending hours dragging and dropping, adjusting axes, and setting mark types in complex BI tools can be a major drain on your time. We built Graphed to solve this by ditching the steep learning curve entirely. Instead of following multi-step tutorials, you simply ask in plain English, "Show me my sales as a bar chart and my profit ratio as a line chart for the last 12 months," and get a live, interactive dashboard instantly. It’s the easiest way to get the answers you need without becoming a data visualization expert.