Excel Speedometer Chart With Two Needles

Charts & pivot tables · Updated November 19, 2026

Yes. In Excel for Microsoft 365 on Windows, you can make a two-needle speedometer by building a doughnut-chart gauge and placing two pointer lines over its center; Excel does not have a built-in speedometer chart type with two independently controlled needles. For a quick dashboard, the pointers can be shapes you position by eye; for a gauge that follows changing values, use a chart-based overlay or a carefully maintained custom setup.

What a two-needle speedometer chart shows

A speedometer, or gauge chart, places a value on a curved scale. Two needles let you compare two readings against that same scale—for example, actual performance and a target, current temperature and a warning threshold, or this month’s result and last month’s result. It is most useful when the audience needs an at-a-glance comparison rather than detailed analysis.

Excel’s standard chart gallery includes doughnut and pie charts, but not a dedicated gauge chart with two needles. A typical Excel gauge is assembled from a doughnut chart, whose colored slices form the scale, plus one or more pointers layered over it. The doughnut is an actual chart; the pointers are usually shapes or separate chart elements. That distinction matters: changing a source value will update the chart only if the needle is connected to data through a suitable chart setup. A line drawn with Insert > Shapes will not move automatically when a cell changes.

Plan the scale before building the visual. If the gauge runs from 0 to 100, both values should use that range. If the readings have different units or limits, convert them to a common scale first, or label the needles clearly. Comparing 72 degrees with 72 percent is not meaningful merely because the displayed numbers match.

Choose between manual and data-driven needles

For a presentation graphic or a dashboard that is updated occasionally, two manual shape pointers are the simplest and most dependable option. Make the colored arc with a doughnut chart, then draw two lines from its center toward the appropriate scale marks. This approach is easy to format and does not require macros. Its limitation is equally simple: when the underlying readings change, you must reposition the lines yourself.

For values that change frequently, a manually drawn pointer is a poor fit. A more automated construction uses a scatter chart to plot line endpoints calculated from worksheet values, then layers that chart over the doughnut gauge. Excel can update the scatter-series coordinates as the cells change. However, the two chart plot areas must be aligned, their axes must remain fixed, and resizing either chart can misalign the pointers. A workbook with this arrangement needs careful testing after edits to its layout.

  • Use shapes for a fixed report image, a one-off comparison, or a graphic that staff can reposition by hand.
  • Use a scatter overlay when the readings must update with cells and the workbook layout can be kept stable.
  • Use two ordinary charts or KPI cells when precise comparison matters more than the speedometer appearance.

Build the half-circle scale with a doughnut chart

Start with a small table for the gauge background. For a 0–100 scale divided into five equal color bands, enter five values of 20 and one value of 100. The first five slices make up half of the doughnut; the last slice occupies the other half and will be hidden. The exact number and size of bands are design choices: use fewer bands for a clean scale, or more when the colors represent meaningful ranges.

  1. Select the six background values, then choose Insert > Insert Pie or Doughnut Chart > Doughnut.
  2. Right-click a doughnut slice and choose Format Data Series. Increase the doughnut hole size until there is enough room for the pointer pivot and any center label. A hole around 60–70 percent is a reasonable starting point, not a rule.
  3. Format the slice representing 100 as No fill and No line. This removes the bottom half and leaves a semicircular band. If the blank half appears at the top or the bands start in an awkward position, adjust Angle of first slice in the Format Data Series pane until the blank area is at the bottom and the colored scale spans the top.
  4. Give the visible slices distinct fills, or use a deliberate progression such as red, amber, and green. Remove the legend and chart border if they add clutter. Add labels or tick marks only if readers need exact values; a colored arc alone does not communicate precise boundaries.

The angle setting can make the chart look reversed depending on the slice order. Check that the low end, midpoint, and high end appear where your labels say they are before adding pointers. A chart that looks attractive but places 0 on the wrong side can mislead readers.

Position two shape needles

Place the gauge on the worksheet with enough room around it to work. Select the chart, then use Insert > Shapes to add a line for each pointer. Draw both lines from the same apparent center of the doughnut to the arc. Use different colors, widths, or line styles so readers can distinguish them; for example, use a dark solid line for actual and a thinner dashed line for target. A small circle over the common starting point can conceal the line ends and make the pivot look intentional.

To locate a pointer, treat the half-circle as a scale from left to right: 0 is at the left endpoint, 50 is at the top, and 100 is at the right endpoint. Values between them follow the arc. On an evenly spaced semicircle, a reading of 65 belongs a little to the right of the top, while 25 belongs between the left endpoint and the top. Draw each pointer from the center toward its value. These are approximate visual placements, so add labeled ticks if exact reading matters.

For example, a two-needle gauge might show actual output at 65 and a target at 80. Use the same 0–100 scale for both. The first pointer lands just right of the midpoint; the second lands farther toward the high end. Add a small key such as “Actual” and “Target” beside the chart, or use data labels elsewhere on the dashboard. Two unlabelled pointers invite readers to guess which one represents which measure.

Shapes are independent of the doughnut slices. If the chart moves or is resized, the lines may not stay centered or proportionate. Keep the chart and pointers together in a stable layout, and recheck their alignment after changing chart size, row height, column width, or zoom. For a static image, you can group the chart and shapes after positioning them, but grouping is not a substitute for a data-linked needle.

Calculate pointer angles for a repeatable layout

