Two Y-Axes. Two Scales. One Confused Reader: How to Fix a Dual-Axis Chart

Cover: Two y-axes. Two scales. One confused reader.

Put two measures on one chart and the lines start to “say” things. Where they rise and where they cross depends on where you set each scale, not on your data.

Before and after: a dual-axis revenue and margin chart split into two charts that share one x-axis

Before: one chart, two scales

The illustrative “Revenue & Gross Margin” chart puts revenue bars on a left axis and a margin line on a right axis. Four things go wrong:

  • Which axis is which? Readers jump between the legend and both sides of the chart.
  • The right axis starts at 50%, so a 12-point rise looks like a steep climb.
  • The line crosses the bars. That means nothing. It is just where two scales happen to meet.
  • The title names the data, not the point.

After: two charts, one story

The rebuilt version is titled “Revenue tripled in six quarters. Margin rose 12 points.” Five changes get it there:

  1. Split it into two charts: one measure, one scale each.
  2. Share one x-axis, so the quarters line up.
  3. Start bars at zero, so their heights stay honest.
  4. Label the values instead of making people decode a legend.
  5. Put both takeaways in the headline.

The rescale test

Change the range of the right axis. If the story changes, the chart was showing your axis settings, not your data.

The figures above are an illustrative example. For more on picking the right chart, see Most Bad Charts Are the Right Data in the Wrong Chart.

Got a deck full of charts? Send it over for a free deck review and we will tell you which ones to fix first.