How to Create a Bullet Chart in Excel

Tired of trying to represent a single key performance indicator (KPI) with clunky pie charts or confusing bar graphs? The bullet chart is your answer for a clean, dense, and instantly understandable way to show progress against a goal. This tutorial walks you through exactly how to create a feature-rich bullet chart in Excel so you can visualize your performance at a glance.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

What is a Bullet Chart?

First, let's quickly cover what a bullet chart is and why it's so effective. Created by data visualization expert Stephen Few, a bullet chart is a variation of a bar chart designed to replace dashboard gauges and meters. It packs a lot of information into a small space, making it perfect for dashboards and executive summaries.

Think of it like a souped-up thermometer for your business metrics. A bullet chart has three main components:

• The Feature Measure: This is the main bar that shows the actual value of the metric you are tracking (e.g., $180,000 in sales).
• The Target Marker: This is a line that represents your goal (e.g., a sales target of $200,000).
• Qualitative Ranges: These are color-coded segments in the background that show performance bands (e.g., poor, satisfactory, and good performance).

By comparing the feature measure to the target marker against the backdrop of the performance ranges, you can immediately tell not just what the number is, but how good that number is. You can quickly answer questions like, "How are our sales doing against the quarterly goal?" or "Is our website traffic in the good, average, or poor range for the month?"

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Step 1: Prepare Your Data in Excel

Before you can build the chart, you need to structure your data correctly. A bullet chart in Excel is essentially a clever combination of several chart types layered on top of each other. The setup is critical.

Arrange your data in a single row with columns for your metric name, the actual value (what you achieved), the target value (your goal), and the values for your performance bands. For this example, let's track "Monthly Revenue." Our goal is $250k, and we actually achieved $220k.

We'll define three performance bands:

• Poor: 0 - $150k
• Average: $150k - $225k
• Good: $225k - $300k

Here's how you need to structure your table. Notice that the performance band columns (Poor, Avg, Good) are not the actual thresholds but the size of each segment. This is the most important part of the setup.

Let's create the data like this:

How did we get the values for Poor, Average, and Good?

• Poor: The value of the first segment is simply its max value, so 150,000.
• Average: This is the size of the middle segment. We calculate it by subtracting the previous segment's max: 225,000 (Avg max) - 150,000 (Poor max) = 75,000.
• Good: Same logic here. 300,000 (Good max) - 225,000 (Avg max) = 75,000.

This structure is necessary because we're going to build a stacked bar chart where each color block has to be defined by its specific size, not a cumulative number.

Step 2: Create the Basic Stacked Bar Chart

Now for the fun part. Let's start building the chart itself.

1. Select only the data for your performance bands (the values for Poor, Average, and Good) and the metric label. In our case, select cells A1 through F2, but hold CTRL and deselect the "Actual" and "Target" columns so only "Metric", "Poor", "Average", and "Good" are selected.
2. Go to the Insert tab on the Ribbon.
3. In the Charts group, click Insert Column or Bar Chart.
4. Select the Stacked Bar chart (not the Stacked Column chart).

You should now have a basic chart that looks like colorful blocks stacked next to each other. Don't worry - it won't look like this for long.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Switch Rows and Columns

Often, Excel will try to stack the bars by metric instead of by performance band. We need to fix that.

• With the chart selected, go to the Chart Design tab on the Ribbon.
• Click the Switch Row/Column button.

Now you should have a single bar with three colored segments. This is the foundation of our bullet chart performance bands.

Step 3: Add the 'Actual' and 'Target' Data to the Chart

Next, we need to layer our actual performance bar and target marker on top of these background bands.

1. Right-click anywhere inside the chart area and choose Select Data.
2. In the Select Data Source dialog box, click the Add button under "Legend Entries (Series)."
3. A small "Edit Series" dialog box will pop up.
4. Click OK. You'll see an "Actual" bar added to your chart.
5. Repeat the process for the Target value. Click Add again.
6. Click OK twice to close the dialog boxes.

