To create a speedometer chart in Excel for Microsoft 365 on Windows, make a doughnut chart from three threshold bands and a fourth segment equal to their combined total, then hide that fourth segment so the chart shows as a half gauge. Add a linked value or a needle-shaped object to show the current result; Excel does not have a built-in speedometer chart type.
What a speedometer chart shows
A speedometer chart, also called a gauge chart, presents one value against a bounded scale. It is useful for a compact status view, such as progress toward a target, capacity used, or a score on a 0-to-100 scale. Colored bands can make the position easy to interpret, while a number in the center gives the precise value.
In Excel, the familiar half-circle is assembled from ordinary chart elements rather than inserted as a special chart. The common approach uses a doughnut chart for the colored scale. A segment occupying the lower half is made invisible, leaving the upper half visible. A separate text box, shape, or chart overlay can provide the indicator.
That construction is visually effective, but it is not the same as a standard chart with a fully integrated, automatically moving pointer. A simple gauge can display the current figure clearly without a needle. If the indicator must move dynamically, plan for extra chart setup or consider a bullet chart, which is often easier to update and compare.
Prepare the scale and example data
First decide the scale minimum, maximum, and threshold boundaries. For a 0-to-100 gauge with three bands, use a low band from 0 to 30, a middle band from 30 to 70, and a high band from 70 to 100. The band sizes are therefore 30, 40, and 30. Add a fourth value of 100 to create the hidden half of the doughnut.
Enter this small table in cells A1:B5:
- A1: Band; B1: Size
- A2: Low; B2: 30
- A3: Medium; B3: 40
- A4: High; B4: 30
- A5: Hidden half; B5: 100
The first three numbers add up to 100, and the hidden segment adds another 100. Consequently, exactly half of the full doughnut represents the visible scale. The bands describe interval widths, not the current measurement. For a scale with a maximum of 200 and thresholds at 60 and 140, for example, use band sizes of 60, 80, and 60, followed by a hidden-half value of 200.
Keep the current measurement in a separate cell, such as D2, and the scale maximum in D3. For an example value of 65 on a 0-to-100 scale, D2 is 65 and D3 is 100. If the source value can exceed the scale or fall below zero, decide how the display should handle it before building the chart.
Create the half-doughnut chart
- Select A2:B5, including the labels and all four sizes.
- Choose Insert > Insert Pie or Doughnut Chart > Doughnut.
- If the chart places the blank half somewhere other than the bottom, right-click a segment and choose Format Data Series. Under Series Options, adjust Angle of first slice until the hidden segment sits along the lower half. The exact setting depends on the order and rotation of the slices, so check the preview rather than assuming a particular angle.
- Click the Hidden half segment again if necessary to select just that data point. Open Format Data Point and set its fill to No fill. Set its line to No line as well, if a border remains visible.
- Remove the legend if it is not useful, and resize the chart so the visible arc has enough room for a central label. Use the doughnut hole-size control in Format Data Series to make the ring thicker or thinner; a value around 60 to 70 percent is a reasonable starting point, not a required setting.
Excel may select the complete series on the first click. Clicking the same segment a second time selects an individual point, which is important when hiding only the final segment. Format the three visible segments with distinct fills. You can use a restrained palette or colors that match the meaning of the thresholds, but do not rely on color alone: add a clear value and, where relevant, labels or a short status description.
Show the current value and add an indicator
For the most robust first version, put the current value in a cell and display it in the center of the gauge. One way is to insert a text box, select its border, click the formula bar, type a reference such as =D2, and press Enter. The text box then reflects the value in D2. Format D2 as a number or percentage before linking it, and place the box over the chart’s hole. You can also use a cell-linked chart title or a simple shape containing a manually updated value.
For a 0-to-100 scale, D2 containing 65 means the result is at 65 percent of the maximum. If D2 contains a proportion such as 0.65, format the cell as a percentage rather than interpreting it as 0.65 on a 0-to-100 scale. Being consistent about whether the input is a raw measurement or a proportion prevents misleading labels.
A triangle, narrow line, or arrow shape can serve as a decorative needle, but a manually rotated shape will not turn automatically when D2 changes. A true moving pointer requires a carefully constructed overlay chart or another dynamic design. If you use an overlay, test it when values change, when the chart is resized, and when the workbook opens on another computer; chart alignment and transparent fills can be fragile. Do not imply that a static pointer represents a live value.
Make the gauge update with your data
The colored bands remain fixed if the thresholds do not change. The displayed measurement can update whenever its source cell changes, provided the linked label points to that cell. For a gauge that should show the share of a maximum, first calculate the ratio. With the current value in D2 and the maximum in D3, enter this in D4 to keep the plotted proportion between zero and one:
With the current measurement in D2 and the maximum in D3, enter this formula in D4: =MIN(MAX(D2/D3,0),1). If D2 is 65 and D3 is 100, D4 returns 0.65. Format D4 as a percentage to display 65%. This formula assumes D3 is greater than zero; prevent a zero maximum in the input or handle that case separately to avoid a division error.
This clamping is useful for a progress-style display: values below zero appear at the start and values above the maximum appear at the end. It also hides how far out of range the original value was. If exceeding the target matters, show the raw measurement alongside the gauge or add a warning rather than relying only on the clamped percentage.
If the maximum changes, update the band sizes so their sum equals the new maximum, and update the hidden segment to the same maximum. Otherwise, the visible arc will no longer represent half of the doughnut. For repeated reports, store the thresholds in cells and derive the band sizes from those threshold boundaries, rather than typing new sizes into the chart table each time.
Format the chart for a useful dashboard
A gauge should answer a question quickly. Give it a descriptive title such as Capacity used or Monthly target progress, state the measurement unit, and keep the scale limits visible somewhere nearby. A naked value of 65 could mean 65 units, 65 percent, or a score; a label removes that ambiguity.
- Use consistent colors and make sure text contrasts with the chart background.
- Keep the visible arc and central number large enough to read at the final dashboard size.
- Use data labels only when they clarify the thresholds; a crowded half-ring can be harder to read than a few labels in adjacent cells.
- Remove unnecessary chart borders and background fills so the gauge sits cleanly in a report.
- Check how it looks in grayscale or for viewers with color-vision differences. Pair colors with labels or clear threshold descriptions.
On Windows, chart commands appear on the Chart Design and Format tabs when the chart is selected, while detailed series and point controls are available by right-clicking the relevant chart element and choosing the corresponding Format command. On Excel for Mac, the same chart types and general workflow are available, but ribbon placement and the formatting pane can differ by release. Excel for the web can create and edit many chart settings, but some detailed formatting controls may be limited; use the desktop app if a specific point-formatting option is missing.
Common problems and how to fix them
- The chart is a complete ring: Confirm that the table includes the extra hidden-half value, which equals the sum of the three visible band sizes. Then set that data point to No fill.
- The blank area is at the top or side: Change Angle of first slice in Format Data Series and inspect the orientation. The order of the source rows affects where each slice appears.
- All slices disappear: You may have formatted the entire data series instead of only the hidden data point. Select the hidden slice individually and restore fills on the three visible points.
- The gauge looks uneven: Check that the hidden value equals the visible total. A hidden value of 100 paired with visible values totaling 90 does not produce an exact half-circle.
- The value label does not change: Verify that the text box is linked to the intended cell and that calculation is updating. A text box linked to a typed number will not follow a different input cell.
- The pointer disagrees with the number: A shape may be static, or the overlay may use a different scale or rotation. Treat the numeric value as authoritative until the pointer has been verified across the full range.
When to choose a different chart
Speedometer charts use a large amount of space to show one measurement, and a reader often has to estimate its position. For a dashboard with many measures, a data bar, conditional formatting, or a bullet chart can make comparisons more compact. A bullet chart puts a bar against a scale and threshold ranges, making the actual value and target easier to compare across several rows. Excel does not offer a dedicated bullet chart command, but a stacked bar chart can be formatted to create one.
Use a gauge when the dial appearance fits the audience or when a single high-level status needs visual emphasis. Prefer a simple number with a progress bar when accuracy, space, or accessibility matters more than the dial metaphor. Avoid using multiple gauges with different scale limits side by side unless each scale is clearly labeled; visually similar needle positions can represent very different values.
Frequently Asked Questions
Does Excel have a built-in speedometer chart?
No. Excel provides doughnut and pie charts that can be formatted into a gauge-style display. You assemble the half-circle from chart segments and add a value label or indicator separately.
Can a speedometer chart update automatically?
The value in a cell-linked text box can update automatically when its source cell changes. The colored threshold bands update only if their source data changes, and a manually rotated shape does not move with the value. A dynamic needle needs a more involved chart construction.
How do I change the speedometer chart colors?
Select an individual visible segment and use the chart formatting controls to change its fill. Select the hidden segment separately and leave it set to No fill so the lower half stays invisible.
Can I make a speedometer chart with percentages?
Yes. Use a scale from 0 to 100 and format the displayed value as a percentage, or use a ratio from 0 to 1 and label the scale consistently. Do not mix raw values and proportions without converting them.
Why is my speedometer chart not showing a half-circle?
The hidden segment should equal the total of the visible band values. Also check that the hidden point has no fill and that Angle of first slice places it at the bottom.
Related
- Change Block Capitals to Lowercase in Excel
- Cell in Microsoft Excel: Meaning, Types, and How to Use It
- Count Numbers vs Count in Excel PivotTables
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Excel Line Chart Examples: How to Choose and FormatExcel line chart examples include monthly sales trends, several product lines compared over time, actual results against a…
- Year to Date in Google Sheets Pivot Tables: How It WorksTo show year-to-date (YTD) figures in a Google Sheets pivot table, add a helper column to your source…
- Pareto Chart in Excel: How to Calculate and Build OneTo calculate a Pareto chart in Excel, arrange your categories and counts, sort the counts from largest to…
- Move a Pivot Chart to Another Sheet in ExcelIn Excel for Microsoft 365 on Windows, select the PivotChart, choose Chart Design > Move Chart, select Object…
- Create a Custom Combo Chart in ExcelTo create a custom combo chart in Excel for Microsoft 365 on Windows, select your category labels and…
- Excel Dashboard Design Templates: How to Choose and BuildExcel dashboard design templates are prebuilt workbooks or layouts that organize key metrics, charts, and filters on a…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.