Microsoft Office Tutorials and References
In Depth Information
Using Histograms to Track Relationships and Frequency
Figure 9-7: You now have two pivot tables that show top and bottom displays.
If there’s a tie for any rank in the top or bottom values, Excel shows you all the tied
records. This means that you may get more than the number you filtered for. If you
filtered for the top 10 sales reps and there’s a tie for the number 5 rank, Excel shows you
11 sales reps (both reps ranked at number 5 will be shown).
Using Histograms to Track Relationships
A histogram is essentially a graph that plots frequency distribution. A frequency distribution shows
how often an event or category of data occurs. With a histogram, you can visually see the general
distribution of a certain attribute.
Take a look at the histogram shown in Figure 9-8. This histogram represents the distribution of units
sold in one month among your sales reps. As you can see, most reps sell somewhere between 5 and
25 units per month. As a manager, you want the hump in the chart to move to the right — more people
selling a higher number of units per month. So you set a goal to have a majority of your sales reps sell
between 15 and 25 units within the next 3 months. With this histogram, you can visually track the
progress toward that goal.
Figure 9-8: A histogram showing the distribution of units sold per month among your sales force.