Microsoft Office Tutorials and References
In Depth Information
Showing Performance Against a Target Range
Figure 10-17: Rotate all labels so that they’re on their sides.
Figure 10-18: A horizontal bullet graph.
The nifty thing about this trick is that because the picture is taken with the Camera tool, the picture
automatically updates when the source table changes.
Never heard of the Camera tool? Check out Chapter 4 for a detailed look at benefits of
the Camera tool.
Showing Performance Against
a Target Range
In some businesses, a target isn’t one value — it’s a range of values. That is to say, the goal is to stay
within a defined target range. Imagine you manage a small business selling boxes of meat. Part of
your job is to keep your inventory stocked between 25 and 35 boxes in a month. If you have too
many boxes of meat, the meat will go bad. If you have too few boxes, you’ll lose money.
To track how well you do at keeping your inventory of meat between 25 and 35 boxes, you need a
performance component that displays on-hand boxes against a target range. Figure 10-19 illustrates
a component you can build to track performance against a target range. The gray band represents
the target range you must stay within each month. The line represents the trend of on-hand meat.