Excel Speedometer Chart: Build a Gauge Step by Step

Charts & pivot tables · Updated November 20, 2026

To build a speedometer chart in Excel, make a doughnut chart from your gauge ranges, hide its lower half, then overlay a pie chart containing a narrow pointer slice. For Microsoft Excel for Microsoft 365 on Windows, you’ll need a current reading, a maximum value, and a few helper cells. The finished gauge is a visual display, not a built-in Excel chart type, so you can customize its colors and scale.

What You’ll Need

  • Excel for Microsoft 365 on Windows. The chart types and formatting options below are also available in recent desktop versions of Excel.
  • A current value and a defined minimum and maximum. This example uses a 0–100 scale and a reading of 67.
  • At least three ranges, such as green, yellow, and red, whose values add up to the full scale. You can change the boundaries to suit your measure.
  • A clear area of the worksheet for two charts. A square layout usually makes it easier to align the gauge and pointer.

Step-by-Step

  1. Choose the scale and enter the current reading. Put the current reading in B2 and enter 67. In this example, the gauge starts at 0 and ends at 100. Keep the reading within that range; the formula in a later step will clamp out-of-range values so the needle does not point beyond the scale. Add a label such as Current reading in A2 so it is easy to identify the input.
  2. Create the gauge-range table. In A5:B8, enter these labels and values: Green / 50, Yellow / 30, Red / 20, Hidden / 100. The first three values total 100, which is the scale maximum. The final 100 creates the invisible half of the doughnut. The order of the colored ranges matters because it controls their order around the arc. If your categories have different boundaries, use their widths rather than their endpoints: for a 0–100 gauge with green from 0 to 60, yellow from 60 to 85, and red from 85 to 100, enter 60, 25, and 15, followed by the hidden 100.
  3. Insert the doughnut chart. Select A5:B8, then choose Insert > Insert Pie or Doughnut Chart > Doughnut. Remove the chart title and legend if Excel adds them. They take up space and do not help explain a simple gauge. If the chart includes unwanted blank categories, check that only the four table rows are selected.
  4. Set the doughnut orientation and hole. Click a colored ring segment, right-click, and choose Format Data Series. In Series Options, set Angle of first slice to 270 degrees. This places the colored ranges across the upper half of the gauge, with the hidden section below. Set Doughnut Hole Size to around 60%. A larger hole leaves less room for the colored band; a smaller hole makes it thicker. If the arc is on the wrong side, check the angle and the order of your table rows.
  5. Hide the lower half of the gauge. Click the Hidden segment once to select the series, then click that segment again to select just that data point. Right-click and choose Format Data Point. In the Format Data Point pane, open Fill & Line and select No fill; set its line to No line as well. The lower half should now look transparent, leaving a semicircular scale. If Excel selects the whole series rather than one slice, click the segment again before opening its formatting pane.
  6. Make a table for the pointer. In D4:E8, enter labels and values in this order: Before pointer, Pointer, After pointer, Hidden. Set the Pointer value to 1 and the Hidden value to 100. With the current reading in B2 and the scale running from 0 to 100, use this formula for Before pointer in E5: =MIN(MAX($B$2,0),100). It returns 67 when B2 contains 67, and limits the result to the 0–100 scale if the reading is outside it. In E7, enter the remaining visible scale amount as a number: with B2 at 67, enter 33. For a changing reading, you can instead use =100-E5 in E7. The four pointer values should total 201: 67 + 1 + 33 + 100. The one-unit pointer slice stays narrow while moving around the visible half.
  7. Insert a pie chart for the pointer. Select D4:E8 and choose Insert > Insert Pie or Doughnut Chart > 2-D Pie. Remove the title and legend. Right-click the pie and choose Format Data Series; set Angle of first slice to 270 degrees, matching the doughnut. The sequence of values places the pointer slice after the portion representing the current reading. Because the narrow pointer has a small but nonzero width, its center can be slightly offset from the exact reading; a value of 1 keeps that offset small on a 0–100 gauge.
  8. Show only the pointer slice. Select the Before pointer slice and set Fill to No fill and Line to No line. Repeat for After pointer and Hidden. Leave the Pointer slice filled with a contrasting color, such as black, and give it no outline. Click a slice twice if needed to format an individual data point rather than the entire series. The result should be a thin wedge extending from the pie’s center toward the scale.
  9. Overlay and align the charts. Make the pie chart the same height and width as the doughnut chart. On the Chart Format tab, use the Size boxes to enter matching dimensions. Remove the pie chart’s chart-area fill and border so the doughnut remains visible underneath, then drag the pie chart over the doughnut. Align their centers carefully; the pointer’s base should meet the gauge’s center. If the chart areas obscure the gauge, set the pie chart area to No fill and No line. A square chart object makes matching the circles easier.
  10. Check the reading, labels, and appearance. Change B2 to a low value, a middle value, and 100 to check that the pointer moves through the colored arc. If you want a numeric readout, place a linked cell or a text box in the doughnut’s open center. Use the same scale limits in the displayed number and helper cells. Add labels or a small note under the chart to explain what green, yellow, and red mean; color alone may not make thresholds clear to every reader.

