Microsoft Office Tutorials and References

In Depth Information

**Showing Performance with Variances**

them. In situations where you don’t have a target to measure against, it’s often helpful to measure

performance against some organizational statistic.

For example, the component in Figure 10-3 measures the sales performance for each division against

the median sales for all the divisions. You can see that divisions 1, 3, and 6 fall well below the median

for the group.

Figure 10-3:
Measuring data when there’s no target for a measure.

Here’s how you create a median line similar to the one you see in Figure 10-3:

1.
Start a new column next to your data and type the simple MEDIAN formula, as shown in

Figure 10-4.

Note that this formula can be any mathematical or statistical operation that works for the

data you’re representing. Just ensure that the values returned are the same for the entire

column. This gives you a straight line.

Figure 10-4:
Start a new column and enter a formula.

2.
Copy the formula down to fill the table.

Again, all the numbers in the newly created column should be the same.

3.
Plot the table into a column chart.

4.
Right-click the Median data series and choose Change Series Chart Type.

5.
Change the chart type to a line chart.