Excel has no built-in chart type called a vertical or circular bullet chart. To make one, use stacked columns or bars for qualitative ranges, then add the actual value and target as foreground markers; for a circular version, use a doughnut chart for the ranges and add marker lines. These are custom chart designs, so the best method depends on whether you need a simple visual or a chart that updates automatically.
What a bullet chart shows
A bullet chart compares a measured value with a target and gives the result context. Shaded ranges might mark poor, acceptable, and strong performance, while a bar or marker shows the actual result and a line marks the target. For example, a monthly service score of 72 against a target of 75 is easier to interpret if the chart also shows that scores below 50 are weak and scores above 80 are strong.
Bullet charts are often used as compact alternatives to gauges. They can show several measures in a small space, and their scales make comparisons easier than comparing separate dials. A traditional bullet chart is horizontal: the qualitative ranges form a background bar, the actual value appears in front, and the target is a short line. Vertical and circular versions are adaptations, not standard Excel chart types.
Prepare the data and choose a scale
Set a clear minimum and maximum before building the chart. If the measure is a percentage, a 0-to-100 scale is often appropriate; for a score out of 10, use 0 to 10. All the range segments must add up to the full scale. With thresholds of 50, 80, and 100, the three background segments are 50, 30, and 20—not 50, 80, and 100. Using threshold values as segment sizes would make the chart extend beyond its intended maximum.
For example, put the thresholds 50, 80, and 100 in B2:B4. With those thresholds in B2:B4 and the first band width in C2, enter =B2 in C2; it returns 50. With the next threshold in B3 and the previous threshold in B2, enter =B3-B2 in C3; it returns 30. Fill C3 down one row to calculate the last band, which returns 20. If the actual score is in D2 and the maximum is in B4, enter =D2/$B$4 in E2; for a score of 72, it returns 0.72, or 72% when formatted as a percentage.
Keep the scale consistent across charts that readers will compare. If one chart starts at zero and another starts at 40, the same bar length can imply different performance. Label the units and state what the shaded ranges mean; color alone may not be enough, especially for readers with color-vision deficiencies.
Build a vertical bullet chart with columns
A vertical layout puts the scale on the vertical axis, much like a thermometer. One useful Excel construction is a stacked column for the qualitative bands, with the actual value and target layered over it. In Microsoft 365 for Windows, arrange one category per column and put the band widths in separate series. Select the category and band data, then choose Insert > Insert Column or Bar Chart > 2-D Stacked Column.
- Add the actual-value series to the chart through Chart Design > Select Data > Add. Use the actual value for each category.
- Use Chart Design > Change Chart Type to make the actual series a clustered column while leaving the band series stacked. If necessary, put the actual series on a secondary axis and set both vertical axes to the same minimum and maximum.
- Format the actual column so it is narrow and visually distinct from the background bands. Adjust series overlap and gap width in Format Data Series until the foreground value aligns with its background category.
- Add the target as a marker or short line at the target value. A line or XY scatter series can be used, but its axis alignment must match the category positions and value scale. Hide secondary axes after confirming they align.
Combo-chart layouts can be fiddly because Excel treats stacked and clustered column groups differently. Check that the actual column is centered over its range column and that the target marker is at the right height. For a single vertical indicator, a simple column chart with colored plot-area bands and an actual-value marker may be easier to maintain. If the chart is for a report that changes often, test it with low, middle, and maximum values before relying on it.
Make a circular version with a doughnut chart
A circular bullet chart usually means a radial adaptation: a ring represents the scale, colored sections show performance bands, and a pointer indicates the actual value. Excel can draw the ring with a doughnut chart, but it does not provide a native radial bullet chart with a built-in target tick. A doughnut ring plus marker lines is therefore a practical visual approximation rather than an automatic chart type.
To make the background, enter the band widths as values that sum to the full scale, select them, and choose Insert > Insert Pie or Doughnut Chart > Doughnut. Format each segment to show the qualitative bands, remove the legend if it adds clutter, and adjust the doughnut hole size in the chart formatting options. Add a center label for the actual score if that helps readers interpret the display.
For a static graphic, add a line shape from the center of the ring toward the actual position and a short tick at the target position. Use Insert > Shapes and place the shapes over the chart. This is quick, but the lines will not automatically move when the score or target changes. Reposition them after updating the data. A dynamic pointer requires a more involved construction, such as a carefully aligned overlay chart; it should be tested whenever the chart size, axis settings, or data changes. Do not imply that a static pointer updates just because the doughnut’s bands do.
Decide whether the scale should use the entire circle or only an arc. A full ring is visually balanced but can make the reading direction less obvious. A half-doughnut gauge leaves an unused segment to create an open arc, but requires an additional hidden segment and careful formatting. In either design, clearly identify the start and end of the scale and avoid making the marker difficult to distinguish from the band boundaries.
Choose the right orientation
Use a vertical chart when the chart must fit alongside other vertical columns, when the metric naturally reads as a level, or when space is narrow. A vertical chart can compare multiple categories, provided each has the same scale and the target markers remain readable. Labels may need to be shortened or rotated if there are many categories.
Choose a circular version when the design specifically calls for a gauge-like display and there are only a few key measures. A circular chart often takes more space per metric and makes precise comparisons harder than a linear scale. If readers need to compare many teams, products, or months, a horizontal bullet chart or a regular bar chart is usually clearer. The circle is a design choice, not a more accurate way to display the data.
Formatting and accessibility
Use restrained colors for the background ranges and a high-contrast color for the actual value and target. Keep the actual marker visually prominent without letting it obscure the range boundaries. Add a chart title or text label that explains the metric, units, and target. If a chart contains multiple measures, include readable category labels and avoid relying on a legend that forces readers to guess which marker means actual versus target.
Consider adding a data label for the actual value and a text label for the target. For instance, “72 of 100; target 75” communicates the comparison even if someone cannot distinguish the colors. Use Excel’s chart alt text options when the chart will be shared digitally, and provide the key takeaway in nearby text where the chart is part of a report.
Common problems and fixes
- The bands do not end at the maximum: check that each segment is a difference between consecutive thresholds and that all widths sum to the scale maximum.
- The actual value looks like another background band: change its fill, reduce its width, or use a contrasting marker. Make sure it is plotted in front of the background.
- The target is misplaced: confirm that it uses the same value scale as the actual measure. If a secondary axis is involved, match its minimum and maximum to the primary axis.
- The circular pointer stays put after a data change: it is probably a manually placed shape. Move it yourself or rebuild the chart with a dynamic overlay; ordinary doughnut segments do not reposition a shape.
- Readers cannot tell which way the scale runs: label the minimum and maximum and explain the threshold bands directly.
How bullet charts compare with gauges and bars
A bullet chart is strongest when the purpose is to compare actual performance with a target and meaningful ranges. A standard bar chart is often preferable when comparing several categories without target bands. A doughnut chart is useful for showing parts of a whole, but it is not automatically a good gauge: angles and arcs are harder to compare precisely than positions on a straight scale. If exact values matter, show labels or choose a linear chart.
Excel’s ordinary chart features can support these designs, but there is no one-click “bullet chart” command in the standard chart gallery. A prebuilt template or add-in may offer a simpler setup, but check how it handles changing data, accessibility, and workbook sharing before using it in a report. For a chart that must be robust and easy to maintain, a horizontal bullet chart built from bars and a target marker is often the simplest starting point.
Frequently Asked Questions
Does Excel have a built-in bullet chart?
No. Excel for Microsoft 365 does not list a native bullet chart type. You can create one from stacked bars or columns and add actual-value and target markers, or use a suitable template or add-in.
How do I make a vertical bullet chart in Excel?
Create a stacked column chart from the range widths, add the actual series as a foreground column or marker, and add a target line or marker. Make sure any secondary axis uses the same scale and aligns with the categories.
Can I create a circular bullet chart in Excel?
You can make a gauge-like approximation with a doughnut chart for the background bands and line shapes for the actual and target markers. Manually placed shapes will not update automatically when the values change.
Should my range values be cumulative thresholds?
No. For thresholds of 50, 80, and 100, use segment widths of 50, 30, and 20. The widths add to 100, while the thresholds describe the boundaries between bands.
Is a circular bullet chart better than a horizontal one?
Not for precise comparisons. A circular display can suit a compact dashboard or a gauge-like design, but a horizontal bullet chart makes it easier to compare values and targets across several measures.
Related
- To-Do List Template in Excel: Create and Use Yours
- To Do List Excel Sheet Template: Make a Useful Tracker
- To-Do List Excel Spreadsheet: Setup, Columns and Tips
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- How to Edit an Org Chart in Excel: Steps and FixesTo edit an org chart in Excel, click a box and change its text, or select the chart…
- Excel Charts Won’t Resize? How to Fix ThemIf an Excel chart will not resize or keeps changing size when worksheet cells change, select the chart…
- Add Error Bars to an Excel Chart: A Practical GuideTo add error bars in Excel for Microsoft 365 on Windows, select the chart, then choose Chart Design…
- How to Make an XY Graph in Google SheetsTo make an XY graph in Google Sheets, put your X values in one column and your matching…
- Gantt Chart in Excel: How to Insert One Step by StepTo insert a Gantt chart in Excel, arrange each task with a start date and duration, then insert…
- Org Chart Template for Google SheetsTo make an org chart in Google Sheets, put each person or position in column A and that…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.