Speedometer Chart in Excel: Build a Reusable Template

Charts & pivot tables · Updated November 20, 2026

A speedometer chart is not a built-in Excel chart type, but you can create a reusable gauge from a doughnut chart and a small input table. The quickest template shows a value as a colored arc against a remaining, muted arc; a separate half-doughnut with a pointer is possible, but takes more chart formatting.

What an Excel speedometer chart shows

A speedometer, or gauge, chart turns a number into a visual position or progress arc. A typical example might show monthly sales at 72 against a target of 100, or a project score on a scale from 0 to 10. The rounded, half-circle design resembles a vehicle dial, so it can make a single key measure easy to scan on a dashboard.

Excel does not offer a dedicated speedometer chart command or an official speedometer template in its standard chart gallery. The familiar appearance is assembled from supported chart types—usually a doughnut chart, sometimes combined with a pie chart for a pointer—and formatted to hide part of the circle. You can make the workbook below once, then reuse it by changing its input cells.

This distinction matters: a gauge is a visual choice, not a new kind of calculation. The underlying number still needs a clear scale, trustworthy source data, and a sensible target. A dramatic dial cannot compensate for a measure that is poorly defined.

A simple reusable template: the half-doughnut

The easiest version uses a colored arc for the current value, a gray arc for what remains, and a hidden segment to create the half-circle. It behaves like a progress gauge rather than a traditional needle dial, but is easier to maintain and works well for targets such as 72 out of 100.

  1. Enter labels in A2:A6 and values or formulas in B2:B6: A2 “Actual” with B2 as the input (for example, 72); A3 “Maximum” with B3 as the scale limit (for example, 100); A4 “Clamped value”; A5 “Remaining”; and A6 “Hidden half.”
  2. With the entered actual value in B2 and maximum in B3, put this in B4 to keep the displayed amount between zero and the maximum: =MAX(0,MIN(B3,B2)). For inputs of 72 and 100, B4 returns 72. This prevents a negative value or an over-target value from breaking the arc.
  3. With the maximum in B3 and clamped value in B4, put this in B5: =B3-B4. For the example, it returns 28. With the maximum still in B3, put this in B6: =B3. It returns 100, which supplies the hidden half of the chart.
  4. Select A4:B6, then choose Insert > Insert Pie or Doughnut Chart > Doughnut. The three values—72, 28, and 100—make the first two slices add up to one half of the total and the last slice form the other half.

Excel may initially show the hidden slice at the top or on a side. Select a doughnut slice, open Format Data Series, and adjust Angle of first slice until the 100-unit slice sits across the bottom. The exact angle depends on the order of your source values and how the chart is oriented, so judge it by the result rather than relying on a number copied from a different workbook.

Then select the hidden slice and choose No Fill, and remove its border if one appears. Format the actual slice with a strong color and the remaining slice in a pale neutral shade. On the Format Data Series pane, increase Doughnut Hole Size to suit the layout; a larger hole leaves room for the number in the middle. Remove the legend if it adds no useful information. A chart title such as “Sales target” can explain what the scale represents.

Put the value and scale in context

A dial is much more useful when readers can tell what they are looking at. Add a center label such as “72” and a nearby explanation such as “of 100 units” or “72% of monthly target.” If the actual measure has units—$72, 72 calls, or 72 hours—show them. A bare number can be mistaken for a percentage, a score, or a count.

For a percentage display, with the clamped value in B4 and the maximum in B3, this optional formula returns the share of the scale: =IF(B3=0,0,B4/B3). With 72 and 100 it returns 0.72; apply Percentage from Home > Number to show 72%. The IF check avoids a division-by-zero error if someone enters a zero maximum. Set B3 to a positive number for a meaningful gauge.

You can put the central number in a text box over the hole. In Excel for Microsoft 365 on Windows, insert a text box, select its border, click the formula bar, type =B4, and press Enter to link it to the value cell. If you prefer not to link a shape, place a large formatted cell next to or over the chart instead. Keep the scale and unit visible somewhere close, especially when the chart is copied into a presentation or dashboard.

Make it reusable and robust

Once the chart looks right, keep the input cells distinct from the calculations. For example, use a pale fill for B2 and B3, and a different fill for formula cells B4:B6. Add short cell labels and, if other people will edit the workbook, a note explaining that B2 is the actual value and B3 is the upper limit. You can also use Data > Data Validation to restrict entries, though the exact rule depends on whether your measure can be decimal or negative.

The clamp formula makes the displayed arc stay within its scale, but it does not tell a reader that the underlying input is out of range. If B2 is 115 and B3 is 100, the chart will show a full arc while the source value remains 115. That may be acceptable, but it can conceal a meaningful over-target result. Add a separate cell or label to disclose the original value, or use conditional formatting or a warning message when values above the maximum need attention.

For example, if exceeding a target is good, a gauge capped at 100% can make 115% look identical to 100%. Consider changing the scale, showing the actual value prominently, or using a chart that can display values beyond the target. If falling below a threshold is the concern, explain that threshold directly; do not assume readers will infer it from a color band.

