Sometimes two series belong in the same picture but live in different units, like revenue in ₹ and gross margin in %, or units sold and average price in $. Plot them on one axis and the problem is obvious. Revenue of 8,200,000 and a margin of 42.5 can't share a vertical scale. The margin line flatlines along the floor, invisible, because 42.5 is a rounding error next to 8.2 million. The combo (combination) chart solves this by giving the second series its own axis on the right, the secondary axis, scaled to its own range. The first series keeps the left, or primary, axis. Now the reader sees both stories in one frame, with the revenue bars rising and falling and the margin line tracking above them.
The standard analyst combo is revenue as columns on the primary axis, margin % as a line on the secondary axis. The columns say "how big" and the line says "how profitable". Together they say "we grew and held margin". Or they say the uncomfortable thing, "we grew by discounting", with the margin sagging as the bars rise. The combo tells that story instantly, and a table hides it.
Advertisement
How do you build and format a combo chart?
To build it, select both series along with their category labels, for example Month, Revenue, Margin%. Then use either route:
- Insert ▸ Charts ▸ Combo (the icon with a column and a line) ▸ Create Custom Combo Chart. In the dialog, set each series' chart type, Revenue to Clustered Column and Margin% to Line, then tick Secondary Axis for the Margin% series. It's the cleanest path.
- Or insert an ordinary column chart of both and select the series you want to move. Press
Ctrl+1, and under Series Options choose Plot Series On ▸ Secondary Axis. Then right-click that series ▸ Change Series Chart Type ▸ Line.
Now format the secondary axis. Click it and press Ctrl+1, and set its number format to a percentage. Then add the professional touch by setting its Minimum and Maximum bounds deliberately. Don't accept Excel's auto-scale, for reasons the next paragraph explains. Give each axis a visual cue that ties it to its series as well. Colour the margin line and the right-axis labels in one accent. Use another for the bars and the left axis. A reader must never have to guess which axis reads which series.
How do you keep a secondary axis honest?
Here's a first look at the honesty rule, and it gets hammered home again in the common mistakes section. A secondary axis is a second, independent scale that you chose. Because you chose it, you can make two unrelated series appear to move together or apart just by sliding the axis bounds. That freedom carries a responsibility. Pick the secondary-axis range once, on defensible grounds (e.g., "margin axis 0 to 50% because margins in this business live there"). Keep it stable across a series of exhibits so periods stay comparable. And never nudge it to manufacture a visual correlation.
The same combo chart can be a powerful, truthful tool and an easy, dishonest one. The only difference is whether you set the axis to serve the data or to serve the conclusion.