This section introduces pivot table by continuing the example based on the questionnaire of holiday destinations.
To create a pivot table from the questionnaire data choose Data/PivotTable and PivotChart Report. The PivotTable wizard now runs.
Accept Excel as the source of the data and PivotTable as the type of report.
Check the range of cells that Excel identifies. If this is the area of your questionnaire click Next, otherwise drag your mouse over the column headings and the answers (don't select the overall title if you have one).
Accept the New worksheet setting and click Finish.
A new worksheet is created with a blank pivot table:
You can now drop fields from the list onto the four main sections of the pivot table:
For example, drag Destination to the Row Fields area and Duration to the Column Fields.
Finally drag Duration to the Data Items area and the pivot table displays totals for the duration values against the destinations.
To focus on one destination or duration use the drop-down lists.
To change the mathematical variable used in the pivot table click on the Field Settings button in the Pivot Table toolbar and choose from the options available: Sum, Count, Average, etc. These allow you to analyse data very quickly.
To make charts from the data shown Click on the Chart Wizard icon in the Pivot Table toolbar -this creates a chart on a new worksheet so click on the tabs at the bottom of the page to return to the pivot table. The Chart toolbar is now active so you can select a different style of chart from the drop-down list.
Click the Back Button to Return