Dual Axis Charts: How to Compare Two Metrics on Different Scales

A dual axis chart places two different Y-axes on the same visualization — one on the left and one on the right — so you can overlay two metrics that operate on completely different scales. Revenue in millions paired with customer count in thousands. Temperature in Celsius alongside rainfall in millimeters. This chart type is both incredibly useful and surprisingly controversial.

In this guide, you will learn what makes dual axis charts powerful, why some data visualization experts advise against them, and how to create one responsibly using ChartLoad's free dual axis chart maker.

What Is a Dual Axis Chart?

A dual axis chart (also called a dual-Y or secondary-axis chart) combines two datasets on a shared X-axis but with independent Y-axis scales. Typically, one dataset is rendered as bars and the other as a line, although two lines or two bar series are also possible.

The most common use cases include:

• Revenue + units sold: Revenue on the left axis (dollars), units on the right axis (count).
• Temperature + rainfall: Temperature on the left (degrees), rainfall on the right (millimeters).
• Website traffic + conversion rate: Sessions on the left, conversion percentage on the right.
• Stock price + trading volume: Price on the left, volume on the right.

Dual Axis Chart vs. Alternatives

The dual axis chart is not the only way to compare two metrics. Here is how it stacks up against common alternatives.

The Controversy Around Dual Axis Charts

Dual axis charts are one of the most debated chart types in the data visualization community. The core criticism is this: because the two Y-axes have independent scales, the chart creator can manipulate the scales to suggest a correlation that does not exist or to exaggerate a relationship.

For instance, by adjusting the left axis range from 0-100 to 50-100 while keeping the right axis at 0-1000, you can make a flat trend appear to match a rising one. Readers instinctively assume that when two lines cross or move together, they are correlated — but on a dual axis chart, that visual alignment is an artifact of the chosen scales.

Edward Tufte's principle: "Above all else, show the data." A dual axis chart that manipulates scales to create a visual narrative violates this principle. If you use a dual axis chart, start both axes at zero whenever possible, and clearly label both scales.

When the Criticism Is Valid

• When the two metrics have no causal or contextual relationship.
• When the axis ranges are cherry-picked to manufacture visual alignment.
• When the audience is not data-literate enough to notice two separate scales.

When Dual Axes Are Justified

• When the two metrics are genuinely related (e.g., ad spend and conversions) and stakeholders need to see them together.
• When dashboard space is limited and splitting into two charts is impractical.
• When the audience understands how to read dual axes (e.g., analysts, engineers, scientists).

Example: Temperature and Rainfall Over 12 Months

Climate data is a textbook use case for dual axis charts. Temperature ranges from -10 to 35 degrees Celsius, while rainfall ranges from 0 to 200 mm. Plotting both on a single Y-axis would flatten one of the two series. A dual axis chart with temperature as a line and rainfall as bars lets meteorologists and readers see the seasonal interplay instantly.

Example: Revenue and Units Sold Over Quarters

A product manager wants to understand whether rising revenue is driven by higher prices or higher volume. Overlaying revenue (left axis, dollars) and units sold (right axis, count) on a dual axis chart reveals the answer. If revenue climbs while units stay flat, the driver is pricing. If both rise in parallel, volume is the engine.

Best Practices for Honest Dual Axis Charts

1. Start both axes at zero. This prevents scale manipulation from distorting the visual relationship.
2. Color-code clearly. Match the axis label color to the corresponding data series so readers know which axis belongs to which line.
3. Use different chart types for each series. A bar on one axis and a line on the other reduces confusion. A combo chart approach works well here.
4. Add a legend. Never rely on the reader to figure out which series maps to which axis.
5. Annotate key intersections. If the two series cross or diverge at a meaningful point, call it out with a label.
6. Consider your audience. For executive dashboards, dual axes can cause confusion. For analyst reports, they save space and add context.

How to Create a Dual Axis Chart with ChartLoad

1. Go to the dual axis chart maker.
2. Enter your two data series — one for the left axis and one for the right.
3. Choose the chart type for each series: bar, line, or area.
4. Customize colors to match each axis label.
5. Export as PNG or SVG, or grab an embed code for your website.

If the dual axis approach feels risky for your audience, consider alternatives. An indexed line chart normalizes both series to a common starting point. A scatter plot tests the actual correlation between the two metrics. Both are available free on ChartLoad, along with 100+ other chart types.

Explore our data visualization examples for more inspiration, or read our 2026 chart maker comparison to see how ChartLoad stacks up against the competition.

---

Worked Example: Ad Spend vs. ROAS

A growth marketer notices monthly ad spend keeps climbing, but the team is unsure whether each new dollar still pays off. She overlays ad spend (left axis, dollars) against return on ad spend, or ROAS (right axis, a ratio around 2-5x), across six months on a single dual axis chart.

Sample data: Month, Ad Spend ($), ROAS (x) Jan, 12000, 4.8 Feb, 18000, 4.6 Mar, 25000, 4.1 Apr, 34000, 3.4 May, 45000, 2.7 Jun, 58000, 2.1

Spend (bars) rises steeply while the ROAS line slides downward, exposing classic diminishing returns: each extra dollar of budget is buying less revenue. The crossover region around April-May flags the point where scaling spend started destroying efficiency, a signal that would be invisible if both series were forced onto one axis.

Frequently Asked Questions

Can a dual axis chart have two different scales on the same side?

No. A dual axis chart places exactly one scale on the left and one on the right. If you need a third metric on a different scale, that is a sign to split into separate charts or switch to an indexed line chart where every series shares one normalized scale.

Should the bars or the line use the secondary (right) axis?

Convention is to put the line on the secondary axis and bars on the primary, because the eye reads bars as anchored to a baseline and lines as floating trends. Whichever you choose, color-match each series to its axis labels so readers never have to guess which scale to read.

How do I make a dual axis chart in Excel or Google Sheets?

In both, you add the second series, then right-click it and choose 'Format Data Series' (Excel) or 'Series' settings (Sheets) and assign it to the secondary axis. It is fiddly and resets when you change chart types, which is why a dedicated dual axis chart maker that handles the second axis automatically is usually faster.