Dual axis charts in Tableau - Dashboard Guide

Dashboard Mode - Dual axis charts

Business Question

How can we compare monthly sales and profit trends together to see their relationship over time?

Sample Data

Month	Sales	Profit
January	1000	200
February	1500	300
March	1300	250
April	1700	400
May	1600	350
June	1800	450

Dashboard Components

• Line Chart - Sales Trend: Plots SUM(Sales) by Month on primary Y-axis.
• Line Chart - Profit Trend: Plots SUM(Profit) by Month on secondary Y-axis.
• Dual Axis Chart: Combines Sales and Profit lines sharing the same X-axis (Month) but separate Y-axes for clear comparison.
• Tooltip: Shows exact Sales and Profit values when hovering over each month.

Dashboard Layout

+---------------------------------------+
|           Dual Axis Chart              |
|  (Sales on left Y-axis, Profit right) |
|                                       |
|  Month on X-axis                      |
+---------------------------------------+

Interactivity

A filter for Month allows selecting one or multiple months. When applied, the dual axis chart updates to show sales and profit trends only for the selected months.

Self Check

If you add a filter to show only March to May, which months appear on the chart? What happens to the sales and profit lines?

Key Result

A dual axis line chart comparing monthly sales and profit trends side by side.