Microsoft Office Tutorials and References
In Depth Information
Using Histograms to Track Relationships and Frequency
As in the formula-driven histogram, the first step in creating a histogram with a pivot table is to
create a frequency distribution.
If you’re new to pivot tables, rest easy. In Part IV of this topic, we cover the ins and outs
of pivot tables. This section allows you to get a preview of the types of advanced
analysis you can accomplish with pivot tables.
1. Create a pivot table and plot the data values in the row area (not the data area). As you can
see in Figure 9-17, the SumOfSales Amount field is placed in the ROWS area. Place the Sales
Rep field in the VALUES area as a Count.
Figure 9-17: Place your data values in the ROWS area and the Sales Rep field in the VALUES area as a Count.
2. Right-click any value in the ROWS area and choose Group.
The Grouping dialog box appears (see Figure 9-18).
Figure 9-18: The Grouping dialog box.
3. In the dialog box, set the start and end values and then set the intervals.
This essentially creates your frequency distribution. In Figure 9-18, the distribution is set to
start at 5,000 and to create groups in increments of 1,000 until it ends at 100,000.