Excel Horizontal Bullet Chart: Build One Step by Step

Charts & pivot tables · Updated November 19, 2026

To make a horizontal bullet chart in Excel for Microsoft 365 on Windows, create a stacked bar chart from the target scale’s ranges, then place a narrow actual-value bar and a target marker over that chart. Excel does not provide a dedicated Bullet Chart command, so this practical method combines a native chart with shapes; the shapes are visual annotations and do not update automatically when the data changes.

What a horizontal bullet chart shows

A bullet chart is a compact way to compare a measured value with a goal and a set of performance ranges. It is often used in dashboards as a space-saving alternative to a gauge. The horizontal direction represents a numeric scale, while each row represents one measure, such as monthly sales, completion rate, or service response time.

A typical bullet chart has three parts:

  • Qualitative ranges: background bands that communicate levels such as below expectation, acceptable, and strong.
  • Actual value: a solid bar extending from zero to the current measurement.
  • Target: a narrow line or marker at the goal value.

For example, a sales measure might use a scale from 0 to 100, with ranges of 0–50, 50–80, and 80–100. If actual sales are 72 and the target is 85, the actual bar ends in the middle range and the target marker appears farther to the right. The chart gives context that a single number such as “72” cannot show on its own.

Prepare the data and choose the scale

Start by choosing a scale that makes sense for the measure. A percentage may use 0–100; a count might use 0–500. Use the same units for the actual value, target, and band limits. Decide whether a larger number is always better. For measures where lower is better, such as defect rate or time to resolve an issue, arrange the band meanings accordingly rather than implying that the rightmost range is automatically good.

For one illustrative measure, set up the range widths in a worksheet like this:

  • A1: Measure; B1: Low range; C1: Middle range; D1: High range; E1: Actual; F1: Target.
  • A2: Sales; B2: 50; C2: 30; D2: 20; E2: 72; F2: 85.

The three band values are widths, not cumulative endpoints: 50 + 30 + 20 = 100. Together they define the full scale. In this example the ranges are 0–50, 50–80, and 80–100. If the scale maximum changes, update the band widths and axis maximum together. Keeping them consistent prevents the background from ending before, or extending beyond, the intended scale.

Create the horizontal range chart

  1. Select the measure name and the three range-width cells, A1:D2 in the example.
  2. Choose Insert > Insert Column or Bar Chart > 2-D Stacked Bar. The stacked bar type places the three range segments end to end.
  3. If Excel puts the bands on separate rows or treats the columns unexpectedly, select the chart and choose Chart Design > Switch Row/Column. For one measure, the desired result is a single horizontal bar divided into three adjacent segments.
  4. Right-click the horizontal value axis and choose Format Axis. Set the minimum to 0 and the maximum to 100 for this example. Set the major unit to a useful interval, such as 20, if you want labeled tick marks.
  5. Give the three segments progressively stronger or more saturated colors, while keeping text and gridlines readable. Right-click a segment and use Format Data Point or select the series and use Format Data Series to set its fill.

Use Chart Design > Add Chart Element to add or remove a chart title, axis titles, and gridlines. A restrained design usually works best: the background bands should be lighter than the actual-value bar so the measurement remains visually prominent. If the category axis appears on the wrong side, right-click that axis, choose Format Axis, and adjust the category order setting as needed.

Add the actual bar and target marker

Excel’s stacked chart builds the background ranges, but simply adding the actual value as another stacked series would append it after the ranges rather than lay it over them. For a straightforward single-measure chart, draw the actual and target as shapes on top of the chart instead:

  1. Click the chart and identify the plot area: the interior region where the colored band and axis gridlines appear. Locate the left edge corresponding to zero and the right edge corresponding to 100.
  2. Choose Insert > Shapes > Rectangle. Draw a narrow rectangle over the middle of the band, starting at the zero position and ending at the actual value. For an actual of 72 on a 0–100 scale, it should cover about 72% of the plot-area width. Give it a dark, contrasting fill and no outline.
  3. Choose Insert > Shapes > Line and draw a thin vertical line at the target position. A target of 85 belongs about 85% of the way from zero to the scale maximum. Make the line tall enough to cross the band and actual bar so it remains easy to see.
  4. Add a small label or legend explaining the actual bar and target line if the chart will be viewed without surrounding notes.

These positions are proportional to the plot area, not the full chart object: titles, axis labels, and margins do not represent data values. For example, if the plot area is 400 pixels wide, a value of 72 on a 0–100 scale is about 288 pixels from its zero edge. Treat this as a placement guide, not a pixel-perfect formula, because resizing the chart changes the plot area. After adding shapes, check that they sit over the correct row and do not obscure axis labels.

