To make a pie chart speedometer in Excel, build a doughnut chart from the measured value, the unused part of the scale, and a hidden segment, then place a line or arrow over it as the needle. For example, a score of 65 on a 0–100 scale uses values of 65, 35, and 100; the hidden 100 creates a half-doughnut, while the pointer shows the score.
What an Excel speedometer chart shows
A speedometer, or gauge, is a visual way to show one current measurement against a fixed range. It might show a project’s completion percentage, a customer satisfaction score, or the temperature of a process. The familiar design has a curved, colored scale and a pointer. Excel does not have a built-in chart type called Speedometer or Gauge, so people make one from standard charts and shapes.
Although it is often called a pie chart speedometer, the scale is usually a doughnut chart rather than a pie chart. A doughnut leaves a clear center for the pointer’s pivot and makes a curved band around it. A pie chart can also be used in some gauge designs, but its filled center tends to obscure the pivot and can make the result look crowded.
A gauge is most useful when the reader needs to judge one value quickly against a known range. It is less useful for comparing many categories or seeing a trend over time. A bar chart, line chart, or ordinary doughnut may communicate those jobs more clearly.
Plan the scale and sample data
Decide the minimum and maximum before making the chart. This example uses a scale from 0 to 100 and a current result of 65. Put the maximum in B2 and the result in B3. Use C2:C4 for the doughnut labels and D2:D4 for its values. The three segments are the result, the remainder of the visible scale, and a hidden segment equal to the whole scale.
- In C2, enter Actual; in C3, enter Remaining; in C4, enter Hidden.
- With the maximum in B2 and the measured value in B3, enter
=MIN(MAX(0,$B$3),$B$2)in D2. For a maximum of 100 and a value of 65, this returns 65. - With the same layout, enter
=$B$2-D2in D3. It returns 35, the portion of the visible scale not yet reached. - With the same layout, enter
=$B$2in D4. It returns 100, the segment that will be hidden.
The chart therefore has a total of 200: 100 visible units split between Actual and Remaining, and 100 hidden units. The hidden half is what turns a complete ring into a semicircular scale. If the maximum is 60 instead, use 60 for the hidden segment and make sure the actual and remaining segments add to 60.
Create the half-doughnut in Excel
- Select C2:D4, including the labels and the three calculated values.
- On the Windows ribbon, choose Insert > Insert Pie or Doughnut Chart > Doughnut.
- Right-click a ring segment and choose Format Data Series. In Series Options, set the angle of the first slice to 270 degrees as a starting point. The exact position depends on the slice order and rotation, so check that the Hidden segment occupies the lower half. If it does not, adjust the angle or reorder the rows until it does.
- Click the Hidden segment once to select the series, then click that segment again to select just the data point. In the formatting pane, set its fill to No fill and its border to No line. The remaining visible segments should now form a semicircular band.
- Set the doughnut hole size to suit the layout; around 60–70 percent is a reasonable starting range. Remove the legend and chart title if they add no useful information.
To format a visible segment, select it and choose a fill color in the Format Data Point pane. You can use a single color for a simple gauge or use separate data points to create zones such as low, acceptable, and high. If the chart’s lower half still appears colored, make sure you selected the Hidden data point rather than changing the formatting for the whole series.
On Excel for Mac, the same basic approach works from the Insert tab by choosing a Doughnut chart; chart-formatting controls appear in the Format Data Series or Format Data Point pane, though their placement can vary by release. Excel for the web can display and edit many charts, but some detailed formatting controls may be more limited than in the desktop app.
Add a needle and a value label
The simplest pointer is a line or narrow arrow shape placed over the chart. Select the chart, then use Insert > Shapes and choose a line or arrow. Draw from the center of the doughnut hole toward the scale. Add a small circle at the center if you want the pivot to look finished. Set the pointer’s outline color and width so it remains visible against the gauge.
For a 0–100 scale, 0 belongs at the left end of the arc, 50 at the top, and 100 at the right end. A score of 65 should therefore point to the right of the top. If the scale uses another maximum, calculate the position as a fraction: divide the reading by the maximum. A value of 30 on a 60-point scale is halfway through the arc, just like 50 on a 100-point scale.
A manually drawn shape does not move when the value cell changes. It is suitable for a fixed illustration or a small report that is updated by hand, but it is not a fully dynamic pointer. You can reposition the line after changing the value, or build a more elaborate design with a second, transparent chart layered over the doughnut. Layered charts need careful alignment and can shift when resized, so test them before sharing the workbook. For many dashboards, displaying the number prominently beside the gauge is more reliable than trying to make the pointer update automatically.
To show the measurement, add a text box or a linked cell near the center or below the arc. A linked text box can display the current cell value without typing it again: select the text box, click the formula bar, type an equals sign followed by the cell reference, and press Enter. For example, link it to B3 to display the current score. Add units or a descriptive label, such as 65 points or Completion, so readers do not have to guess what the number means.
Use colored bands and meaningful labels
For a gauge with zones, replace the simple Actual and Remaining arrangement with segments that represent the bands. For example, a 0–100 performance scale might use low 0–40, medium 40–75, and high 75–100, followed by a hidden segment of 100. Those visible band values sum to 100; adding the hidden 100 makes the complete doughnut total 200. Apply a distinct fill to each band and hide the lower segment as before.
Keep the categories and their meanings explicit. A red, yellow, and green palette may be familiar, but color alone is not an explanation and may not be accessible to every reader. Add endpoint labels such as 0 and 100, and use text such as Low, Target, or High when those terms are meaningful. Avoid using a gauge to imply a universal good or bad threshold when the correct target depends on the situation.
With a dynamic score, the colored bands stay fixed while the displayed value changes. The pointer then needs to move to match the score. If you choose a static shape pointer, update it along with the data; otherwise, the chart can contradict its own number. A clearly labeled numeric value is the best safeguard against that mismatch.
Common problems and how to fix them
- The chart is a full ring: The Hidden segment has not been made transparent, or the wrong data point was formatted. Select only the Hidden slice and set both its fill and line to No fill.
- The open half is at the top: Change the angle of the first slice or reorder the data points. The goal is to place the hidden segment on the lower half, not to rely on a particular rotation setting without checking the result.
- The gauge shows an odd gap or wrong proportions: Check the values. Actual plus Remaining should equal the scale maximum, and Hidden should also equal that maximum for a half-circle.
- A score below zero or above the maximum distorts the chart: The example formula in D2 clamps the plotted score between zero and the maximum. Decide separately how to report an out-of-range raw value; clamping the display does not correct the source data.
- The pointer moves out of place after resizing: A shape is positioned relative to the sheet or chart, not driven by the score. Select the chart and pointer together when moving or resizing, or use a carefully aligned overlay chart.
- The gauge looks impressive but is hard to read: Reduce decorative effects, label the scale, and make the actual number easy to find. A gauge with no units, endpoints, or target context may look precise without conveying useful meaning.
When a gauge is the right chart—and when it is not
A speedometer can be effective for a single headline measure with a meaningful minimum, maximum, and target. It is familiar to many readers, and a half-circle leaves room for a number in the middle. It can also fit a dashboard tile where the viewer needs a quick status rather than a detailed analysis.
It has real limitations. The arc uses a lot of space for one value, and people may find it harder to compare angles than to compare the lengths of bars. A gauge also hides history: a score of 65 does not reveal whether the measure rose from 40 or fell from 90. If you need to compare several teams, use a bar chart; if you need to show change over time, use a line chart. If the main point is a percentage of completion, a progress bar or a simple doughnut may be easier to read.
Do not assume that adding more colors or tick marks makes a gauge more informative. Use only the scale divisions that support a real decision. If values are close together, show the exact number and consider a bar chart, where small differences are easier to compare.
Frequently Asked Questions
Does Excel have a built-in speedometer chart?
No. Microsoft Excel for Microsoft 365 does not provide a dedicated speedometer chart type. The common approach is to format a doughnut chart as a half-circle and add a pointer using a shape or a layered chart.
Why use a doughnut chart instead of a pie chart?
A doughnut chart has a hole in the middle, which gives the pointer a natural pivot area and leaves room for a number. The term pie chart speedometer is widely used, but a half-doughnut is usually the more practical base chart.
Can the needle update automatically when the value changes?
A line or arrow inserted as a shape will not move automatically with a cell value. It must be repositioned, or you can create a more complex layered-chart design whose alignment and behavior should be checked after edits.
Can I make the scale run from 0 to 60 instead of 0 to 100?
Yes. Use 60 as the maximum, make the visible segments add to 60, and set the hidden segment to 60. The displayed reading should use the same scale so the gauge’s proportions remain meaningful.
Why does my speedometer display a full circle?
The segment intended to be hidden may still have a fill or border, or the rotation may place it somewhere other than the lower half. Format that single segment as No fill and No line, then adjust the first-slice angle or row order until it is below the arc.
Related
- Open an Excel Sheet: Quick Steps and File Options
- Open Issues List Template Excel: What to Include
- Open a DB File in Excel: Methods, Limits, and Options
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- How to Insert Sparklines in Excel Cells Step by StepTo insert a sparkline in Excel for Microsoft 365 on Windows, select the cell where the miniature chart…
- Excel Histogram Custom Bins: How to Set ThemIn Excel for Microsoft 365 on Windows, select your numeric data, choose Insert > Insert Statistic Chart >…
- Excel Mini Chart in Cell: Add and Format SparklinesIn Excel, a mini chart displayed in a worksheet cell is called a sparkline. In Excel for Microsoft…
- How to Make a Proper Histogram in Excel: Step by StepTo make a proper histogram in Excel, put one set of numeric measurements in a column, select the…
- Excel Bar Graph Creation: Steps, Tips, and FixesTo create a bar graph in Excel for Microsoft 365 on Windows, select a labeled data range, then…
- Excel Waterfall Chart: Make the Last Column a TotalTo make the last column in an Excel waterfall chart a total, select the chart, click the final…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.