Excel Speedometer Chart: Build One and Make It Work

Charts & pivot tables · Updated November 19, 2026

An Excel speedometer chart is a dashboard-style gauge that shows a value on a semicircular scale; Excel does not provide a dedicated Speedometer or Gauge chart type. In Microsoft 365 for Windows, the simplest version is a doughnut chart with one hidden half: enter the scale segments and a blank segment, insert a doughnut chart, then format the blank slice with no fill. You can add a value label or a pointer, but the pointer takes extra work.

What a speedometer chart shows

A speedometer, or gauge, translates a number into a position on a visual scale. A dashboard might use one to show that a project is 68% complete, a service team has met 92% of its target, or a machine is operating at a particular reading. The colored bands commonly represent ranges such as low, acceptable, and high. The displayed value is the indicator; the arc supplies context.

Despite its name, the chart does not measure anything by itself. It displays data that already exists in the workbook, and it does not automatically make a value meaningful. A gauge for 68% could be good or bad depending on whether the metric is completion, defects, spending, or something else. Include a clear title, units, and range labels so readers can interpret it correctly.

How the half-doughnut design works

A doughnut chart normally draws a full ring. To make a half-ring, give Excel data whose visible categories add up to one half of the total and reserve the other half for a blank category. For example, use three scale bands with values 30, 30, and 40, followed by a blank segment of 100. The visible bands total 100, and the blank segment is also 100, so it takes up half the circle. Formatting that slice as transparent leaves a semicircular arc.

The values are proportions of the chart, not the thresholds for a measured reading. In this example, 30, 30, and 40 allocate 30%, 30%, and 40% of the visible scale to the three bands. The final 100 creates the hidden half. You can change the band values to make the ranges unequal, but their total should still equal the blank segment if you want a half-circle.

A doughnut alone does not include a moving needle. It can show the scale and a prominent number in the center, which is often sufficient for a compact dashboard. A pointer can be added with a shape or a second chart, but a manually placed shape will not move when the underlying value changes.

Build the basic chart in Excel

For Microsoft Excel for Microsoft 365 on Windows, start with a small table. Put the band names in one column and their chart values in the next. The blank category is a real slice in the data even though it will be invisible in the finished chart.

  1. Enter four rows: Low = 30, On track = 30, Strong = 40, and Blank = 100. These are illustrative scale proportions, not universal performance thresholds.
  2. Select the names and values, including their headings. Choose Insert > Insert Pie or Doughnut Chart > Doughnut.
  3. Click the chart, then click a slice again to select just that data point. Select the Blank slice and open Format Data Point. Under Fill & Line, choose No fill and No line. If selecting the right slice is difficult, click the chart and use the Format tab’s Current Selection list to choose a data point.
  4. With the doughnut series selected, open Format Data Series and adjust Angle of first slice until the blank portion sits across the bottom. The exact angle depends on category order and Excel’s starting orientation; use the preview and rotate until the open side is where you want it.
  5. Format the three visible segments with distinct, readable colors. Reduce the doughnut hole size if you want a thicker band, or increase it to leave more room for a central number.
  6. Remove the legend if it duplicates labels, resize the chart, and add a descriptive chart title. Use Insert > Text Box for a central value or explanatory note.

Excel may show a legend entry for the blank category even after its slice is hidden. Remove the legend or select only that legend entry and delete it, taking care not to delete the data point itself. If your chart has no clear opening at the bottom, check both the blank slice formatting and the first-slice angle before rebuilding it.

Add a value and communicate the scale

Suppose the scale runs from 0 to 100 and the current result is 68. You could place 68% in the center of the doughnut and title the chart Service target attainment. That gives the reader the exact reading, while the colored bands provide a quick impression of where it falls. If you instead show only an arc, the user has to estimate the value from the position, which is imprecise.

A central number can be a text box linked to a worksheet cell. Select the text box, click the formula bar, type an equals sign and the cell reference, then press Enter; the text box displays the referenced cell’s contents. This is useful when the data updates, though the text box needs suitable number formatting and may need resizing when the displayed text changes. A title or nearby label should state the metric and unit, such as defects per 1,000 orders rather than just Results.

Make the ranges explicit. A scale labeled Low, On track, and Strong needs definitions somewhere nearby, such as 0–49, 50–79, and 80–100. Color alone is not a reliable label: some readers cannot distinguish particular color combinations, and the meaning of red or green can vary. Use text labels or a short key in addition to color, and check that the chart remains legible when printed in grayscale.

Adding a pointer: options and trade-offs

The most straightforward pointer is a line or narrow triangle placed over the chart with Insert > Shapes. Rotate and position it toward the value on the arc, and add a small circle at its base if that suits the design. This is quick for a one-time report, but it is a drawing object, not a data-driven indicator. When the value changes, someone must reposition the shape, and resizing or moving the chart can disturb its alignment.