Format it for clear comparisons

A bullet chart is meant to be read quickly, so avoid decorative effects that compete with the data. Use a strong color for the actual bar, a clearly visible target line, and muted background bands. A thin dark target marker is common, but a contrasting color can help viewers distinguish it from the bar. If the target falls inside the actual bar, ensure the marker remains visible by placing it above the bar or choosing a line color with sufficient contrast.

Keep the scale and labels explicit. Include units in the chart title or axis title—for example, “Sales, thousands of dollars” or “On-time completion, percent.” If the axis starts above zero, the bar’s apparent length can exaggerate differences; for a conventional bullet chart, a zero-based scale is usually easier to interpret. Remove the legend if the colored bands and marker are clearly labeled elsewhere, but do not remove information the reader needs to understand them.

Limitations and ways to keep it maintainable

The shape-overlay method has an important trade-off: Excel does not calculate the shape’s position from the actual or target cells. If the value changes from 72 to 76, the rectangle will still end at its old location until you move or resize it. If the axis maximum or chart dimensions change, both overlays may need adjustment. This approach is suitable for a one-off report or a small, stable dashboard, but becomes awkward for many measures or frequent updates.

To make manual updates less error-prone, keep the actual, target, band widths, and scale maximum visible in the worksheet beside the chart. Add data labels or a short note with the current values, and check the chart after changing any of them. For a dashboard with many rows, consider a solution that uses data-driven chart series or a specialist chart add-in, and verify that it supports your Excel version and workbook-sharing requirements. You can also use a cell-based visualization with conditional formatting when a full chart is unnecessary.

On Excel for Mac, the general idea is the same, though ribbon layout and some dialog details can differ from Windows. Excel for the web can display many existing charts but may have different editing capabilities for chart formatting and shapes. If the workbook must be edited across platforms, confirm that colleagues can reposition the overlays in the version they use.

Bullet charts compared with other Excel charts

A bullet chart is useful when one value needs to be judged against a target and meaningful ranges. A gauge can be more familiar to some audiences, but it uses more space and can make small differences harder to compare across several measures. A standard bar chart is often better when the main task is comparing many categories, especially if there is no target or performance band to communicate.

For a simple actual-versus-target comparison, a clustered bar chart with two bars can be easier to maintain because both values remain linked to worksheet cells. However, it does not show performance ranges as naturally. A bullet chart combines the context of a scale with a compact actual-versus-target display, but the manual overlay method sacrifices automatic updates. Choose based on what the reader needs and how often the underlying values will change.

Common problems to check

  • The ranges are stacked in the wrong order: check the order of the selected columns and use Chart Design > Select Data to review the series. The band widths should add to the axis maximum.
  • The bar does not fill the scale: confirm that the horizontal axis maximum matches the sum of the range widths. Excel’s automatic axis bounds may not match your intended scale.
  • The actual bar or target is misplaced: measure from the plot area’s zero point, not from the outer edge of the chart. Recheck overlays after resizing.
  • The target marker is hidden: use a contrasting line, make it slightly thicker, or place it in front of the actual bar.
  • The chart looks crowded: lighten the bands, remove unnecessary gridlines, and use a short title with units.

Frequently Asked Questions

Does Excel have a built-in bullet chart type?
No. Excel for Microsoft 365 does not include a dedicated Bullet Chart option in the standard chart gallery. A stacked bar plus overlays is a practical manual construction; other methods or add-ins may offer more automation.

Can the actual value and target update automatically?
Not when they are drawn as ordinary shapes. The range chart can be linked to worksheet data, but the shape positions do not follow cell changes. For frequently refreshed data, use a data-driven design or plan to reposition the overlays each time.

How do I make a bullet chart for several measures?
Create one stacked range row per measure and use consistent scale limits where comparisons are intended. The manual overlays must be placed separately on each row, which is time-consuming and easy to misalign. For a large dashboard, choose an automated charting method instead.

Should a bullet chart always start at zero?
A zero-based scale is usually the clearest choice because the actual bar’s length then represents its value directly. A different minimum can make changes look more dramatic, so use one only when there is a clear analytical reason and label the scale clearly.

Can I use a bullet chart when lower values are better?
Yes. Set the bands to reflect the measure’s meaning—for example, low defect rates can be in the favorable band—and label the ranges. The chart’s right side is simply a larger number; it does not inherently mean better performance.

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.