Your chart now has five segments, which still look wrong. The next step is where a little bit of Excel magic comes in.

Step 4: Create the Data Layers with a Combo Chart

To overlay our bars and markers, we need to put some of our data on a "secondary axis." This lets us format them independently.

1. Right-click on the chart and choose Change Chart Type.
2. At the bottom of the dialog box, select the Combo chart type.
3. You'll now see a list of all your data series (Poor, Average, Good, Actual, Target). This is where we define our layers.
4. Click OK.

Your chart will look like a bit of a mess, with bars on top of other bars. This is normal. We're about to fix it.

Format the Secondary Axis for Layering

Now we'll format the new secondary bars to create the bullet chart effect.

1. Format the 'Actual' Bar

• Click on the Actual data bar on your chart to select it (it will be the very front bar segment).
• Right-click on it and select Format Data Series.
• In the Format Data Series pane that appears on the right, under "Series Options," change the Series Overlap to 100%.
• Next, adjust the Gap Width. This slider controls how thick the bar is. A good starting point is around 350% or 400%. You'll see your "Actual" bar become much thinner, creating the classic bullet chart look.
• In the same pane, go to the Fill & Line tab (the paint bucket icon). Choose a strong, dark color for your bar, like black or dark blue. Also, select "No line" for the border.

2. Format the 'Target' Marker

• Now, click on the orange "Target" bar that's sitting next to your "Actual" bar.
• Right-click and select Format Data Series.
• Under "Series Options," set the Gap Width to a much higher number, like 550% or 600%. This will make the target marker even more narrow than the actual bar.
• Go to the Fill & Line tab and change its color. A contrasting color like red or dark orange works well. You've now made the "line marker," which is really just a very thin bar.

Step 5: Final Formatting and Cleanup

Your bullet chart is functionally complete, but now we'll clean it up to make it look professional.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Refine the Performance Bands

The default blue, orange, and gray colors aren't ideal for a smooth performance scale.

• Click on the first segment of the background bar (the "Poor" segment).
• In the Format Data Series pane, choose the Fill you want. A common practice is to use progressive shades of a single color, like light gray for poor, medium gray for average, and dark gray for good. This puts the focus on your actual value and target.
• Repeat this for the other two segments ("Average" and "Good").

Clean Up Chart Elements

• Remove the Secondary Axis: You have a second axis at the top of your chart that we don't need to see. Click on it to select it, then press the Delete key.
• Remove the Legend: The chart is self-explanatory and doesn't need a legend. Click on the legend and press Delete.
• Add a Chart Title & Axis Labels: Give your chart a clear title, like "Monthly Revenue Performance." Ensure your bottom axis has the right labels (e.g., "Revenue ($)").
• Synchronize Axes: Make sure the primary (bottom) axis and the now-hidden secondary axis have the same maximum value so your data is scaled properly. Double-click the bottom axis > Axis Options. Note the maximum value. Then undo the deletion of the secondary axis, adjust its maximum value to match, and then hide it again by setting its labels, tick marks, and line to "No Line / No Fill." This guarantees your actual and target values are correctly plotted against the performance background.

After these tweaks, you should have a clean, readable, and informative bullet chart that instantly shows how your performance stacks up!

Final Thoughts

Building a bullet chart in Excel from scratch is a fantastic skill that powerfully upgrades your reporting. It teaches you how to layer and manipulate Excel charts to create professional-grade visuals that communicate performance against a goal far more effectively than a simple gauge or bar chart.

While mastering chart-building in Excel is rewarding, the process can be slow and manual, especially when you need to pull data from different platforms like Google Analytics, Shopify, or your CRM. At some point, you might find yourself spending more time downloading CSVs and wrestling with chart formatting than actually analyzing performance. We built Graphed to remove this friction by connecting all your data sources and letting you build live dashboards with simple, natural language. You can just ask, "Create a bullet chart showing Shopify revenue vs target for this month," and get a real-time visualization in seconds, freeing you up to focus on the insights, not the setup.