Excel Combo Chart: Bars + Line on a Secondary Axis

A combo chart plots one series as columns and another as a line, often with the line reading against a secondary axis so two measures with different units — like revenue in dollars and order count — can share one chart without one series flattening into a barely-visible flat line.

How do I create a combo chart in Excel?

Select the data range including headers, then use Excel's dedicated combo chart type rather than building it by hand from two separate charts. Excel exposes a per-series chart type and per-series axis assignment in one dialog.

1. Select your data (e.g. Month, Revenue, Orders)
2. Insert > Charts > Insert Combo Chart > Create Custom Combo Chart
3. For "Revenue": Chart Type = Clustered Column, Secondary Axis = unchecked
4. For "Orders": Chart Type = Line, Secondary Axis = checked
5. Click OK

Excel also auto-suggests a combo layout under Recommended Charts when your selected series have very different value ranges, which is a useful hint that a secondary axis might be warranted.

When should the line series get a secondary axis?

Give the line its own axis only when the two series are measured in different units or have value ranges so different that one would be crushed flat on a shared scale — dollars vs. unit counts, temperature vs. rainfall, revenue vs. conversion rate. If both series are dollars, or both are percentages, keep them on one axis; a second axis there exists only to separate lines that should be directly comparable.

Good candidate for secondary axis:
  Revenue ($10,000-$500,000)   +   Orders (50-400)
  → same-axis plot would flatten Orders to a near-flat line

Bad candidate for secondary axis:
  This year's revenue ($)   +   Last year's revenue ($)
  → same unit, same scale — plot both on one axis instead

When does a secondary axis make a combo chart misleading?

A secondary axis misleads whenever its scale is chosen (deliberately or by Excel's autoscale defaults) so the two lines visually converge or diverge in a way that implies a relationship the data doesn't support. Because each axis has an independent minimum and maximum, you can always find a pair of ranges that makes two unrelated series appear to move together.

• Different zero points: if the primary axis starts at zero and the secondary axis doesn't, the columns and line are being judged by inconsistent baselines — very easy to misread.
• Unlabeled axes: without an axis title on each axis (and matching series color), readers can't tell which scale the line belongs to.
• Manually stretched ranges: right-click an axis > Format Axis lets you set arbitrary min/max — tightening the secondary axis range around the line's values can make ordinary noise look like a dramatic swing.
• Same-unit series on two axes: the moment both series share a unit, a second axis stops serving a real purpose and starts hiding the true gap between them.

For the deeper mechanics of how mismatched axis scales fake correlation, see dual axis charts: when two y-axes mislead.

What's the alternative to a secondary axis?

Index both series to a common baseline (100 at the first period) and plot them on one shared axis, which shows relative change honestly without needing two scales. This works well when you care about growth rate rather than absolute values.

Revenue index = Revenue / Revenue(period 1) * 100
Orders index  = Orders  / Orders(period 1)  * 100
→ plot both indexed series on a single axis

Common mistakes with combo charts

Most combo chart problems come down to axis clarity — readers need to instantly tell which series belongs to which scale, or the second axis does more harm than good.

• Forgetting to label both axes: a chart with two unlabeled axes is unreadable without hovering over every point.
• Using a line for a series that should be columns: if the series isn't a trend over a continuous timeline (e.g. it's a category comparison), a second bar set or a table is clearer than a line.
• Mismatched colors between series and legend: keep the line's color consistent with its axis label so the eye can match them instantly.
• Adding a secondary axis reflexively: check whether both series are actually the same unit before reaching for a second axis at all.