Page 266 - Excel Workbook for Dummies

27_798452 ch19.qxp 3/13/06 7:42 PM Page 249
Chapter 19: Generating Pivot Tables 249
Drop Column Fields Here: This area contains the fields that determine the
arrangement of data shown in the columns of the pivot table.
Drop Row Fields Here: This area contains the fields that determine the arrange-
ment of data shown in the rows of the pivot table.
Drop Data Items Here: This area contains the fields that determine which data
are presented in the cells of the pivot table and then summarized in its last
column (totaled by default).

Try It

Exercise 19-2: Creating a New Pivot Table
Open the workbook Exercise19-2.xls in your Chapter 19 folder in the My Practice
Spreadsheets folder on your hard disk or in the Excel Workbook folder on the work-
book CD-ROM. This workbook contains a copy of the Employee Data List worksheet
with the data list you will use in creating your first pivot table:
1. Click cell A1 on Sheet2 of the Exercise19-2.xls workbook and then choose the
Data➪PivotTable and PivotTable Chart Report menu command.
Excel opens the PivotTable and PivotTable Chart - Step 1 of 3 dialog box, where
the Microsoft Office Excel List or Database option button is selected in the
Where Is the Data You Want to Analyze? section at the top. The PivotTable option
button is selected in the What Kind of Report Do You Want to Create? section at
the bottom.
2. Leave the default options selected and then click the Next button.
Excel opens the PivotTable and PivotTable Chart - Step 2 of 3 dialog box, where
you indicate the cell range of the data to use (in this case, the data list in the cell
range A1:J33 of the Employee Data List worksheet).
3. Click the Employee Data List sheet tab and then drag through the cell range
A1:J33 in the worksheet so that the range address ‘Employee Data List’!$A$1:
$J$33 appears in the Range text box, before you click the Next button.
Excel opens the PivotTable and PivotTable Chart - Step 3 of 3 dialog box, where
you indicate where you want to locate the new pivot table in the workbook. In
this case, you accept the default setting of Existing Worksheet and the cell
address $A$3.
4. Accept the default settings in this dialog box by selecting the Finish button.
Excel opens the PivotTable toolbar and PivotTable Field List dialog box in the
worksheet while at the same time drawing the blank framework for the new pivot
table indicating where to drop the page, row, and column fields along with the
fields to be used as the data items.
5. In the PivotTable Field List dialog box, click the Location field and then select the
Add To button.
Because Row Area was selected at the time you selected the Add To button,
Excel adds the company sites from the Location field in the Employee Data List
to the first column of the pivot table as the row field.
6. Drag the Dept field from the PivotTable Field List dialog box and drop it on the
Drop Column Fields Here section of the pivot table in the cells of the worksheet.
You can also add fields to a new pivot table by dragging them to the desired
position.