Tableau Dual Axis Chart Tutorial

If you are working with data in Tableau, creating a dual axis chart is one of the most powerful ways to compare two different measures in a single visualization.

Whether you are overlaying a bar chart with a line to show revenue alongside growth rate, combining actual vs target performance on one view, plotting temperature and rainfall on the same chart, or tracking two KPIs with different scales side by side — dual axis charts are how you tell a richer data story without building two separate charts.

In this guide, we will break down every major way to build and customize dual axis charts in Tableau with clear, step-by-step instructions you can follow immediately.

Setting Up the Example Dataset

We will use one consistent dataset throughout this guide. You can replicate this in Tableau using a simple Excel or CSV file.

Month        Revenue ($)    Orders    Growth Rate (%)
January      42000          310       —
February     38000          275       -9.5
March        51000          390       34.2
April        47000          355       -7.8
May          63000          480       34.0
June         58000          430       -7.9
July         71000          540       22.4
August       69000          510       -2.8
September    74000          560       7.2
October      82000          620       10.8
November     91000          700       11.0
December     88000          670       -3.3

Load this into Tableau by connecting to your Excel or CSV file via Data > Connect to Data > Microsoft Excel (or Text File for CSV).

Method 1: Basic Dual Axis Chart — Bar and Line

The most common dual axis chart in Tableau combines a bar chart for one measure and a line chart for a second. This is the foundation you should learn first.

Step-by-step:

Step 1 — Build the first axis

• Drag Month to the Columns shelf
• Drag Revenue to the Rows shelf
• Tableau will create a bar chart by default. If not, go to Marks > Bar

Step 2 — Add the second measure

• Drag Orders to the Rows shelf and drop it to the right of the existing Revenue pill
• Tableau now shows two separate charts stacked vertically

Step 3 — Create the dual axis

• Right-click the Orders pill on the Rows shelf
• Select Dual Axis from the dropdown menu
• Both measures now share the same chart space

Step 4 — Change the second mark type

• In the Marks card, you will now see three tabs: All, SUM(Revenue), and SUM(Orders)
• Click the SUM(Orders) tab
• Change the mark type from Bar to Line

Step 5 — Synchronize the axes

• Right-click the right-hand axis (Orders)
• Select Synchronize Axis
• This aligns both axes to the same scale — skip this step if your two measures have very different ranges and you want each to use its own scale

Result: A bar chart showing monthly revenue with a line overlay showing order volume — both on the same view.

Method 2: Dual Axis With Different Scales

When your two measures have very different value ranges — for example, Revenue in the tens of thousands and Growth Rate as a percentage — you should keep each axis on its own independent scale rather than synchronizing them.

Step-by-step:

Step 1 — Follow Method 1 steps 1 through 4 using Revenue and Growth Rate (%) as your two measures

Step 2 — Skip axis synchronization

• Do not right-click to synchronize
• Tableau will automatically scale each axis independently — Revenue on the left, Growth Rate on the right

Step 3 — Label both axes clearly

• Double-click the left axis and rename it Revenue ($)
• Double-click the right axis and rename it Growth Rate (%)
• Clear axis labels are critical when scales differ — readers need to know which axis belongs to which measure

Step 4 — Add a reference line at zero for Growth Rate

• Right-click the right axis
• Select Add Reference Line
• Set value to 0, label to None, and line style to a thin dashed line
• This makes it immediately clear which months had positive vs negative growth

Result: Bars showing absolute revenue with a line showing growth rate percentage — each on its own appropriately scaled axis.

Method 3: Dual Axis Bar Chart — Actual vs Target

A popular business use case is comparing actual performance against a target on the same chart. This uses two bar mark types layered on top of each other.

Step-by-step:

Step 1 — Add a Target column to your dataset

Month        Revenue ($)    Target ($)
January      42000          45000
February     38000          40000
March        51000          48000
April        47000          50000
...

Step 2 — Build the first bar

• Drag Month to Columns
• Drag Revenue to Rows
• Set mark type to Bar

Step 3 — Add Target as dual axis

• Drag Target to Rows next to Revenue
• Right-click Target pill > Dual Axis
• Set the Target mark type to Bar as well

Step 4 — Adjust bar sizes to create layering

• Click the SUM(Target) Marks tab
• Reduce the Size slider so the Target bar appears thinner than the Revenue bar
• This creates a visual overlay where the thin target bar sits in front of or behind the revenue bar

Step 5 — Color the bars for clarity

• Set Revenue bar color to a neutral blue or grey
• Set Target bar color to orange or red
• Add a Color Legend label so readers know which is which

Result: A clean actual vs target comparison where both bars share the same axis and the visual difference immediately signals whether targets were met.

Method 4: Dual Axis With Circle and Bar

Another popular combination is using bars for the primary measure and circles (dots) for a secondary measure — useful for showing averages or benchmarks alongside totals.

Step-by-step:

Step 1 — Build Revenue bars

