Click on Target Value bar (the orange color bar at the top).This will give you one column with all the data points (the first four colors are the qualitative bands, the fifth one is actual value and the top most is target value). To combine these into one, select the chart and go to Design –> Data –> Switch Row/Column. In the above step, you will get a chart where all the data points have been plotted as separate columns.Select the entire data set (A1:B7), go to Insert –> Charts –> 2D Column –> Stacked Column.Arrange the data so that you have the band values (poor, fair, good, and excellent) together, along with the actual value and the target value.Here are the steps to creating a Bullet Chart in Excel: Now, let me show you how to create a bullet chart in Excel. In the above example, the black bar indicates that the performance is good (based on its position in the qualitative bands), but it doesn’t meet the target. Actual Performance Marker: This bar shows the actual performance.For example, here in the above case, 90% is the target value. Target Performance Marker: This shows the target value.For example, 0-60% is Poor performance (shown as a dark blue band), 60-75% is Fair, 75-90% is Good and 90-100% is Excellent.

Qualitative Bands: These bands help in identifying the performance level.

This single bar chart is power-packed with analysis: Here is an example of a Bullet Chart in Excel:

One of the best things about bullet charts is that it is power-packed with information and takes little space in your report or dashboards. And here is where Bullet Charts score over others.īullet charts were designed by the dashboard expert Stephen Few, and since then it has been widely accepted as one of the best charting representations where you need to show performance against a target. Hence, it is important to make smart choices while creating the right chart. One of the challenges while creating a dashboard is to present the analysis in limited screen space (preferably a single screen). Watch Video – Creating a Bullet Chart in Excel

Download bullet points for word