How to Compare Actual and Target with a Combo Chart

Prepare the source for the combo chart with actual columns and a target line

Use one row per period with Actual and Target in separate columns and the same unit.

Build the visual

1. Prepare period, Actual, and Target columns.
2. Insert a Combo chart.
3. Set Actual to Clustered Column.
4. Set Target to Line.
5. Keep both on the primary axis when the units and scale are comparable.
6. Add a secondary axis only when clearly justified.
7. Format the target line distinctly and label the period and unit.

Design rules

• Use a restrained column color and a high-contrast target line.
• Start a quantity axis at zero when appropriate.
• Use direct labels sparingly.
• Keep the target line visible across every period.
• Explain whether higher or lower is better.

Common chart mistakes

Mistake	Why it matters
Using a secondary axis for the same unit without need	Visual differences can be exaggerated.
Mixing target and actual periods	The comparison is invalid.
Using a line with only one target point	The target is not clearly represented.
Adding too many series	The key comparison disappears.
Truncating the axis aggressively	Small gaps look dramatic.

Check the comparison with a variance table

Before formatting the chart, calculate the numeric variance beside the source. If Actual is 82 and Target is 90, the variance is -8 and the chart should visually show the column below the target line. Repeat that check for an above-target period and an exact-target period. This catches swapped series, wrong periods, and hidden scaling issues before presentation formatting hides them.

When Actual and Target use the same unit, keep them on the same axis in most cases. A secondary axis can make an 82-versus-90 gap look much larger or smaller depending on the chosen scale. If target values vary by month, store each monthly target explicitly rather than drawing a constant line by hand. For percentages, use a percentage axis; for currency or counts, label the units in the title or axis so readers do not need to infer them.

Use a three-period sanity check

Before publishing the combo chart, test one period below target, one exactly on target, and one above target. If Actual values are 80, 90, and 105 against a Target of 90, the columns should sit below, on, and above the target line respectively. This simple test catches swapped series, incorrect target rows, and misleading axis choices. When lower is better, keep the chart values unchanged and explain the favorable direction in the labels or surrounding report.

Frequently asked questions

Should the target use a secondary axis?

Normally no when both series use the same unit.

Can the target change by month?

Yes. Store the monthly target values in the source.

How do I show favorable status?

Add labels, variance calculations, or restrained conditional indicators outside the chart.

What if lower is better?

State the direction clearly and interpret the comparison accordingly.