A Gauge Spends Half a Circle on One Number: Better KPI Charts for Dashboards and Board Decks

Carousel cover: A gauge spends half a circle on one number

Speedometer gauges show up in a lot of KPI slides and board dashboards. They look like data, but a gauge spends half a circle on one number and still does not say whether that number is good. Here is what to use instead.

Why gauges struggle

Put three gauges side by side (renewal rate 84%, new customers 52, gross margin 74%) and ask which one is furthest behind. You can’t tell, for three reasons:

  1. No target. Behind compared to what? The goal isn’t on the chart. Red, yellow and green zones are not a target.
  2. Angles, not lengths. People compare lengths more accurately than angles.
  3. Lots of space, little data. Each dial takes a big block of the slide for one value.

Start with the question: are we on track?

A KPI slide answers one question. To answer it, every number needs three things next to it:

  • The actual: where we are, for example 52 new customers.
  • The target: where we planned to be, for example 60.
  • The verdict: what it means, here 8 short, 13% behind plan.

A bare gauge shows only the first. The four fixes below show all three.

Fix 1: one KPI on the slide? Big number, target beside it

When one number is the whole point, you don’t need a chart at all. Show “52”, then “of 60 planned” and “▼ 13% behind” right next to it, and let the headline say it: “New customers are 13% behind plan.” Show the gap as a word or a sign, not only a color. On target? Say so: “On plan” in gray is enough.

Fix 2: a few KPIs? A bar from zero, a line for the target

Length is easy to compare, and the target line answers “compared to what?” New customers 52 against 60, renewal rate 84% against 90%, gross margin 74% against 72%: one glance shows which bars stop short of their line. Each bar can keep its own scale, but every bar must start at zero.

Fix 3: a dashboard? The bullet chart

The bullet chart was designed by Stephen Few as a compact replacement for dashboard gauges. It shows everything a gauge shows, in one thin line:

  1. The actual is the bright bar. Read it first.
  2. The target is a short line across it. Past the line, you’re ahead.
  3. Gray bands mark behind, close and on track. Use shades of one gray, not traffic lights.

Fix 4: many KPIs? Line them up on one scale

Show each KPI as a percentage of its own target, sorted, so “which is furthest behind?” takes a second: gross margin 103%, renewal rate 93%, new customers 87%, NPS 82%. Highlight the ones more than 10% behind. Keep the real numbers nearby, such as “NPS 41 vs 50 target” in a label or a table. The % of target is for comparing; the real number is for trusting.

Before and after

The same four numbers, first as four gauges under the title “Q3 KPIs”, then as sorted bullet rows under a headline that gives the answer: “New customers and NPS are furthest behind target.”

Before you add a gauge, ask

  1. Is the target on the chart, not only in your head?
  2. Can someone tell which KPI is furthest behind in a few seconds?
  3. Is “behind” shown with a word or sign, not only red?
  4. Do bars start at zero, or share one % of target scale?
  5. Does the headline say what the numbers mean?

Build it: in PowerPoint or Google Sheets, a bar chart plus a thin line for the target does most of the job. Put the bands behind it as light gray bars. (For another common chart fix, see our post on dual-axis charts.)

All KPI values and targets above are illustrative.

Board update or KPI review coming up? Send your deck over for a free review. We will tell you which charts read fast, which slides need a headline that says the point, and what to fix first. Request a free deck review.