Microsoft Office Tutorials and References
In Depth Information
Using a Thermometer-Style Chart
bullet graph, as seen in Figure 10-6, contains a single performance measure (such as YTD [year-to-
date] revenue); compares that measure to a target; and displays it in the context of qualitative
ranges, such as Poor, Fair, Good, and Very Good.
Figure 10-6: Bullet graphs display multiple perspectives in an incredibly compact space.
Figure 10-7 breaks down the three main parts of a bullet graph. The performance bar represents the
performance measure. The target marker represents the comparative measure. And the background
fills represent the qualitative range.
Figure 10-7: The parts of a bullet graph.
Creating a bullet graph
Creating a bullet graph in Excel involves quite a few steps, but it isn’t necessarily difficult. Follow
these steps to create your first bullet graph:
1. Start with a data table that gives you all the data points you need to create the three main
parts of the bullet graph.
Figure 10-8 illustrates what that data table looks like. The first four values in the data set
(Poor, Fair, Good, and Very Good) make up the qualitative range. You don’t have to have
four values — you can have as many or as few as you need. In this scenario, you want the