How to create Pivot Tables
A pivot table can be used to summarize a list of data. In the following example, Excel pivot tables can be used to show how many employees there are in any one category within another category – For instance, how many people in each department at each location.
Select the data
- Click on Data in the Menu Bar
- Click on PivotTable and PivotChart Report
The PivotTable and PivotChart Wizard will appear.
Click on the “Finish” button.
A new worksheet will be inserted:
-
From the PivotTable Field List, drag one of the category names and drop it where it says “Drop Column Fields Here” in the box in the top left corner of the screen.
-
From the PivotTable Field List, drag the other category name and drop it where it says “Drop Row Fields Here” in the box at the top left corner of the screen.
-
From the PivotTable Field List, drag the name of the field containing the items you want to count and drop it where it says “Drop Data Items Here” in the box at the top left corner of the screen.
- Click on the X in the top right corner of the PivotTable window and the PivotTable Field List window to close them.
To create a chart from the Pivot Table:
- Click anywhere in the Pivot Table
- On the PivotTable floating toolbar click on the chart button
A column chart will be created, on a new worksheet.