What is a Dual Axis Chart in Tableau?

Ever tried to visualize your monthly sales revenue and the number of units sold on the same chart? You might have noticed it's surprisingly difficult. Your revenue is in the thousands of dollars, while your units sold are in the hundreds. A standard bar chart or line graph just won't work - one measure will look flat while the other soars off the screen. This is precisely the problem a dual-axis chart is designed to solve in Tableau. This article will break down what a dual-axis chart is, when to use it, and how to create one step-by-step.

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

What Exactly is a Dual-Axis Chart?

A dual-axis chart is a visualization that combines two different measures using two independent vertical (Y) axes that share a common horizontal (X) axis. Think of it as laying two charts on top of each other. The Y-axis on the left represents the scale for your first measure, while the Y-axis on the right represents the scale for your second measure. The shared X-axis (usually representing time, like months or quarters) provides the common ground for comparison.

This structure is incredibly useful because it lets you compare measures that have completely different scales or units. You can effectively plot your Sales Revenue (in dollars) and your Website Traffic (in number of sessions) against the same timeline without either dataset distorting the other.

When Should You Use a Dual-Axis Chart?

Dual-axis charts are fantastic for uncovering relationships between different metrics, but they should be used intentionally. Here are a few common scenarios where they shine.

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

1. Comparing Measures with Wildly Different Scales

This is the classic use case. You want to see if there's a relationship between two metrics, but their values aren't in the same ballpark. A simple chart would render one of them almost invisible.

Example: A SaaS company wants to see if their growing number of active users correlates with their monthly revenue. They might be tracking millions of user sessions but only generating tens of thousands in revenue. A dual-axis chart lets them plot both trendlines clearly on a single graph, with one axis scaled for millions and the other for thousands.

• Left Axis (Y1): Revenue ($0 - $100,000)
• Right Axis (Y2): Active Users (0 - 2,000,000)
• Bottom Axis (X): Time (Month)

2. Showing the Relationship Between a Total and a Rate

Sometimes you need to visualize both a raw number and a related percentage or average to get the full picture. For example, knowing the total number of sales is helpful, but seeing the average discount percentage for those corresponding months provides much deeper context.

Example: An e-commerce manager wants to see how discounting strategies affect sales volume. They can plot the total number of units sold alongside the average discount percentage offered each month.

• Left Axis (Y1): Units Sold (#)
• Right Axis (Y2): Average Discount (%)
• Bottom Axis (X): Time (Month)

3. Combining Different Chart Types for Better Insights

One of the most powerful features of a dual-axis chart in Tableau is the ability to blend different mark types. You’re not limited to two line charts. You can combine a bar chart with a line chart, an area chart with circles, and more.

Example: A marketing manager wants to show their monthly ad spend as bars and the resulting website traffic as an overlaid line. This instantly makes it clear if spikes in spending correspond to spikes in traffic.

• Choose Bar Chart for Ad Spend ($).
• Choose Line Chart for Website Sessions (#).

This combination can communicate a story more effectively than two separate charts ever could.

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

How to Build a Dual-Axis Chart in Tableau (Step-by-Step)

Building a dual-axis chart is easier than you might think. Let's walk through an example using Tableau's sample "Superstore" dataset. Our goal will be to compare Sum of Sales (as bars) with the Sum of Profit (as a line) over time.

Step 1: Create the First Chart

First, build a simple line chart for your primary measure. Open a new sheet in Tableau and connect to the Superstore dataset.

• Drag the Order Date dimension to the Columns shelf. Make sure it's set to continuous Month (the green pill).
• Drag the Sales measure to the Rows shelf.

You should now see a line chart showing total sales across all months in your dataset. Great start!

Step 2: Add the Second Measure

Now, let's add our second measure. We want to see how profit relates to those sales numbers.

• Drag the Profit measure from your measures list and drop it directly onto the right side of the visualization, waiting until you see a dotted green line appear.

Tableau will automatically update the view to show two separate charts, one for Sales and one for Profit, stacked on top of each other. You'll also see that two green pills (SUM(Sales) and SUM(Profit)) are now in your Rows shelf.

Step 3: Create the Dual Axis

This is where the magic happens. We're going to merge these two charts into one.

• Find the SUM(Profit) pill in the Rows shelf.
• Right-click on the pill and select Dual Axis from the dropdown menu.

Voilà! The two charts are now combined. You'll see two Y-axes: one on the left for Sales and one on the right for Profit. Tableau has likely updated both marks to be circles by default, but we'll fix that next.

Step 4: Customize the Mark Types

A good dual-axis chart often uses different chart types to distinguish the two measures clearly. Let's make Sales a bar chart and keep Profit as a line chart.

1. Look at your Marks Card on the left. You'll now see three tabs: All, SUM(Sales), and SUM(Profit). This allows you to edit each part of the chart independently.
2. Click on the SUM(Sales) Marks card. In the dropdown menu that says "Automatic," change it to Bar.
3. Next, click on the SUM(Profit) Marks card. Change its type to Line.

Now you have a much clearer view: bars representing total sales, with a line representing the corresponding profit moving through them.

Step 5: Adjust Colors and Formatting

The last step is to clean up your visualization for clarity. A messy chart is an unhelpful chart.

• Colors: On each Marks card (for Sales and Profit), click the "Color" button to select distinct, easy-to-read colors.
• Axis Titles: Right-click on each Y-axis and select "Edit Axis." Give them clear titles like "Total Sales (USD)" and "Total Profit (USD)."
• Tooltips: Hover over the chart. The tooltips might be a bit messy. Click on the "Tooltip" button on each Marks card to edit the text and make it easy to understand when a user interacts with your visualization.

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

Pro Tip: To Synchronize or Not to Synchronize?

In our Sales vs. Profit example, both measures are in dollars, so their scales are comparable. You can right-click the right axis and select Synchronize Axis to force both Y-axes to use the exact same scale. This is important for an honest comparison when units are identical.

However, if you're comparing Sales (in dollars) to Units Sold (a count), you should not synchronize the axes. Doing so would make one of your measures look flat and insignificant. The power of a dual-axis chart is allowing these different scales to live together harmoniously.

Best Practices for Dual-Axis Charts

Building one is easy, but building a good one requires some thought. Keep these principles in mind:

• Be Clear with Labeling: Make it painfully obvious which line or bar belongs to which axis. Use distinct colors and clear legends or axis titles to prevent misinterpretation.
• Don’t Obscure the Data: If you use both an area chart and bars, ensure one doesn't completely hide the other. Adjust opacity or change the chart type so both measures are clearly visible.
• Avoid Correlating Unrelated Metrics: Just because you can plot two things together doesn't mean you should. Ensure the measures you're comparing have a logical, plausible relationship. Plotting sales against the number of sunny days might create an interesting-looking chart, but it’s unlikely to yield a meaningful business insight.

Final Thoughts

Dual-axis charts are a powerful tool in any analyst's Tableau toolbox. They allow you to layer different datasets, compare metrics on different scales, and uncover relationships that would otherwise be hidden in separate visualizations. Master this chart type, and you'll be able to tell much more compelling stories with your data.

Creating these charts in dedicated BI tools like Tableau becomes second nature with practice, but we know there's often a steep learning curve to get there. At Graphed , we've focused on eliminating that friction by letting you build visualizations using simple, conversational language. Instead of clicking through shelves and menus, you can just connect your marketing and sales data sources and ask questions like, "Create a bar chart of my sales revenue and a line chart of my marketing spend over the last quarter." We designed our platform to do the heavy lifting so you can get straight to the insights, not stuck on the setup.