How to Merge Two Visualizations in Tableau

Combining two charts into one view in Tableau can instantly make your data story clearer and more compelling. Instead of asking your audience to compare two separate visualizations side-by-side, you can layer them together to reveal direct relationships, comparisons, and correlations. This article will walk you through the most effective methods for merging visualizations in Tableau, from creating standard dual-axis charts to more advanced dashboard layering techniques.

Why Merge Visualizations in the First Place?

Before jumping into the "how," let’s briefly touch on the "why." Merging visualizations isn’t just about making your dashboard look busy, it’s a strategic choice to improve data communication. Here are a few key benefits:

• Direct Comparison: The primary reason is to see how two different metrics relate to each other over the same dimension. For example, how do your marketing expenses and sales revenue trend over the same time period? Placing them on the same chart makes the relationship immediate and obvious.
• Save Valuable Dashboard Space: Dashboards have limited real estate. Combining two related charts into a single, cohesive visualization allows you to convey more information in a smaller footprint, leaving room for other critical insights.
• Provide Richer Context: A single metric can be misleading without context. Plotting sales figures as a bar chart is useful, but layering on a line chart of your profit margin for those sales provides a much deeper, more complete picture of business health.

Method 1: The Dual-Axis Chart (The Go-To Technique)

The dual-axis chart is the most common and powerful way to merge two visualizations that have different scales. Think of it as layering one chart on top of another and giving each its own y-axis (one on the left, one on the right). This is perfect for comparing metrics like sales volume (in millions of dollars) and quantity sold (in thousands of units).

Let's build a classic example: a view that combines a line chart for Sales over time with a bar chart showing Profit over the same period.

Step-by-Step Guide to Creating a Dual-Axis Chart

For this walkthrough, we'll use Tableau's Sample Superstore dataset.

1. Create Your First Visualization

First, let’s create a simple line chart showing sales over time.

• Drag Order Date onto the Columns shelf. Right-click the pill and make sure it’s set to a continuous timeframe, like Month (the green option).
• Drag Sales onto the Rows shelf.

You should now see a line chart of your sales over time. The basics are done.

2. Add the Second Measure

Next, we'll add our second metric, Profit.

• Drag Profit from the Data pane and drop it on the opposite side of the visualization, onto the Rows shelf, to the right of the SUM(Sales) pill.

Tableau will now display two separate line charts, one stacked on top of the other. We’re on our way, but they aren’t merged yet.

3. Create the Dual Axis

This is where the magic happens. We’ll tell Tableau to use a second axis for our Profit measure.

• On the Rows shelf, right-click the SUM(Profit) pill.
• From the context menu, select Dual Axis.

Tableau will instantly superimpose the two charts and add a second axis on the right side of your view for Profit. It’s starting to look like one cohesive chart!

4. Synchronize the Axes (Crucial!)

Hold on! Notice that the axes operate on different scales, which can be misleading if the measures are comparable. If two lines cross, does that mean they are equal? Not unless the axes are synced.

Note: You should only synchronize axes when the measures are on a similar scale or represent parts of a whole, such as “Percent of Total” vs “Total Number.” If you're comparing revenue (in millions) and unit count (in thousands), do NOT synchronize the axes.

• Right-click the secondary axis (in this case, the Profit axis on the right).
• Select Synchronize Axis.

Now, both axes will use the same scale, providing a true and accurate comparison between the two measures.

5. Customize Your Mark Types

The final step is to assign different chart types to each measure to make the visualization easier to read. For our example, we want Sales as a line and Profit as bars.

• On the Marks card, you will now see three tabs: All, SUM(Sales), and SUM(Profit). This allows you to control the appearance of each measure independently.
• Click on the SUM(Sales) Marks card. From the dropdown menu, select Line.
• Now click on the SUM(Profit) Marks card. From the dropdown menu, select Bar.

You can also adjust colors, opacity, and line thickness from these individual Marks cards to further distinguish the two visuals. Voilà! You have merged a line chart and a bar chart into one insightful dual-axis visualization.

