Create a Speedometer Chart in Excel: A Step-by-Step Guide

To create a speedometer chart in Excel for Microsoft 365 on Windows, arrange your gauge bands as values in a doughnut chart, add a final value equal to the sum of the visible bands, and format that final slice with no fill to make a semicircle. For a moving needle, add a second pie chart using helper values and align it over the doughnut; the steps below show both approaches.

What an Excel speedometer chart shows

A speedometer chart, also called a gauge chart, compares one value with a defined range. It is useful for a single headline measure such as completion percentage, service level, capacity used, or a score. The colored arc gives context, while a pointer or highlighted marker indicates the current result.

Excel does not offer a dedicated speedometer chart type. The usual method combines standard chart types and formatting: a doughnut chart forms the colored arc, and a separate pie chart or a manually placed shape supplies the pointer. This distinction matters because the gauge is a visual design assembled from chart components, not a special chart with built-in gauge behavior.

A gauge works best when readers need to interpret one number quickly. It is less suitable for comparing many categories or showing a trend over time. A bar chart or line chart is often easier to read for those jobs.

Prepare the gauge bands

First choose the scale and decide what the colors mean. For a gauge from 0 to 100, you might use red for 0–30, amber for 30–70, and green for 70–100. Those intervals have widths of 30, 40, and 30, so the visible band values should add up to 100. The bands represent ranges, not the current result.

Enter this example in cells A1:B5. The last row is a hidden half-circle, not another performance band:

A1: Band; B1: Units
A2: Low; B2: 30
A3: Caution; B3: 40
A4: Good; B4: 30
A5: Hidden half; B5: 100

The first three values total 100, and the hidden value is also 100. The complete chart therefore contains 200 units: half for the colored scale and half for the blank underside. If you want a 0–200 scale, use band widths that total 200 and make the hidden value 200. In general, the hidden value should equal the total of the visible bands.

Insert and format the doughnut chart

Select A1:B5, then choose Insert > Insert Pie or Doughnut Chart > Doughnut.
Select the chart, right-click a slice, and choose Format Data Series. In Series Options, adjust Angle of first slice until the hidden half is at the bottom and the colored bands form an upper semicircle. The exact angle depends on the chart’s starting orientation, so use the preview rather than assuming a particular value.
Set Doughnut Hole Size to roughly 55%–65% to create a readable ring. This is a design choice; a larger hole leaves more room for a number in the center.
Click the hidden half slice by itself and open Format Data Point. Set Fill to No fill and Line to No line. If you select the entire series instead, you may accidentally remove the colors from every band.
Format the visible slices individually with clear, contrasting fills. Remove the legend if it repeats labels already shown elsewhere, and add a chart title or text label if the meaning of the gauge is not obvious.

In Excel for Microsoft 365 on Windows, chart formatting appears in the Format Data Series or Format Data Point pane after you right-click the relevant chart element. Excel for Mac has similar chart-formatting controls, though the pane and contextual ribbon layout can differ. In Excel for the web, some detailed chart-formatting controls may be unavailable; use the desktop app if you cannot select and format one slice precisely.

Add a current value and a static pointer

The simplest useful gauge does not need a complex second chart. Put the current score in a cell, then place a text box over the doughnut hole to display it. To make the number update with the worksheet, select the text box, click its formula bar, type an equals sign followed by the cell reference, and press Enter. For example, link the box to D3 if D3 contains the score. The text box then shows the cell’s value as it changes.

A static pointer is also an option when the gauge is an illustration or a report snapshot. Choose Insert > Shapes and add a narrow line from the center of the ring toward the appropriate point on the scale. Format its color and weight so it is visible without covering the colored bands. A shape does not move when the score changes, so it must be repositioned manually; label the gauge clearly if readers might mistake it for a live pointer.

Build a data-driven needle

To make a pointer respond to a changing score, use a second chart as an overlay. This takes more setup than a static line, but it keeps the pointer tied to worksheet values. Continue with the 0–100 gauge above. Enter a maximum of 100 in D2, the current value 65 in D3, and a needle width of 1 in D4. Keep the current value between zero and the maximum.

Use these helper cells for the pointer chart. With the maximum in D2, current value in D3, and needle width in D4, enter this formula in E2; for the example, it returns 65:

=D3

With the same D2:D4 layout, enter this formula in E3; it returns 1:

=D4

With the same layout, enter this formula in E4; at a value of 65 it returns 34, leaving the needle slice and remainder together equal to the 100-unit visible scale:

=MAX(0,D2-D3-D4)

With the same layout, enter this formula in E5; it returns 100 for the hidden half:

=D2

