What is a dual-axis chart, and how do you create one?

A dual-axis chart overlays two measures on the same view, each with its own independent Y-axis, so you can compare two metrics with different scales side by side in one chart rather than two separate ones.

Columns: [Order Date] (by month)
Rows:    SUM([Sales])
         SUM([Profit])   -- drag onto the same Rows shelf area
-> right-click the second measure's axis -> "Dual Axis"

1. Place the first measure on the Rows shelf as usual.
2. Drag the second measure onto the Rows shelf, next to (not replacing) the first — this initially creates two separate stacked panes.
3. Right-click the axis for the second measure and choose Dual Axis to merge them into one shared plot area with two Y-axes.
4. Optionally right-click one axis and choose Synchronize Axis if you want both measures to share the same scale instead of independent ones.

A classic use case is plotting Sales as bars and Profit Ratio as a line on the same timeline — each keeps its own natural scale, but both appear together so trends and relationships between the two metrics are easy to spot.

Invest now in Acorns!!! 🚀
Join Acorns and get your $5 bonus!

Acorns is a micro-investing app that automatically invests your "spare change" from daily purchases into diversified, expert-built portfolios of ETFs. It is designed for beginners, allowing you to start investing with as little as $5. The service automates saving and investing. Disclosure: I may receive a referral bonus.

Invest now!!! Get Free equity stock (US, UK only)!

Use Robinhood app to invest in stocks. It is safe and secure. Use the Referral link to claim your free stock when you sign up!.

The Robinhood app makes it easy to trade stocks, crypto and more.

Webull! Receive free stock by signing up using the link: Webull signup.