ExcelWalaa
Academy • सीखो और जीतो
LoginGet Started
Light mode
LoginGet Started
fx Charts That Don't Lie
ENहिन्दी

Combo charts and the right use of a secondary axis

⏱ 13 min

What you'll learn

  • What a combo chart is
  • Good use 1: different units
  • Good use 2: actual vs target (same units — no secondary axis!)

Concept

1. What a combo chart is

Two (or more) series drawn with different chart types in one chart, e.g. revenue as columns and YoY % as a line. Insert → Combo → choose type and axis per series (Change Chart Type → Combo for an existing chart).

2. Good use 1: different units

Monthly revenue (₹) and YoY growth (%) can't share one scale — ₹36,00,000 and 17.9% would make the % line flat at zero. Put the % series on the secondary axis (right side).

Make it readable:

  • Different types: columns for amounts, line with markers for %.
  • Colour the right-hand axis labels the same colour as the line, or title each axis ("Revenue ₹ lakh" / "YoY %").
  • Start the % axis at 0 (or include 0) so negative growth is obvious.

3. Good use 2: actual vs target (same units — no secondary axis!)

Actual as columns, Target as a line or as a thin marker — both on the primary axis, because both are rupees. Common trick: target as a line with no line and a dash marker, so each month shows a "target tick" over its column.

4. When a secondary axis misleads

Two series with the same units on two different scales can make any story you want: move the right axis from 0–100 to 50–70 and a flat line becomes a steep rise. Readers rarely check which axis a series belongs to.

Rules:

  1. Same units → same axis. Always.
  2. Different units → secondary axis is fine, but label both clearly.
  3. If the chart needs a long explanation, use two small charts stacked vertically with the same x-axis instead.

5. Other useful combos

  • Pareto chart: sorted columns (revenue by product) + cumulative % line on secondary axis (0–100%). Shows "top 4 products = 75% of revenue" style insights. (Excel also has a built-in Pareto under Histogram charts, Windows.)
  • Bar + average line: add an "Average" series with the same value in every row, chart it as a line.

6. Build steps (revenue + YoY %)

  1. Table: Month | Revenue (₹ lakh) | YoY %.
  2. Select it → Insert → Combo → Revenue: Clustered Column; YoY %: Line with Markers, ✓ Secondary Axis.
  3. Format the secondary axis: number format 0%, minimum −0.1 if any month is negative.
  4. Title: "Revenue peaked in Oct–Nov; growth fastest in October (+17.9%)".

Common mistakes

Secondary axis for two rupee series. Unlabelled right axis. Same chart type for both series (two lines on two scales = confusion). Too many series in one combo.

Practice file

⬇ Download analysis-visualization-practice.zip

Exercises

mediumFrom your capstone model, build Revenue + YoY % by month (FY2025-26) as a combo, and a separate Actual vs Target chart for one region using only the primary axis. Then deliberately change the secondary axis bounds and notice how the story changes.
Plot monthly revenue as columns (rupees) and YoY as a line (percent), with both axes labelled. Use a single rupee axis for Actual vs Target. For target comparisons use Region and whole Month filters only, not Category/Store. Changing percent-axis bounds changes visual emphasis, not correlation or the underlying values.

Quiz

When is a secondary axis appropriate?
When the series have different units
Actual vs Target — secondary axis?
No — same units, same axis
Alternative when a dual-axis chart is confusing?
Two small charts with the same x-axis
Combo charts and the right use of a secondary axis · Analysis & Visualization | ExcelWalaa