How to Create a Horizontal Bullet Chart in Excel

Create a horizontal bullet chart in Excel by charting performance bands as a stacked bar, then placing a dark actual-value bar and a target marker over each band. Excel does not provide a dedicated bullet-chart command, so this practical method combines a regular chart with shapes. It works in Excel for Microsoft 365 on Windows and is useful for comparing actual results with targets against a shared scale.

The chart below uses three shaded ranges—below expectation, approaching target, and on track—with an actual bar and a target line. The band chart is data-driven; the overlaid bars and markers are shapes, so you will position or adjust those when values change. For a small dashboard, this gives you a clear bullet-chart appearance without a specialist add-in.

What You’ll Need

Excel for Microsoft 365 on Windows and a worksheet with one row per measure.
A maximum scale, such as 100, plus two thresholds that divide the background into three performance bands.
An actual value and a target value for each measure, all expressed on the same scale.
About 10 minutes to make the chart and position the overlaid shapes. Save a copy first if you are working in an important workbook.

Step-by-Step

Choose the scale and thresholds. Decide the scale before entering data. For example, if scores run from 0 to 100, a first threshold of 50 and a second threshold of 80 create bands of 0–50, 50–80, and 80–100. These are illustrative thresholds, not universal definitions of performance. Pick ranges that make sense for the measure and keep them consistent across metrics you want to compare.
Prepare the band data. In a blank area of the worksheet, create columns for Measure, Below, Middle, and Upper. Enter one row per measure. For the example scale, enter 50 in Below, 30 in Middle, and 20 in Upper for every row. These are segment widths, not the threshold endpoints: 50 + 30 + 20 equals the full scale of 100. Add Actual and Target columns as well, but do not include those columns in the first chart.
Insert the stacked bar chart. Select the Measure and three band columns, including their headers. Choose Insert > Insert Column or Bar Chart > 2-D Bar > Stacked Bar. Do not choose 100% Stacked Bar; that chart normalizes each row and can conceal differences if band widths are not identical. Excel should show one horizontal bar for each measure, divided into the three band segments.
Check the series and category order. If the measures appear as separate colored series instead of as category labels, select the chart and choose Chart Design > Switch Row/Column. The measure names should appear along the vertical axis, and Below, Middle, and Upper should be the stacked segments. If the bands are in an unhelpful order, use Chart Design > Select Data, select a series, and use the move-up or move-down controls to put Below first, Middle second, and Upper last.
Set the value axis to the full scale. Right-click the horizontal value axis and choose Format Axis. Under Axis Options, set the Minimum to 0 and the Maximum to 100 for this example. Use your chosen maximum if your scale differs. Set the Major unit to a useful interval, such as 20, if you want readable tick marks. A fixed maximum is important: if Excel chooses a different axis limit, the shaded ranges will no longer represent the intended scale.
Format the three background bands. Select each series by clicking a segment in the chart, then open Format Data Series and choose a fill color. Use a restrained, progressively stronger palette—for example, pale gray for Below, light blue for Middle, and muted green for Upper. Give all segments no outline or a subtle outline. Keep the fills light enough that a dark actual bar will stand out when placed on top.
Make the band chart easier to read. Right-click a bar and choose Format Data Series. Adjust Gap Width to make the category rows thick enough to accommodate an actual bar and target line; a smaller gap makes thicker rows. Remove the legend if the band names are already explained in a nearby note, or keep it and rename the series with clear labels. Add a chart title and keep the horizontal axis visible so readers can estimate values. Avoid 3-D effects, which distort the scale.
Size the chart and identify the plot area. Drag the chart corners to create a wide, shallow chart. Leave room for the measure labels and value-axis labels. Click inside the chart until the plot area—the rectangle containing the colored bands and gridlines—is selected. Shapes must sit inside this plotting rectangle, not over the labels or chart title. Turn on light vertical gridlines if they help readers compare the actual bar and target with the scale.
Overlay an actual-value bar for each measure. Click the chart once so it is selected, then choose Insert > Shapes > Rectangle. Draw a narrow rectangle inside the first measure’s band, starting exactly at the left edge of the plot area and ending at the position for that measure’s actual value. On a 0–100 scale, a value of 65 should end about 65 percent of the way across the plot area. Make the rectangle much thinner than the category row, center it vertically in that row, and use a dark solid fill with no outline. Repeat for each measure. Use the chart’s vertical gridlines to help align the end points.
Add a target marker to each row. Select the chart, choose Insert > Shapes, and draw a narrow vertical line through the row at the target’s position. For a target of 80 on a 0–100 scale, place it four-fifths of the way from the plot area’s left edge to its right edge. Format the line in a contrasting dark color and increase its weight enough to remain visible against the band fills. Keep it within that measure’s row so readers can match it to the correct actual bar.
Check alignment and finish the chart. Compare every rectangle and marker with the axis labels and gridlines. Confirm that each actual bar starts at zero, that each target line corresponds to the right measure, and that no shape covers an axis label. Add a small key or text note identifying the dark bar as Actual and the vertical line as Target. If you move or resize the chart, check and reposition the shapes afterward; they are visual overlays rather than values plotted from the data.

