Microsoft Office Tutorials and References
In Depth Information
Tip 80: Creating a Quick Frequency Tabulation
This pivot table can be sorted, by using the Home ➜ Editing ➜ Sort & Filter command. In addition (as
shown in Figure 80-3), you can even create a pivot chart to display the counts graphically. Just select
any cell in the pivot table and choose PivotTable Tools ➜ Analyze ➜ Tools ➜ PivotChart.
Figure 80-3: A few mouse clicks creates a chart from the pivot table.