Microsoft Office Tutorials and References
In Depth Information
Creating a Quick Frequency Tabulation
4. Click OK.
Excel creates an empty pivot table and displays the PivotTable Field List.
5. In the PivotTable Field List, drag the State field into the Row Labels section.
6. Drag the State field into the Values section.
Excel creates the pivot table, which shows the frequency of each state (see Figure 169-2).
Figure 169-2: A quick pivot table shows the frequency of each state abbreviation.
This pivot table can be sorted by using the Home➜Editing➜Sort & Filter command. In addition,
you can even create a pivot chart to display the counts graphically (as shown in Figure 169-3).
Just select any cell in the pivot table and choose PivotTable Tools➜Options➜Tools➜PivotChart.