To make a speedometer gauge chart in Excel, build a doughnut chart from value bands, hide the bottom half, and add a marker for the current value. Excel does not have a dedicated speedometer chart type, so the gauge is assembled from standard charts and a small data table.
What a speedometer chart shows
A speedometer, or gauge, chart displays one measure against a defined range. For example, a sales team might show progress toward a monthly target on a scale from 0 to 100, with green for acceptable results, amber for caution, and red for results that need attention. The familiar half-circle shape is compact and can make a single number easy to scan in a dashboard.
Excel does not provide a built-in gauge chart with a value pointer. A doughnut chart can create the colored scale, but it does not automatically show where the current value falls. A separate marker, such as an overlaid pie-chart wedge, is needed for a moving needle. A gauge is therefore a designed visualization rather than a special chart object; it takes more setup than a bar chart and can be less accessible or precise to read.
Choose a useful range and bands
Decide on the scale before creating the chart. It should have a meaningful minimum and maximum, and the color bands should correspond to real thresholds rather than arbitrary decoration. In the example below, the scale runs from 0 to 100, with green from 0 to 50, amber from 50 to 80, and red from 80 to 100. The sample reading is 68.
For a gauge that represents a percentage, 0–100 is often intuitive. For another measure, such as response time or inventory, use a scale that matches the metric and clearly label its units. Decide what happens when a value falls below the minimum or above the maximum: you can flag the out-of-range value separately, or deliberately cap the displayed needle at an endpoint. Do not silently let a reading imply a value the scale cannot represent.
Prepare the doughnut chart data
In a blank worksheet, enter the maximum, current reading, and band boundaries in D2:D5. Use these labels and example values: D2 is Maximum with 100, D3 is Current with 68, D4 is Green limit with 50, and D5 is Red starts with 80. In A1:B5, create the table below. The last row is the hidden half of the chart; its value must equal the full scale maximum.
- A1: Zone; B1: Size
- A2: Green; B2: formula below
- A3: Amber; B3: formula below
- A4: Red; B4: formula below
- A5: Hidden half; B5: formula below
With the maximum in D2 and the green limit in D4, enter this in B2. It returns 50, the green band’s width.
=D4
With the amber band boundaries in D4 and D5, enter this in B3. It returns 30, calculated as 80 minus 50.
=D5-D4
With the maximum in D2 and the point where red starts in D5, enter this in B4. It returns 20, calculated as 100 minus 80.
With the maximum in D2, enter this in B5. It returns 100, which creates the other half of the circle to hide.
=D2
For clarity, the formula in B4 is =D2-D5. Check that the thresholds are in order and that the band widths add up to the maximum: 50 + 30 + 20 = 100. The displayed half of the doughnut represents those 100 units; the hidden half represents another 100. If you change the maximum or thresholds, the formulas keep the band sizes consistent.
Create the semi-circular gauge
- Select A1:B5, then choose Insert > Insert Pie or Doughnut Chart > Doughnut.
- Right-click a band and choose Format Data Series. In the formatting pane, set Angle of first slice to 270 degrees. This puts the three colored bands across the upper half and the hidden segment across the lower half. If the orientation is not as expected, check that the angle and row order match the example.
- Click the Hidden half segment separately and open Format Data Point. Set its fill to No fill and its line to No line. The lower half should now appear blank.
- Give the Green, Amber, and Red points distinct fills. Remove the legend if it adds clutter, and adjust Doughnut Hole Size in the Format Data Series pane to make the band thick enough to read.
Excel may display data labels or a legend depending on how the chart is formatted. Remove labels that show the band-size numbers as if they were readings. A small title or a nearby cell can identify the metric and units; keep the actual current value visible too. The colored arc alone is only a scale, not a complete gauge.
Add a needle that updates with the reading
One way to create a movable needle is to overlay a pie chart on the doughnut chart. This method uses a narrow pie slice as the pointer. It is more involved than making the colored arc, but it updates when the current reading changes. Add the following helper values in F2:F4, with labels in E2:E4: Start, Needle width, and Remainder. Use a width of 1 for this example.
With the current reading in D3, enter this in F2. It returns 68, the amount of the scale before the needle.
=D3
With the maximum in D2, current reading in D3, and needle width in F3, enter this in F4. It returns 131, so the three pie values total 200, twice the scale maximum.
=2*D2-D3-F3
Enter 1 as a fixed value in F3. Select E2:F4 and choose Insert > Insert Pie or Doughnut Chart > 2-D Pie. Set the pie chart’s angle of first slice to 270 degrees, matching the doughnut. Format the first and third pie slices with no fill and no line, and give the middle slice a dark fill. The narrow middle slice then marks the reading along the half-circle.
Place the pie chart over the doughnut chart, aligning their centers and outer edges. Set the pie chart area and plot area to no fill and no line so they do not cover the gauge beneath. Remove its title, legend, and labels. Chart overlays can take careful resizing; if the centers do not line up, the pointer will appear offset. The needle width controls how broad the pointer wedge looks. If the current reading changes, F2 and F4 recalculate and the marker moves, provided the charts remain aligned.
Make the chart easier to read
A gauge is most useful when its scale, current reading, and interpretation are all apparent. Add a short chart title that names the measure, and put units or the scale endpoints where readers can see them. A value of 68 might mean 68 percent, 68 units, or something else; the number alone is ambiguous. Use color plus labels or a written status when the meaning matters, because color differences may not be clear to every reader.
- Use a small number of bands with clear meanings. Too many narrow segments make the arc hard to interpret.
- Keep the chart’s maximum and thresholds stable when comparing readings across teams or time periods.
- Show the exact current value next to the chart, not only a pointer that readers must estimate.
- Use the same colors and threshold definitions throughout a dashboard, and explain what each color means.
For Windows in Excel for Microsoft 365, the chart commands above are on the Insert tab; most chart appearance settings are available by right-clicking a chart element and choosing its format command. Excel for Mac has comparable chart-insertion and formatting controls, though the pane layout and some command names can differ. In Excel for the web, chart creation and basic formatting are available, but detailed formatting and precise chart overlay work may be more limited than in the Windows desktop app.
Common problems and how to fix them
- The chart is a full doughnut. Confirm that the table includes the Hidden half value and that this point has no fill. If the hidden row is omitted, the visible bands occupy the entire circle.
- The blank half is on top. Check the angle of first slice and the order of the data rows. With the example order, 270 degrees positions the hidden half below.
- The colored bands have the wrong proportions. Check the band formulas and make sure the bands total the maximum. A threshold entered as a band width rather than an endpoint can produce incorrect proportions.
- The needle points to the wrong place. The pie chart and doughnut must use the same starting angle and scale assumptions. Confirm that the pie values total twice the maximum and that the first pie value equals the current reading.
- The needle does not move when the value changes. Check that the helper cells are formulas linked to D3 and that the pie chart uses those cells. If you typed a fixed number into the chart’s source data, it will not follow the reading.
- The gauge suggests false precision. A pointer’s position is an estimate, especially on a small chart. Keep the numeric value visible and avoid treating a visual gauge as a substitute for exact data.
When to use a different chart
A gauge is suitable for a single headline measure with a meaningful range, such as progress toward a fixed target or a status level with agreed thresholds. It is less suitable for comparing many categories, showing change over time, or displaying several measures at once. A bar chart usually makes comparisons and small differences easier to judge because readers can compare bar lengths against a common baseline. A line chart is a better choice when the main question is how a measure changes over time.
Consider the space and maintenance cost too. A two-chart overlay may need realignment after resizing, and a complicated dashboard can become difficult to update if every measure has its own manually assembled gauge. For several metrics, a consistent set of bars, data bars, or labeled status indicators may communicate more with less formatting work. Choose the gauge because its range and thresholds help answer a specific question, not simply because it resembles a car dashboard.
Frequently Asked Questions
Does Excel have a built-in speedometer chart?
No. Excel has doughnut and pie charts, which can be combined and formatted to make a gauge, but there is no dedicated speedometer chart type.
Can the needle update automatically?
Yes. If the pie-chart helper values reference the current-reading cell, changing that reading recalculates the pointer position. The overlaid charts still need to remain aligned.
Can I make a full-circle gauge instead of a half-circle?
Yes. Use a doughnut chart without the extra hidden-half segment, then design the marker for the full scale. The example’s half-circle needle setup assumes a semicircular range, so do not reuse it unchanged for a full-circle layout.
Why does my gauge show a blank or incorrectly colored segment?
Check the band values, data-point fills, row order, and angle of first slice. The hidden segment should equal the maximum and have no fill; the three colored band values should add up to that same maximum.
Is a speedometer chart the best choice for a dashboard?
Only when one value against fixed thresholds is the main message. For comparisons or trends, a bar or line chart is generally easier to read and compare accurately.
Related
- Percent of Number in an Excel PivotTable: Show Values
- Password Protect an Excel Workbook to Require a Password
- Password Protect an Excel Spreadsheet: Steps and Safety
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- X Line on a Graph: Meaning and How to Read ItThe “X line” on a graph usually means the x-axis: the horizontal reference line that runs from left…
- Radar Chart in Google Sheets: How to Create and Read OneTo make a radar chart in Google Sheets, put category names in the first column and each data…
- Excel Speedometer Chart: Build a Gauge Step by StepTo build a speedometer chart in Excel, make a doughnut chart from your gauge ranges, hide its lower…
- How to Create a Chart Audit Form in Excel: Step by StepCreate a chart audit form in Excel by listing each audit as one row, adding consistent Yes/No/N/A fields…
- Stacked Column Chart in Excel: Create and UseA stacked column chart in Excel displays several data series as colored sections stacked within vertical columns, so…
- Sunburst Chart Excel Template: How to Build and FormatA Sunburst chart Excel template is a workbook layout with hierarchical category columns and one numeric value column,…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.