Label D1 as Maximum, D2 as Current value, D3 as Needle width, and E1:E5 with headings and helper labels as appropriate. For clarity, the values used by the chart are E2:E5: current value, needle width, remaining visible range, and hidden half. With the example, those values are 65, 1, 34, and 100.

Select the labels and values for the helper data and insert a pie chart. Format the pie slices so the current-value slice, remaining-range slice, and hidden-half slice have no fill and no line. Give the narrow needle-width slice a strong color. Set the pie chart’s first-slice angle to match the doughnut chart, remove its legend and chart area fill, and place it over the doughnut so the pie’s center aligns with the ring’s center. The narrow colored wedge acts as the pointer. Adjust chart size and position carefully; the two chart plot areas must line up for the pointer to land correctly.

The helper formula uses MAX to avoid a negative remainder if the score reaches the maximum. At the exact maximum, the pointer wedge can be slightly wider than the remaining scale geometry. For a cleaner endpoint, use a narrow needle width and keep the displayed score just below the maximum, or use a manually drawn pointer at the endpoint. Do not allow the input value to exceed the scale maximum without deciding how the gauge should represent that situation.

Make the gauge easier to read

A gauge can look polished and still communicate poorly. Use labels and formatting to explain its scale, units, and status. For example, a score of 65 might mean 65 percent, 65 points, or 65 items; the number alone does not tell the reader which. Add a title such as Monthly target attainment or put the unit in the center label.

Use a consistent scale. If one gauge runs from 0 to 100 and another from 0 to 120, their pointer positions are not directly comparable.
Choose color boundaries that reflect meaningful thresholds. Do not rely on color alone; include labels or a clear title, especially if the workbook will be read in grayscale.
Keep the number in the center large enough to read, and format decimals only when they add useful precision.
Check the gauge at the minimum, a middle value, and the maximum. A pointer that works at 65 may still be misaligned at the endpoints.

To show the score in a cell, enter a number format or use a linked text box rather than adding a static label that can become stale. If the data is a percentage stored as a decimal, such as 0.65, decide whether the chart scale uses 0–1 or 0–100 and convert consistently. Mixing those scales is a common reason a needle appears stuck near zero.

Common problems and fixes

The chart is a full circle. Confirm that the data includes the extra hidden value and that it equals the total of the visible bands. Then format that last data point with no fill and no line.
The blank section is on top. Change Angle of first slice in Format Data Series until the blank half is at the bottom. Rotate the doughnut and the pie overlay by the same amount.
Every slice loses its color. You likely formatted the series rather than the single hidden data point. Select the hidden slice again; clicking it twice can select an individual point.
The needle points to the wrong score. Check the helper values, the maximum, and the chart angles. Also verify the pie overlay is centered and sized to match the doughnut’s plot area.
The score changes but the needle does not. Make sure the pie chart uses the helper cells that contain formulas, not a separate set of typed values. Confirm the worksheet calculation setting is not preventing formulas from recalculating.
The gauge seems misleading. Revisit the scale and thresholds. A cropped or inconsistent range can exaggerate small differences, so use a gauge only when its boundaries are clear and defensible.

When to choose a different chart

A speedometer gauge is visually compact, but it uses space to show only one number. A horizontal bar with a target line is often easier to compare across departments or months, and it is easier to read precisely. A line chart is better for change over time; a column chart can compare a small number of categories. For dashboards, consider whether the gauge adds information beyond a clearly formatted score and a short status label.

Use the gauge when the audience needs an at-a-glance position within a fixed range, such as current capacity against a known limit. Avoid using several nearly identical gauges when readers need to rank values: aligned bars make differences easier to judge. You can keep the gauge’s colored arc and still add a nearby table or trend chart for context.

Frequently Asked Questions

Does Excel have a built-in speedometer chart?

No. Excel does not have a dedicated speedometer or gauge chart type. You can build one from a doughnut chart, format part of it as invisible, and add a pointer with a shape or an overlaid pie chart.

How do I make the speedometer needle move automatically?

Base a narrow pie-chart slice on helper cells that reference the current value, then overlay that pie chart on the doughnut gauge. When the input changes, the helper values and pointer chart update. Careful alignment and matching chart angles are essential.

How do I change the speedometer chart colors?

Select an individual visible doughnut slice, open Format Data Point, and choose a fill color. Repeat for each band. Select the hidden slice separately and set it to No fill so it remains transparent.

Can I create a speedometer chart in Excel for the web?

You can work with charts in Excel for the web, but detailed formatting of individual slices and precise overlay alignment may be limited compared with the desktop app. If a required control is missing, open the workbook in Excel for Microsoft 365 on Windows or Mac.

What is a good alternative to a gauge chart?

A bar chart with a target marker is a practical alternative for comparing values or showing progress against a goal. Use a line chart when the main question is how a measure changes over time.

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.