Microsoft Office Tutorials and References
In Depth Information
Showing Performance Against a Target Range
Figure 10-19: You can create a component that plots performance against a target range.
Obviously, the trick to this type of component is to set up the band that represents the target range.
Here’s how you do it:
1. Set up a limit table where you can define and adjust the upper and lower limits of your target
Cells B2 and B3 in Figure 10-20 serve as the place to define the limits for the range.
2. Build a chart feeder that’s used to plot the data points for the target range.
This feeder consists of the formulas revealed in cells B8 and B9 in Figure 10-20.
The idea is to copy these formulas across all the data.
The values you see for Feb, Mar, and Apr are the results of these formulas.
3. Add a row for the actual performance values (see Figure 10-21).
These data points create the performance trend line.
Figure 10-20: Create a chart feeder that contains formulas that define the data points
for the target range.
Figure 10-21: Add a row for the performance values.