Create a Bullet Chart in Excel: Step-by-Step Guide

Charts & pivot tables · Updated November 19, 2026

To create a bullet chart in Excel for Microsoft 365 on Windows, make a stacked bar chart for the performance ranges, place a second bar chart containing the actual value over it, and add a target marker. The two-chart method is more hands-on than inserting a standard chart, but it produces the familiar bullet-chart design and works without add-ins or VBA.

What a bullet chart shows

A bullet chart is a compact way to compare one measured value with a goal and a set of qualitative ranges. It is often used in dashboards because several measures can be displayed in a small space without the visual clutter of a gauge. A typical bullet has three parts: shaded background bands for performance levels, a solid bar showing the actual result, and a thin marker showing the target.

For example, a team might report that it completed 72 items against a target of 80, with 0–50 classified as below expectation, 50–80 as meeting expectations, and 80–100 as strong. The colored bands supply context; the dark bar shows 72; and the target line at 80 makes the shortfall visible. The chart is not a built-in chart type in Excel, so you assemble it from ordinary charts and, in the method below, a shape.

Plan the data and scale

Start by deciding what the measure represents and what the scale should be. Use a consistent scale for every bullet in a dashboard. If the maximum is 100, the band widths must add up to 100. They are widths, not cumulative end points: a 0–50 band is entered as 50, a 50–80 band as 30, and an 80–100 band as 20.

Set up a small table like this for one measure:

  • Category: Customer satisfaction
  • Below expectation: 50
  • Meets expectation: 30
  • Strong: 20
  • Actual: 72
  • Target: 80
  • Scale maximum: 100

The ranges should describe useful thresholds for the metric, not arbitrary colors. If a higher value is worse—for example, response time—reverse the interpretation and choose bands that make low values favorable. The visual should communicate the meaning of the measure, not imply that every increase is good.

Create the background range chart

First create the colored bands that form the background. Put the category in one column and the three band widths in adjacent columns, with headers. For example, a row could contain Customer satisfaction, 50, 30, and 20. Select the category and range values, then choose Insert > Insert Column or Bar Chart > 2-D Bar > Stacked Bar. Use the stacked option, not 100% Stacked Bar: the latter rescales each row to 100 percent, which can disguise a scale that is meant to end at a different maximum.

  1. Click the chart and use Chart Design > Switch Row/Column if the bands appear as categories instead of segments in one horizontal bar.
  2. Right-click the horizontal value axis and choose Format Axis. Under Axis Options, set the minimum to 0 and the maximum to the scale maximum, such as 100.
  3. Right-click a colored segment and choose Format Data Series. Set Gap Width to 0% or a small value so the range bands read as one continuous track.
  4. Choose distinct, restrained fills for the ranges. A light neutral palette keeps the actual-value bar legible when it is placed on top.
  5. Remove the legend if the ranges are self-explanatory, or keep it if readers need the names of the bands.

If the chart shows categories in an unexpected order, format the vertical category axis and select Categories in reverse order. Excel may move the value axis to the top when you reverse categories; adjust the axis crossing option if that makes the chart harder to read.

Add an actual-value bar with a second chart

Excel does not provide a one-click bullet chart type. A practical way to put a solid actual bar in front of the stacked background is to create a second chart containing the category and actual value, then layer it over the first. For the example, the second chart uses Customer satisfaction and 72. Keep the actual value as a number, not as a percentage-formatted text string.

  1. Select the category and actual-value cells, then choose Insert > Insert Column or Bar Chart > 2-D Bar > Clustered Bar.
  2. In the new chart, format the horizontal value axis with the same minimum and maximum as the background chart: 0 and 100 in this example. This is essential; different scales make the bar appear to report a different value.
  3. Format the actual series with a dark, solid fill. Remove the chart title, legend, gridlines, and axis labels that are not needed.
  4. Right-click the chart area and choose Format Chart Area. Set Fill to No fill and Border to No line. Also format the plot area with no fill and no line so the background bands remain visible through the empty areas of the overlay chart.
  5. Resize and drag the actual chart over the background chart. Align the plot areas—not just the outer chart borders—and make the category positions line up. The actual bar should start at zero and sit centered on the colored track.

Chart objects can be difficult to align precisely because their plot areas have margins for axes and labels. Hide the duplicate category and value axes on the foreground chart, but keep its plot-area size and position consistent with the background chart. If hiding an axis changes the plot-area dimensions, adjust the plot area manually. Zooming in can help with placement; check the result at normal worksheet zoom before considering it finished.

Show the target and finish the design

For a simple single-row chart, a vertical line shape is an easy target marker. Choose Insert > Shapes > Line, hold Shift while drawing to keep the line vertical, and place it at the target position across the bar. Format the line in a contrasting color and make it thin enough not to hide the ranges. In the 0–100 example, the marker belongs at 80 percent of the plot area’s width measured from its zero end. Do not measure from the chart object’s outside edge, because the plot area begins inside it.