Method 2: The Combined Axis Chart (Shared Axis)

What if your two measures share the exact same scale and you want them on a single axis? A combined axis chart (also known as a shared axis chart) is your answer. Unlike a dual-axis chart which has two separate axes, this method plots multiple measures against a single, shared axis.

This is ideal when you're comparing "like for like" measures, such as Sales vs. Target Sales or Website Visits vs. Website Pageviews.

In this approach, you "blend" measures together.

How to Create a Combined Axis Chart

1. Start with a single measure. Drag a dimension like Product Category to Columns and a measure like Sales to Rows. This gives you a standard bar chart.
2. Add another measure to the same axis. Now, drag a second measure, like Profit, from the Data pane directly onto the existing Sales axis in the visualization. Wait until you see a pair of green parallel bars appear, then drop the measure.
3. Tableau does the rest. Tableau will automatically create a combined axis chart. It does this by adding the Measure Names pill to the Color shelf and the Measure Values pill to the Rows shelf, effectively displaying both measures in the same chart pane against a single shared y-axis. You now have a side-by-side bar chart useful for direct comparison of values.

Method 3: Layering Visuals with Floating Sheets on a Dashboard

Sometimes you need more flexibility than what dual-axis or combined-axis charts can offer. For example, what if you want to overlay a set of KPI numbers on top of a geographical map, or place a summary bar chart over a detailed timeline?

For this kind of complete creative freedom, you can use dashboard layering. The trick is to toggle the dashboard layout from the default "Tiled" to "Floating".

Steps to Layer Visualizations on a Dashboard

1. Create your visualizations on separate worksheets. First, build the individual charts you want to merge. For this example, let's say you have a map of the United States colored by sales on one sheet (let's call it "Sales Map") and a bar chart of the top 5 sales states on another sheet ("Top States"). Go all out with formatting labels and axes. It's often helpful to hide everything except what you want to emphasize.
2. Create a new dashboard. Add a new dashboard to your workbook.
3. Switch to Floating layout. On the Dashboard pane, under "Objects," change the layout option from Tiled to Floating. This is the key. In Tiled mode, every object snaps into a grid. In Floating mode, you can place objects anywhere you want, including on top of each other.
4. Add your background sheet. Drag your background visual (the "Sales Map") onto the dashboard canvas. You can resize it and position it exactly where you'd like it to sit.
5. Add your foreground sheet. Now, drag your foreground visual (the "Top States" chart) and drop it on top of the map. Adjust its size and position. Often, a title may not be needed or may make the overlap look awkward. Click the main chart or filter, and on the upper right context area, click to toggle visibility.
6. Make the foreground background transparent. This step creates the seamless layered effect. Click on the foreground sheet container ("Top States"), select its dropdown menu (the little caret), go to Format, then in the Format Pane on the left, select the Shading tab shown by a paint bucket icon, and set that color to None. This removes the opaque background of the "Top State" chart, allowing the underlying map to show through.

This technique gives you ultimate control over the final look, but use it thoughtfully. Over-layering can create cluttered, confusing dashboards. It’s best reserved for simple, high-impact visuals.

Final Thoughts

Merging visualizations in Tableau using dual-axis, combined-axis, or dashboard layering techniques is a fantastic way to add depth and context to your data. Each method serves a different purpose, so choosing the right one depends on the story you want to tell and the nature of the data you're working with. Mastering these skills will elevate your dashboards from simple reports to insightful analytical tools.

While an expert in Tableau's functionality can execute quickly and build in mere moments, the path to learning how can take time and effort if you are new to Tableau or not yet proficient. I have trained over 30 marketing departments to learn at their own pace. Yet, many of them wish our training had just started sooner: "With Graphed, to speed things faster, our new users simply use natural language and the platform builds it for them." We also hear: "I do not always have time to do it myself: when my leadership came knocking, with Graphed, I was ready to answer the business need, 'on-the-spot'." Having real-time reports means your latest metrics are available without manual pulls. For dashboards or reports, your request comes alive. Just ask!