Excel Speedometer Chart: How to Create a Gauge

Charts & pivot tables · Updated November 19, 2026

Excel for Microsoft 365 does not include a built-in speedometer chart type. You can make a semicircular gauge by inserting a doughnut chart, using one slice as the hidden half, formatting the visible slices as colored ranges, and adding a value label or manually positioned needle.

What Excel’s speedometer chart can—and cannot—do

A speedometer chart, also called a gauge chart, displays a value against a range using an arc, often divided into colored zones. It resembles a dashboard dial, but it is not one of Excel’s standard chart types. The chart is assembled from ordinary Excel elements, usually a doughnut chart and, if needed, shapes or an overlaid chart.

That distinction matters: Excel will not create a complete, automatically updating dial from a single command. A doughnut chart can show the ranges, and a linked cell or chart can show the current value, but a needle made from a line shape will not move when the value changes. Decide whether a static dashboard illustration is enough or whether the pointer itself must update automatically before choosing a design.

The instructions below are for Microsoft Excel for Microsoft 365 on Windows. Excel for Mac also has doughnut charts and chart-formatting controls, though the ribbon layout may differ. Excel for the web can display and edit many charts, but chart-formatting options may be more limited; use the desktop app if a particular slice-formatting control is unavailable.

Plan the gauge and choose its ranges

Start by deciding what the gauge measures and what its minimum and maximum mean. A dial without a clear scale can be decorative but misleading. For example, a customer-support team might show a response-time score from 0 to 100, with 0–30 marked red, 30–70 amber, and 70–100 green. The ranges should reflect the metric’s real interpretation, not simply use familiar colors.

For a simple semicircular gauge, the colored values need to total 100, representing the visible half of the dial. Add another value of 100 for the half that will be hidden. The chart therefore has 200 units in total, split evenly between the visible arc and blank half.

  • Use a small number of ranges so the dial remains readable.
  • Keep the minimum and maximum explicit, such as 0 and 100; do not let readers guess what the ends represent.
  • Choose colors with enough contrast, and do not rely on color alone to communicate a warning.
  • Decide whether the display needs a pointer, a central number, or both.

Prepare the doughnut-chart data

Enter a small two-column table in a blank part of the worksheet. For the 0–100 example, use these rows: Low, 30; Medium, 40; High, 30; Hidden, 100. The first three slices make up the visible arc, and the final slice creates the blank half. The labels are for your reference and may also appear in the chart legend until you remove it.

The numbers describe proportions of the entire doughnut, not percentages of the visible half. Since the total is 200, each visible unit occupies half as much chart angle as it would in a full-circle chart. Together, the first three values occupy 180 degrees, while Hidden occupies the other 180 degrees.

To use different thresholds, change the first three values while keeping their total at 100. For example, ranges of 25, 50, and 25 create two narrower outer zones and a wider middle zone. If your source values use a different scale, convert them to proportions of the intended visible range before building the chart.

Insert and orient the doughnut chart

  1. Select the category names and values, including the Hidden row.
  2. Choose Insert > Insert Pie or Doughnut Chart > Doughnut.
  3. With the chart selected, open the Format Data Series pane. Under Series Options, adjust Angle of first slice until the Hidden slice sits on the lower half of the circle. An angle such as 270 degrees is a useful starting point, but confirm the result visually; if the blank half appears at the top or side, rotate the chart until it is at the bottom.
  4. Format the Hidden data point so it has no fill and no line. Select that slice, open its formatting options, and set Fill to No fill and Border to No line. If the whole series is selected, click the slice again to target the individual data point.

Excel’s slice rotation and the order of the rows determine where each sector appears. The important outcome is a visible semicircle above a blank lower half, not a particular angle setting. If you reverse the order of the categories, the colored zones will appear in a different order, so check that the low and high ends match your labels.

Format the colored arc and add context

Select each visible slice and assign a fill color using the chart’s formatting pane. In the example, Low can be red, Medium amber, and High green. Remove the legend if it repeats information already shown elsewhere, then add a chart title that names the measure and its scale, such as “Service score (0–100).” Avoid a title like “Performance” if readers cannot tell what the number represents.

Set the doughnut hole size to make room for a central value. Select the doughnut series and adjust Doughnut Hole Size under Series Options. A larger hole leaves more room for a number but makes the colored band thinner; a smaller hole makes the arc bolder. Resize the chart and check the label at the final dashboard size, since small charts can make both labels and narrow range boundaries difficult to see.