A shape is a visual marker, not a data-linked chart element. If the target changes or the chart is resized, reposition the line. For a dashboard that changes frequently, maintain a documented scale and check the marker whenever data or formatting changes. You can also label the target in a nearby cell or chart text box, such as Target: 80, so the exact value is available even when the line is narrow.

Give the chart a concise label and make sure the actual value can be read without relying on color alone. A data label on the foreground bar can show 72, for example. Add one by selecting the actual series and choosing Chart Design > Add Chart Element > Data Labels. If the label is obscured or appears in an unhelpful position, change its position in the Format Data Labels pane or place the number in a nearby worksheet cell.

Make the chart useful in a dashboard

A bullet chart is most effective when readers can compare like with like. Use the same scale, band definitions, bar thickness, and target-marker style across related measures. If one chart has a maximum of 100 and another has a maximum of 1,000, equal-looking bars do not represent equal performance. State units clearly—such as percent, dollars, or days—especially when a chart is separated from its source table.

  • Use muted background fills and a high-contrast actual bar so the data remains the focus.
  • Keep band labels in a legend or nearby note when color meanings are not obvious.
  • Use descriptive category names and avoid tiny text if several bullets share a dashboard.
  • Check contrast and readability in grayscale or for readers who may not distinguish particular colors.
  • Explain whether the target is a minimum, maximum, or exact goal when that distinction affects interpretation.

For multiple measures, build a row of range bands for each category and use one foreground chart with corresponding actual values, taking care to match the categories and axis limits. A multi-row overlay is more demanding to align than the one-row example. If reliable alignment and frequent updates matter more than a compact design, consider a simpler chart or a dedicated reporting tool instead of maintaining many stacked chart objects.

Common problems and how to fix them

The bands do not reach the end of the scale: Check that the range widths add up to the axis maximum. In the example, 50 + 30 + 20 equals 100. Also confirm that the background chart is a regular stacked bar chart and that its axis maximum is 100.

The actual bar is too long or too short: The foreground chart probably has a different axis range, or its series is being plotted as a percentage of the row. Set both charts to the same numeric minimum and maximum and use Clustered Bar for the actual chart.

The colored bands disappear behind a white rectangle: Set both the chart area and plot area of the foreground chart to No fill. Removing only the chart-area fill may leave an opaque plot area over the background.

The target marker shifts away from the correct value: A manually drawn shape does not recalculate its position when the plot area or axis changes. Reposition it after changing the scale, chart size, or axis bounds, and verify its location against the value axis.

The bar and background do not line up: Compare plot-area boundaries and category centers, not chart edges. Axis labels, titles, and margins can make two charts with identical outer dimensions have different plotting regions. Remove unnecessary elements and realign the plot areas.

Bullet charts compared with alternatives

A bullet chart is a good fit when the key question is how an actual value compares with a target and meaningful thresholds. A clustered bar chart is often easier when the priority is comparing several categories side by side. A line chart is better for showing change over time, while a gauge may be familiar to some audiences but typically uses more dashboard space and can make precise comparisons harder.

There is no need to use a gauge just because the measure is a percentage. Choose the chart that answers the reader’s question with the least visual effort. If the audience needs to see trends, include dates and use a line chart; if it needs to see status against a goal at a glance, a bullet chart can be more compact. For a frequently refreshed report, weigh the benefit of the bullet design against the work involved in keeping multiple chart objects aligned.

Frequently Asked Questions

Does Excel have a built-in bullet chart?
No. Excel for Microsoft 365 does not offer a standard chart type named Bullet Chart. You can create the appearance with stacked bar charts, shapes, and formatting, or use an add-in or another visualization tool.

Can I make a bullet chart without a second chart?
You can make a simpler approximation with a stacked bar for the ranges and a manually placed shape for the actual value and target. Those shapes will not automatically follow changing values. The two-chart method makes the actual bar data-driven, although the target shape still needs attention if the scale or layout changes.

Why do the range values need to add up to the maximum?
Each segment is a width on the same numeric scale. If the maximum is 100, widths of 50, 30, and 20 fill the track exactly. If they total 90, the background ends at 90 unless the scale or the range data is adjusted.

Can I use this method for negative values?
The basic example assumes a scale that starts at zero and increases in one direction. Measures that can be negative or have a meaningful midpoint need a different axis design and carefully placed ranges; a standard zero-based bullet layout may misrepresent them.

Will the chart update when I change the actual value?
The foreground bar updates if its source cell changes, provided the chart uses that cell as its data. The target line drawn as a shape does not update automatically. Recheck the marker after changing the target, scale, or chart dimensions.

Do the steps differ on Mac or Excel for the web?
The chart types and formatting concepts are similar in current Excel for Mac, though ribbon labels and pane layouts can vary by release. Excel for the web supports many chart edits, but detailed chart formatting and precise overlay alignment can be more limited than in the Windows desktop app. For careful positioning, use desktop Excel.

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.