When positioning needles by hand, a simple angle calculation helps avoid guessing. Put the first reading in B2, the second in B3, and use 0–100 as the scale. With the reading in B2 and the scale maximum 100, this formula returns the angle in degrees measured from the left endpoint toward the right endpoint: =180*B2/100. For a reading of 65, the result is 117 degrees. A reading of 80 gives 144 degrees. These values describe the scale position; they do not automatically rotate a drawn line shape.

For a more precise chart-based overlay, calculate the endpoint coordinates in a normalized square around the gauge center. Suppose B2 contains the reading, C2 contains its calculated angle, E2 contains the center’s horizontal coordinate, F2 the pointer length, and G2 the center’s vertical coordinate. With B2 holding 65, this angle formula in C2 returns 117: =180*B2/100. Then, with those same cell roles, the horizontal endpoint in H2 is =E2-F2*COS(RADIANS(C2)) and the vertical endpoint in I2 is =G2-F2*SIN(RADIANS(C2)). If the center is (50,50) and pointer length is 40, the approximate endpoint is (63.6,12.6). The upward direction is represented by a smaller vertical coordinate, as is usual for a screen coordinate system.

Those coordinates are mathematical positions, not pixel locations on a doughnut chart. To make them drive a needle, plot the center and endpoint as a line in an XY scatter chart, hide its axes and background, and align its plot area over the gauge. Repeat the endpoint calculation for the second reading and add a second line series with its own color. Keep the scatter axes fixed to the same coordinate range so that Excel does not rescale the needles as values change. Because chart plot areas and doughnut geometry do not automatically share a coordinate system, this method takes alignment work and should be checked after resizing.

Make values comparable and readable

A gauge is only as useful as its scale. If a reading can exceed the chart’s limits, decide what the display should do: cap the needle at the endpoint, extend the scale, or flag the out-of-range value in a separate cell. Do not let a value of 130 silently appear as though it were a normal 100. Likewise, if one needle is an actual value and the other is a target, use the same units and range so the visual distance between them has a valid meaning.

For values drawn from different ranges, normalize them before plotting. For instance, if one measure ranges from 0 to 100 and another from 0 to 500, convert each to a percentage of its own defined maximum, then explain that the gauge compares relative progress rather than raw quantities. Avoid using arbitrary limits that make a small difference look dramatic. The axis labels, threshold colors, and any accompanying text should make the chosen range clear.

Color should support, not replace, the pointer key. A red-to-green band can imply risk or status, but color meanings vary and may be difficult to distinguish for some readers. Use different pointer styles and text labels as well. If two needles nearly overlap, add their exact values in nearby cells or labels rather than shifting one pointer away from its true position.

Common problems and practical fixes

  • The hidden slice is visible: Select the intended bottom slice, not the whole series, and set its fill and border to No fill and No line. Confirm the slice order and rotation.
  • The scale reads backwards: Check the category order, the first-slice angle, and the labels. Rotate or reorder the slices, then verify that the low and high endpoints match the intended values.
  • A pointer misses the center: The line’s starting point is not exactly over the doughnut hole center. Zoom in, adjust the line endpoints, and add a center cap to hide tiny gaps.
  • A pointer stays put when a value changes: That is expected for a shape. Reposition it manually or replace the shape approach with a data-driven scatter overlay.
  • Two pointers are hard to tell apart: Use contrasting colors and line styles, and add a visible key and numeric values. Do not rely on color alone.
  • The dynamic overlay drifts after resizing: The scatter chart and doughnut chart no longer align. Restore their dimensions and plot-area position, then check the center and endpoints again.

When another visual is a better choice

Two needles can make a dashboard compact, but speedometer charts use space to show a small number of readings and are not ideal for close comparisons. Readers may find it easier to compare actual and target in a clustered bar chart, where both values share a straight baseline. A bullet-style display, made from a bar with a target marker and background ranges, can also communicate performance against a goal without implying a mechanical dial.

Choose the gauge when the visual metaphor is familiar, the range is stable, and a quick status impression is useful. Choose a bar or a table when exact values, small differences, multiple categories, or accessibility are priorities. In either case, show the numbers alongside the graphic. A gauge should complement the data, not make the reader estimate a value that could be printed directly.

Frequently Asked Questions

Can Excel make a speedometer chart with two needles automatically?
Not as a built-in chart type. You can create the gauge from a doughnut chart and add two shape pointers, but those shapes do not respond to cell changes. A scatter-chart overlay can plot data-driven pointers, though it requires alignment and fixed axes.

Can the two needles show different units?
They can be drawn on one chart, but a shared scale is meaningful only when both readings use comparable units and limits. Convert them to a clearly defined common measure, such as percent of target, or use separate visuals instead.

Will the shape needles move when I change the values?
No. A line added with Insert > Shapes is a drawing object, not a data-linked chart series. Move it manually when the value changes, or build a scatter overlay whose endpoints are calculated from worksheet cells.

Why is the bottom half of my doughnut still colored?
The gauge uses a hidden slice to create the open half-circle. Format that specific slice with No fill and No line, and adjust Angle of first slice if it is not positioned at the bottom.

Is a two-needle gauge better than two separate gauges?
Use one gauge when both readings share the same scale and direct comparison is the point. Separate gauges are clearer when the units, ranges, or meanings differ; a bar chart is often clearer when exact differences matter.

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.