Microsoft Office Tutorials and References
In Depth Information
Using a Thermometer-Style Chart
Creating qualitative bands
First, if the qualitative ranges are the same for all the performance measures in your bullet graphs,
you can format the qualitative range series to have no gaps between them. For instance, Figure
10-16 shows a set of bullet graphs where the qualitative ranges have been set to 0 Gap Width. This
creates the clever effect of qualitative bands.
Figure 10-16: Try setting gap widths to zero to create clean-looking qualitative bands.
1. Right-click any one of the qualitative series and choose Format Data Series.
2. In the Format Series dialog box, adjust the Gap Width property to 0%.
Creating horizontal bullet graphs
If you’re waiting for the section about horizontal bullet graphs, there’s good and bad news. The bad
news is that creating a horizontal bullet graph from scratch in Excel is a much more complex
endeavor than creating a vertical bullet graph — one that doesn’t warrant the time and effort it takes
to create it.
The good news is that there is a clever way to get a horizontal bullet graph from a vertical one — and
in three steps, no less. Here’s how you do it:
1. Create a vertical bullet graph.
Refer to the earlier section “Creating a bullet graph” for more on that topic.
2. Change the alignment for the axis and other labels on the bullet graph so that they’re
rotated 270 degrees (see Figure 10-17).
3. Use Excel’s Camera tool to take a picture of the bullet graph.
After you have a picture, you can rotate it to be horizontal. Figure 10-18 illustrates a
horizontal bullet graph.