Microsoft Office Tutorials and References
In Depth Information
Using a Thermometer-Style Chart
Figure 10-12: Be sure to delete the newly created secondary vertical axis.
9. Right-click the Value series and choose Format Data Series.
10. In the Format Data Series dialog box, click Secondary Axis.
11. Still in the Format Data Series dialog box under Series Options, adjust the Gap Width
property so that the Value series is slightly narrower than the other columns in the chart —
between 205% and 225% is typically okay.
12. Still in the Format Data Series dialog box, click the Fill icon (the paint bucket), expand the Fill
section, and then select the Solid fill option to set the color of the Value series to black.
13. All that’s left to do is change the color for each qualitative range to incrementally lighter
At this point, your bullet graph is essentially done! You can apply whatever minor formatting
adjustments to size and shape the chart to make it look the way you want. Figure 10-13 shows the newly
created bullet graph formatted with a legend and horizontal labels.
Figure 10-13: Your formatted bullet graph.
Adding data to your bullet graph
After you’ve built your chart for the first performance measure, you can use the same chart for any
additional measures. Take a look at Figure 10-14.