Adding colored performance zones or a needle

A traditional dial often has fixed colored zones—for example, red for 0–50, amber for 50–80, and green for 80–100—with a pointer marking the current value. Those zones describe ranges on the scale, while the pointer describes the current reading. They are separate pieces of information, so do not treat a multicolor progress arc as if it automatically included a correctly positioned needle.

For a zone-style gauge, use a doughnut chart whose visible half is divided into fixed range sizes and whose other half is hidden. With a 0–100 scale, the visible ranges might be 50, 30, and 20, followed by a hidden segment of 100. Format the three visible slices red, amber, and green, hide the last slice, and orient the chart so the hidden portion is at the bottom. This creates a static scale. Changing the actual reading will not move a pointer unless you add a separate pointer series or chart.

A pointer is commonly made from a pie chart with a very narrow slice positioned at the reading, overlaid on the doughnut. This is more fragile than the simple template: the pie’s slices, rotation, chart area, and plot area must align with the doughnut, and a change in chart sizing can make the pointer appear off-center. Build the scale first, then add the pointer as a separate chart object and test it at the minimum, midpoint, and maximum. If the result will be edited by many people, a labeled progress arc is often the more dependable choice.

Common problems and practical fixes

  • The chart appears as a full ring. The hidden slice may still have a fill, or the source values may not include a hidden segment equal to the maximum. Check that the hidden slice is set to No Fill and that its value equals the scale limit.
  • The arc fills in the wrong direction. Change the slice order or adjust Angle of first slice in Format Data Series. Rotation changes placement; it does not change the underlying value.
  • The chart shows a blank or error. Check that the input cells contain numbers, the maximum is positive, and the chart source includes the formula cells. A text entry such as “72%” may be interpreted differently from a numeric value depending on how it was entered.
  • The gauge looks full even though the input is too high. The clamped value intentionally stops at the maximum. Show the unmodified input as a label or provide a separate warning when over-target values matter.
  • The gauge is hard to compare. Give related gauges the same scale and keep their colors consistent. A 72 on a 0–100 scale is not directly comparable to a 72 on a 0–200 scale.

Also consider accessibility and printing. Color should not be the only way to identify a status; include labels or values, and choose colors with enough contrast. A half-doughnut may be attractive on screen but can take up more space than a simple cell with a percentage and data bar. Check the printed page or exported PDF, where small labels and subtle colors may be difficult to read.

Speedometer charts compared with Excel alternatives

Use a gauge when a single measure against a fixed, clearly labeled range deserves visual emphasis. For several categories, a bar chart is usually easier to compare because bars share a common baseline. A clustered bar chart can compare actual and target values side by side, while a line chart is more informative when the important story is how a measure changes over time.

Excel’s data bars, available through Home > Conditional Formatting > Data Bars, are a simpler in-cell alternative for a list of progress values. They are compact, update with the cells, and make it easier to compare multiple rows than a page of separate dials. A cell showing “72%” alongside a data bar may be clearer than a decorative gauge in a dense report.

Before choosing a speedometer, ask whether the dial adds information beyond the number and target. Gauges use space and make precise comparisons between several values harder. They work best for a small number of headline measures, not as a default replacement for every chart in a workbook.

Frequently Asked Questions

Does Excel have a built-in speedometer chart?
No. Excel does not include a chart type named Speedometer or Gauge in the standard chart gallery. You create the visual from supported chart types, commonly a doughnut chart, and format it to resemble a dial.

Can I download a speedometer chart template from Excel?
There is no standard speedometer template built into Excel. You can create the reusable workbook described above and save it as an Excel Template (.xltx) using File > Save As, then select the template file type. This creates a starting file; it does not add a new chart type to Excel.

How do I change the value shown on the gauge?
Change the actual input cell, B2 in the example. The clamped value, remaining slice, and chart update automatically because they are linked to that cell. If you add a separate text box for the reading, link it to the value cell as well.

Can a speedometer chart show more than 100%?
Yes, if you choose a scale that extends above 100%, or show the actual number separately. The example caps the arc at its maximum so it cannot extend beyond the chart’s scale. That cap can hide an over-target amount, so decide whether to display the uncapped input too.

Will the chart work in Excel for Mac or Excel for the web?
The underlying doughnut chart and formulas are standard Excel features, although ribbon placement and chart-formatting controls can differ between Windows, Mac, and Excel for the web. If a control is not in the same place, look for the chart’s series-formatting options and the setting for the first slice angle. Verify the finished layout in the version where the workbook will be used.

Save a working copy as a template

When the gauge is finished, save the editable workbook as an .xlsx file for ordinary use, or use File > Save As and choose Excel Template (.xltx) to create a reusable starting point. Keep a clear example value in the template or include instructions next to the input cells, then test a low value, a typical value, the maximum, and an over-maximum value. That final check confirms not only that the chart updates, but also that its labels explain what the reader is seeing.

Related

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.