A more automated needle can be made with an additional pie-chart series or an overlaid chart built from helper values. That approach requires careful calculations for the needle’s angle, width, and position, plus transparent chart backgrounds and precise alignment. Excel’s chart interface does not turn a cell value into a gauge needle automatically. If you need a responsive pointer, plan to maintain the construction and test it at the minimum, midpoint, and maximum readings; a needle that looks right for one value may be misaligned at another.

For many dashboards, a central number and colored band are a better compromise than a needle. They are easier to maintain, less likely to break when a chart is resized, and communicate the exact result without implying mechanical precision. If a user must compare several readings closely, a bar chart or bullet-style display is usually easier to interpret.

Design choices that improve readability

  • Choose a meaningful range. A 0–100% completion measure naturally fits a 0–100 scale. A temperature or response-time measure may need a different minimum and maximum, and the chart should disclose them.
  • Keep the bands purposeful. Three or four ranges are usually easier to scan than a ring divided into many narrow slices. More segments add visual complexity without necessarily adding useful information.
  • Use a clear hierarchy. Make the current result easy to find, then use the arc as supporting context. Avoid a large legend, decorative gradients, and unnecessary labels competing with the reading.
  • Explain whether higher is better. A high value is not always favorable. For error rates, costs, or delays, the scale may need to reverse the usual red-to-green convention.
  • Check the chart at its final size. A semicircle that looks clear on a large monitor may become unreadable in a small dashboard tile or printed report.

Common problems and practical limits

The chart is a full circle. The blank category may be missing, may not equal the sum of the visible bands, or may still have a fill color. Confirm that the chart contains all four values and that the Blank slice has no fill. The slice still occupies space even when it is transparent.

The opening is at the top or side. Change Angle of first slice in Format Data Series. If the bands appear in an unexpected order, reorder the source rows as well; the rotation setting changes orientation, not category sequence.

The colors or labels are hard to select. Click once to select the whole series and click a second time on the specific slice to select that data point. You can also use the Current Selection list on the Format tab. This is more precise than repeatedly clicking small chart segments.

The gauge suggests false precision. A needle pointing to a narrow spot on a broad arc can make an approximate metric look exact. Display the actual number and use sensible bands. A speedometer chart is a visual summary, not a substitute for a clearly defined measure or detailed analysis.

There is also a space cost: a half-circle uses substantial chart area while displaying one primary value. It is not ideal for showing trends over time, comparing many categories, or reading exact differences between values. Those are common tasks for which a conventional chart communicates more information with less interpretation.

Alternatives to a speedometer chart

Use a bar chart when readers need to compare values or see movement over time. A horizontal bar with a target line can show both the current result and goal in a familiar form. Conditional formatting data bars in a worksheet cell can give a compact visual cue without creating a separate chart. For a compact KPI, a large number with a status label and a small trend line may be clearer than a dial.

Excel also offers doughnut charts, pie charts, and other standard chart types, but a dedicated speedometer or gauge type is not part of the standard Insert Chart choices in Microsoft 365 for Windows. Online templates and add-ins may offer gauge visuals, but their availability, data handling, and maintenance differ. For a simple, portable workbook, the doughnut construction avoids relying on an add-in; for a recurring report with many measures, a bar-based dashboard is often easier to update and compare.

On Excel for Mac, the same general doughnut-chart method is available, though ribbon layout and pane labels can differ by release. Excel for the web supports many common chart tasks, but some detailed formatting controls may be limited compared with the Windows desktop app. If a precise first-slice angle or individual slice formatting is unavailable in the version being used, finish the chart in desktop Excel.

Frequently Asked Questions

Does Excel have a built-in speedometer chart?
No. Excel for Microsoft 365 does not include a dedicated Speedometer or Gauge chart type in its standard chart list. A common workaround is a doughnut chart with a hidden segment; adding a pointer is a separate formatting or chart-construction task.

Can an Excel speedometer update automatically?
The chart’s doughnut segments update when their source values change, but a text box or pointer needs separate treatment. A linked text box can display a changing cell value. A pointer made with a shape does not move automatically; a data-driven pointer requires helper data and a more involved chart setup.

How do I make a half-circle doughnut chart?
Make the visible scale values total the same amount as a final blank value, insert a doughnut chart, set the blank slice to No fill and No line, and adjust Angle of first slice so the opening is at the bottom. For example, visible values of 30, 30, and 40 pair with a blank value of 100.

Can I use a speedometer chart for percentages?
Yes, if the scale is clearly defined, for example from 0% to 100%. The chart’s segment values determine how much space each colored band occupies; they are not automatically linked to the percentage being measured. Show the actual percentage separately so readers do not have to estimate it from the arc.

What is better than a speedometer chart for comparing results?
A bar chart is generally clearer when comparing several results, targets, or time periods. A speedometer emphasizes one value and uses area for its circular scale, so small differences between multiple readings are harder to judge accurately.

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.