Common Mistakes

Adding endpoints instead of range widths. For thresholds of 0–60, 60–85, and 85–100, the values are 60, 25, and 15, not 60, 85, and 100. The colored values must add to the maximum scale value; otherwise the arc proportions will be wrong.

Forgetting the hidden slice. The extra value equal to the scale maximum creates the blank half. If you omit it or fail to make it transparent, the doughnut appears as a full ring or the lower half remains visible.

Using a different rotation for each chart. The pointer pie and gauge doughnut need the same first-slice angle and matching chart geometry. Otherwise the pointer can appear rotated or off-center even when its data values are correct.

Making the pointer slice too wide. A large pointer value produces a broad wedge that can look like another colored range. Keep it small relative to the scale, and use a high-contrast fill so it remains visible.

Tips

Use a consistent set of range widths when the gauge is meant to compare multiple readings. If the gauge represents a different maximum, replace 100 in the range table and pointer calculations with that maximum, and make sure the visible ranges still total that value. For example, on a 0–200 scale, a reading of 134 is 67% of the arc; the scale range widths should total 200, and the hidden section should also be 200.

Keep the source tables on the same worksheet or move them to a clearly named helper sheet. You can hide the helper sheet after checking the chart, but avoid deleting its cells: the charts depend on them. Use distinct, accessible colors and add text labels for important thresholds. A needle and color bands are quick to read, but a person with color-vision differences may not distinguish the bands by color alone.

When you update the reading often, keep B2 as the single input cell and let the helper values reference it. Protecting the rest of the sheet can reduce accidental changes, but make sure the input remains editable. A speedometer is best for a quick at-a-glance display; for exact comparisons across many readings, a bar chart or line chart is usually easier to interpret.

Troubleshooting

The gauge shows a full circle: Confirm that the Hidden row is included in the doughnut’s source data and that its fill and line are both set to No fill and No line. Also check the doughnut’s first-slice angle.

The pointer is missing: Verify that the Pointer value is greater than zero, that this slice has a visible fill, and that the other pie slices—not the pointer—were made transparent. If the pointer is hard to see, increase its value slightly, such as from 1 to 2, while remembering that a wider slice can make the reading less precise.

The pointer moves in the wrong direction or starts in the wrong place: Check the pie data order and make sure the doughnut and pie use the same angle. Use values in the order Before pointer, Pointer, After pointer, Hidden. A changed order changes the pointer’s position.

The pointer is off-center: Match the charts’ height and width, remove titles and legends, and adjust their positions so the circular plot areas—not just the outer chart edges—line up. Excel can reserve different plot-area space for charts, so matching the outer sizes may require small visual adjustments.

The pointer does not update: Check that the pie chart uses the helper table and that the formula in E7 references E5. If calculation is set to manual, choose Formulas > Calculation Options > Automatic. Make sure B2 contains a number rather than text.

Frequently Asked Questions

Does Excel have a built-in speedometer chart?
No. Excel does not provide a chart type named Speedometer or Gauge. The doughnut-and-pie method creates the effect from standard charts, so you can adjust the ranges, colors, and pointer.

Can I use a scale other than 0–100?
Yes. Set the colored range widths to add up to your chosen maximum, and set the hidden value to that same maximum. Update the pointer calculation and remaining-range calculation to use the new maximum as well.

Can I make the pointer update automatically?
Yes. Keep the live reading in B2, use a formula for the Before pointer value, and calculate the After pointer value from the maximum minus that value. The chart updates when the input changes, provided calculation is automatic.

Can I create this chart in Excel for Mac or Excel for the web?
Recent Excel for Mac versions include doughnut and pie charts, though ribbon labels and chart-formatting panes may differ from Windows. Excel for the web can work with many charts, but chart formatting controls may be more limited; if you cannot set individual slices to No fill or align the overlays, open the workbook in desktop Excel.

Why is my pointer slightly off the exact value?
The pointer must occupy a slice with some width, so its center is not mathematically identical to a zero-width mark. A small pointer value such as 1 minimizes the difference. If exact reading precision matters, display the numeric value alongside the gauge.

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.