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
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.