You can place a text box in the center of the hole for the current value, such as “68 / 100.” If the number is typed directly into the box, remember to change it when the source value changes. For an updating display, put the value in a worksheet cell and link a text box to that cell using the formula bar. Make the scale and units visible near the chart so the number has meaning without requiring a reader to inspect the source table.

Add a needle—and understand its limits

A quick way to make the gauge look like a speedometer is to draw a line from the center of the hole toward the appropriate point on the arc. In Excel, choose Insert > Shapes > Line, then draw the line over the chart. Add a small circle at the center if you want to cover the line’s endpoint. For a value of 68 on a 0–100 semicircle that runs from low at the left to high at the right, the pointer belongs somewhat to the right of the top of the dial.

This shape-based needle is a visual annotation, not a live chart marker. If the value changes, the line does not rotate automatically; you must reposition it. Shapes can also shift relative to the chart if the chart is resized or moved. Keep a copy of the workbook or check the layout after making dashboard changes.

For a dashboard where the pointer must track values automatically, use a more advanced construction with a second chart layered over the doughnut, or consider a purpose-built dashboard tool or add-in. Layering charts requires careful alignment and formatting, and is more sensitive to edits than a basic gauge. Test the result with the minimum, midpoint, and maximum values, and make sure the pointer does not disappear into the hidden half.

Make the chart easier to read and maintain

A speedometer is most useful when it answers a question quickly. Put the measure, current value, units, and scale close together. If “68” could mean percent, points, dollars, or seconds, identify the unit. If the gauge is intended to show status, include a short text label such as “On target” rather than expecting color to carry the whole message.

Keep the worksheet data table intact and clearly labeled. When you change a range boundary, update the corresponding slice value and check that the visible values still total 100. If a chart seems to include an unintended category, use Chart Design > Select Data to inspect its source range. For a dashboard, place the data table on a separate worksheet if desired, but do not delete the source data that the chart depends on.

Use the gauge for a single measure, not as a substitute for a detailed comparison. A dial is visually prominent, but it uses space and makes precise differences harder to compare than a bar chart or a cell showing the exact value. In a report with many categories or time periods, a compact chart with a labeled axis is usually easier to interpret.

Common problems and practical alternatives

  • The chart is a full circle: Confirm that the Hidden value is present, totals 100, and has no fill or border. Also check the first-slice angle.
  • The blank half is at the top: Change Angle of first slice until the transparent sector is on the bottom. The desired orientation is more important than copying a setting from another workbook.
  • The colors appear in the wrong order: Reorder the data rows or format the individual slices again. A pie or doughnut chart follows the order of its source categories.
  • The chart does not show the newest value: Check the chart’s source range with Chart Design > Select Data. A manually drawn needle or typed text label will not update from the data automatically.
  • The gauge is hard to compare: Use a bar chart, bullet-style chart, or conditional formatting instead. These alternatives can make differences among several values clearer.

For simple progress toward a target, a data bar or a labeled percentage may be more direct than a gauge. For several products, teams, or months, a bar chart makes side-by-side comparisons easier. A speedometer is best when one headline value needs a compact status display and readers understand the thresholds.

Frequently Asked Questions

Can I insert a speedometer chart directly in Excel?
Not as a built-in chart type in Excel for Microsoft 365. Create a custom gauge from a doughnut chart and format one slice as the hidden half. A needle or pointer requires an additional shape or chart layer.

How do I make a half-circle gauge in Excel?
Create doughnut-chart data whose visible categories total 100, add a Hidden category worth 100, insert a doughnut chart, and remove the Hidden slice’s fill and line. Rotate the first slice so the blank half is underneath the colored arc.

Will an Excel speedometer needle update when the cell changes?
Not if the needle is a line shape drawn over the chart. A linked text box can display an updated cell value, but the drawn line remains where it was. An automatically moving pointer needs a more advanced chart overlay or another tool.

Can I make a speedometer chart in Excel for Mac?
Yes. Excel for Mac supports doughnut charts and chart formatting. The ribbon and pane layout may look different from Windows, so locate the doughnut-chart insertion and individual data-point formatting controls in the Mac interface.

Is a speedometer chart better than a bar chart?
Usually not for comparing several values or showing small differences. A gauge can make one current value stand out against thresholds, while a bar chart is generally clearer for comparisons and exact ranking.

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.