How to Make a Gauge Chart in Google Sheets

A gauge chart is the speedometer of the spreadsheet world — a single value shown as a needle on a dial, instantly telling you whether you’re above target, near it, or falling short. Sales at 78% of quota. Project at 45% complete. Server at 92% capacity. One number, one glance, one verdict.

Google Sheets builds these natively, and you’ll have one working in under a minute. I’ll show you exactly how, then give you an honest take on when a gauge is the right call and when it’s quietly wasting half your dashboard — because that part matters, and most tutorials skip it.

Set up the data (it’s genuinely just two cells)

A gauge chart displays one value. That’s the whole design. So the data setup is the simplest of any chart in Sheets:

• One cell for the label — say, Sales to Target in A1.
• One cell for the value — the current number, like 78 in B1.

That’s it. Don’t select a column of numbers or multiple rows — a gauge can only show one value per gauge, and feeding it a range either errors out or produces something you didn’t want. (Technically, each row you select becomes its own separate gauge, which is occasionally useful but usually just confusing.)

Build the chart

1. Select your two cells — A1 and B1 in the example.
2. Go to Insert > Chart.
3. Sheets inserts a default chart, usually a pie chart, and opens the Chart editor on the right.
4. Under the Setup tab, open the Chart type dropdown, scroll to the Other section at the bottom, and choose Gauge chart.

Your two cells become a dial with a needle pointing at 78 on a 0–100 scale. Functional, but not yet useful — the ranges and colors are doing nothing for you until you set them.

Set the range and color bands (this is the actual work)

A gauge with default settings is just a number in a circle. The value comes from the color bands — the red/amber/green zones that turn a raw figure into an instant judgment. Everything here lives under Customize > Gauge.

First, set the min and max. A gauge scaled 0–100 is fine for percentages, but if you’re tracking sales against a target of 750 units, set your maximum to 750 (or a bit above, so a record month doesn’t peg the needle). Under Gauge Range, enter your minimum and maximum. Get this right and the needle position actually means something.

Then set the color ranges. This is the part that earns the chart. You typically define three bands:

• Red for below-target — say 0 to 300.
• Amber for near-target — 300 to 550.
• Green for on or above target — 550 to 750.

Each band takes a min value, a max value, and a color. Once they’re set, the needle doesn’t just show a number — it shows a status. Green needle: good. Red needle: someone needs to look at this today. That instant read is the entire reason to use a gauge, so don’t skip the color setup.

Give it a clear title under Customize > Chart & axis titles and you’ve got a clean, glanceable KPI indicator.

Now the honest part: gauges are usually the wrong choice

Here’s the position, and I’ll defend it: most gauge charts should be bullet charts instead.

A gauge takes up a large, round chunk of space to communicate exactly one number and its status. On a dashboard where real estate is precious, that’s a bad trade. Worse, a single gauge tells you the current value but almost nothing else — no history, no sense of whether you’re trending up or down, no comparison to last period. It’s a snapshot with no context.

A bullet chart shows the same thing — value against target, with performance bands — in a fraction of the width, as a compact horizontal bar. You can stack ten of them in the space one gauge occupies, which means a reader can scan an entire KPI panel in one pass instead of hunting across a field of dials. That’s why professional dashboards are full of bullet charts and nearly empty of gauges.

Google Sheets doesn’t have a native bullet chart, which is genuinely annoying, so people default to the gauge that is built in. If you’re building anything with more than two or three KPIs, it’s worth the extra effort to build bullet charts (or move that panel into Excel, which handles KPI layouts more gracefully — see our KPI dashboard template for Excel, a 12-chart layout built the way dashboards should be).

So when is a gauge the right call?

Fair question — I’m not going to tell you never to use the thing you came here to build. A gauge genuinely works when:

• You have exactly one hero metric that deserves to dominate a view — a single “are we on track?” number on a status page or a printed one-pager.
• The audience is non-technical and the speedometer metaphor does real work. Executives and clients read a red-or-green dial instantly, no explanation needed.
• Space isn’t tight — a slide, a header block, a standalone report cover.

In those spots, a gauge’s oversized, obvious presence is a feature, not a flaw. Use it deliberately for one big number, not reflexively for every metric on the page. And if you’re weighing gauge versus something else for a given metric, the chart decision guide walks through the tradeoffs by data type.

Faster options

Want a head start? Our free Google Sheets chart templates include pre-built KPI indicators you can copy to your Drive and repoint at your own numbers.

FAQ

Does Google Sheets have a gauge chart? Yes. Go to Insert > Chart, open the Chart type dropdown in the Chart editor’s Setup tab, scroll to the Other section, and select Gauge chart.

How do I add color ranges to a gauge chart in Google Sheets? Open the Chart editor, go to Customize > Gauge, and under the color-range settings enter a min, max, and color for each band — typically red for below target, amber for near target, and green for on or above target.

Why does my gauge chart show the wrong scale? The default range is 0–100. If your metric uses a different scale (like sales out of 750), set the minimum and maximum under Customize > Gauge > Gauge Range to match your data.

Can I show multiple values on one gauge chart? No — a single gauge displays one value. If you select multiple rows, Sheets creates a separate gauge for each row, which usually isn’t what you want. For comparing several KPIs, a bullet chart or a compact multi-metric layout works far better.

Is a gauge chart or a bullet chart better for a KPI dashboard? A bullet chart, in almost every case. It shows value-against-target in far less space, letting you stack many KPIs in one scannable view. Reserve gauges for a single hero metric where the speedometer look does real work and space isn’t tight.