• Drag Month to Columns
• Drag Revenue to Rows
• Mark type: Bar

Step 2 — Add Orders as dual axis

• Drag Orders to Rows
• Right-click > Dual Axis

Step 3 — Change Orders to Circle

• Click the SUM(Orders) Marks tab
• Change mark type to Circle
• Increase the circle size slightly so it is visible against the bars

Step 4 — Format the circles

• Set circle color to a contrasting color (e.g., dark orange against grey bars)
• Add a label to the circles showing the Orders value for each month

Result: Bars for revenue with prominent circles marking order volume — easy to read and visually distinct.

Method 5: Dual Axis Map (Advanced)

Tableau also supports dual axis on map views — layering two spatial mark types, such as filled regions and proportional circles, on the same map.

Step-by-step:

Step 1 — Set up a geographic dimension

• Ensure your dataset has a geographic field (Country, State, City)
• Double-click the geographic field — Tableau automatically creates a map

Step 2 — Add a measure to the map

• Drag Revenue to the Color shelf on the Marks card
• This creates a filled/choropleth map

Step 3 — Add a second measure as dual axis

• Drag Orders to the Rows shelf
• Right-click > Dual Axis

Step 4 — Set second layer to Circle

• On the second Marks tab, change mark type to Circle
• Drag Orders to the Size shelf — circles will scale proportionally by order volume

Step 5 — Synchronize axes

• Right-click the second axis > Synchronize Axis
• Hide the right-hand axis since the map does not need visible axis lines

Result: A map where regions are colored by revenue intensity and proportional circles show order volume — two dimensions of insight in one spatial view.

Comparison Table: Dual Axis Chart Combinations

Combination	Best For	Synchronize Axis?
Bar + Line	Volume vs trend over time	Only if same scale
Bar + Bar (layered)	Actual vs target comparison	Yes
Bar + Circle	Totals vs individual data points	No
Line + Line	Two trends with different scales	No
Map + Circle	Geographic intensity + volume	Yes
Bar + Area	Cumulative vs periodic values	No

Real-World Use Cases

Sales Performance — Revenue and Growth Rate

Bars: Monthly Revenue
Line: Month-over-Month Growth Rate (%)
Left axis: Revenue ($)
Right axis: Growth Rate (%)
Insight: Quickly spot which high-revenue months were driven by real growth vs seasonal baseline

Marketing Analytics — Impressions and Conversion Rate

Bars: Ad Impressions (volume)
Line: Conversion Rate (%)
Left axis: Impressions
Right axis: Conversion Rate (%)
Insight: High impressions with low conversion rate signals targeting or creative issues

Operations Dashboard — Orders and Fulfillment Time

Bars: Daily Orders
Line: Average Fulfillment Time (hours)
Left axis: Order Count
Right axis: Hours
Insight: Identify whether fulfillment time increases on high-volume days

Common Mistakes to Avoid

Forgetting to synchronize axes when measures are on the same scale — If both measures use the same unit (e.g., two revenue streams both in dollars), always synchronize the axes. Unsynchronized axes with the same scale make comparisons misleading:

Right-click the right axis > Synchronize Axis

Synchronizing axes when scales are very different — The opposite mistake is equally common. If Revenue is in the hundreds of thousands and Growth Rate is a small percentage, synchronizing the axes will flatten the line into a near-invisible flat line at the bottom of the chart.

Using the same color for both mark types — When two marks overlap on a dual axis chart, identical colors make it impossible to tell them apart. Always assign clearly distinct colors to each measure and include a legend.

Overcrowding the chart with too many marks — Dual axis charts work best with two measures. Adding a third measure, extra labels, and gridlines on both axes creates visual noise that hides the insight. Keep it clean.

Not labeling both axes — When axes have different scales, both must be clearly labeled. A chart with an unlabeled right axis forces the reader to guess what the line or second bar represents:

Double-click each axis > Edit Axis Title > add a clear descriptive name

Using dual axis when a calculated field would be cleaner — If your two measures are closely related (e.g., profit and profit ratio), consider whether a single calculated field or a table calculation would tell the same story more simply before reaching for dual axis.

Dual axis charts in Tableau are one of the most versatile tools in a data analyst’s visualization toolkit. Once you are comfortable building them, you will find they consistently produce some of the clearest and most insightful views in any dashboard.

Here is the simplest decision guide:

• Compare volume and trend → Bar + Line, unsynchronized axes
• Compare actual vs target → Bar + Bar, synchronized axes
• Compare totals and data points → Bar + Circle
• Compare two trends → Line + Line, unsynchronized axes
• Geographic intensity and volume → Map + Circle
• Same unit, two measures → always synchronize axes

Start with the Bar + Line combination — it is the most common and covers the widest range of use cases. Once that feels natural, experiment with layered bars for target comparisons and circle overlays for benchmark views. Master those three combinations and you will be able to handle almost any dual-measure visualization requirement in Tableau.

FAQs