Common Mistakes

Using the threshold values as segment widths. If the thresholds are 50 and 80, the three widths are 50, 30, and 20—not 50, 80, and 100. Adding the thresholds as widths makes the chart longer than the selected scale. Check that the band widths add up to the axis maximum.
Choosing a 100% stacked chart. This chart type can make every category fill the same total width even when the values or ranges should not. Use Stacked Bar and explicitly set the horizontal axis minimum and maximum.
Drawing shapes against the whole chart instead of the plot area. The chart title, category labels, and axis labels take up space outside the plotting region. Measure positions from the left and right edges of the colored bands, not from the outer chart border.
Making the actual bar too thick or the marker too faint. A thick actual bar can hide the background bands, while a light target line disappears against them. Keep the actual bar narrow and use a high-contrast target line that is still visually distinct from the bar.
Assuming the overlays update automatically. The band chart changes when its source cells change, but shapes do not recalculate their positions when Actual or Target cells change. Update the overlays when values change, or consider a more advanced chart construction if the dashboard needs frequent automatic updates.

Tips

Use one common scale for measures that readers need to compare. If one row is scored out of 100 and another is measured in thousands, either convert them to comparable units or use separate charts with clearly labeled scales.
Use meaningful labels for the qualitative ranges, such as Below minimum, Near goal, and Meets goal. If the ranges differ by metric, explain that in the chart or use separate charts rather than implying the colors have identical meanings.
Keep the actual bar and target line consistent across all rows. A dark bar and a thin contrasting line are easier to scan than several competing colors or marker styles.
For repeat use, keep the source table and chart together on a dashboard sheet, and avoid moving the chart after carefully aligning its shapes. If you need to resize it, resize first and then check the overlays.
On Mac, the chart and shape tools are available in Excel, but ribbon placement and some formatting panes can differ from Windows. Look under Insert for the chart and shape commands, and use the Format pane for axis and series settings. Excel for the web has more limited chart and shape editing; use the desktop app for precise overlays.

Troubleshooting

The bars run vertically. The wrong chart family was selected. Select the chart, then choose Chart Design > Change Chart Type > Bar > Stacked Bar.

The bands do not fill the chart width. Right-click the horizontal axis and choose Format Axis. Check that the minimum is 0 and the maximum matches the sum of the three band widths. Also check that you used Stacked Bar rather than 100% Stacked Bar.

The measure names or bands are reversed. Use Chart Design > Switch Row/Column if Excel interpreted the table in the wrong direction. To change the top-to-bottom category order, right-click the vertical category axis, choose Format Axis, and adjust Categories in reverse order if needed. If that moves the horizontal axis to the top, adjust the horizontal axis crossing option in the same pane.

A shape is behind the chart or cannot be selected. Click the chart first before inserting a shape so it is placed over the chart, then use the Selection Pane if objects overlap. You can open it from Home > Find & Select > Selection Pane. Select the intended shape from the list and use Bring Forward or Send Backward as needed.

Markers shift after editing the chart. Resizing the chart, changing the plot-area width, adding labels, or changing axis bounds affects the position mapping. Restore the final chart size and axis settings first, then reposition the shapes against the plot area. For regularly changing data, this manual overlay method may be too fragile; use a purpose-built Excel template or a chart approach that plots the target and actual as data series.

Frequently Asked Questions

What is a horizontal bullet chart used for?
A bullet chart compares a measure with a target and places both against qualitative ranges. It is a compact alternative to a gauge and works well in scorecards and dashboards.

Can I make a bullet chart without shapes?
Yes, but it takes a more advanced chart setup, such as combining bar and marker series with carefully aligned axes. For a straightforward chart in standard Excel, shapes are easier to position, but they are not linked to the actual and target cells.

Will the chart update when I change the values?
The shaded band chart updates when its source data changes. The overlaid actual bars and target lines do not move automatically, so reposition them after a value or scale change.

Can I show several measures in one bullet chart?
Yes. Put each measure on its own row, use the same band widths and scale for comparable measures, and place one actual bar and one target marker in each row.

How do I show a value greater than the maximum?
Do not let it silently run off the chart. Increase the common maximum and recalculate the band widths, or clearly flag the value as exceeding the scale. Then reposition the actual bar and target markers to match the revised axis.

Can I use this chart in Excel for the web?
You can view charts there, but precise placement and formatting of chart overlays can be limited. Create or refine the chart in the desktop version of Excel for more reliable control.

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.