Page 141 - Excel Data Analysis

08 537547 Ch07.qxd 3/4/03 12:07 PM Page 127

WORKING WITH PIVOTTABLE REPORTS 7

You can change the layout of a PivotTable with You can remove any field from the PivotTable. To
the PivotTable and PivotChart Wizard. To display remove a field, click on it and drag it back to the
the Wizard, select a cell from the PivotTable and PivotTable Field List. As you drag the selected field,
click Data ➪ PivotTable and PivotChart Report. the mouse pointer changes from an arrow to a
This displays the third page of the PivotTable and button image, and a red X indicates that Excel is
PivotChart Wizard. To learn more about the removing the button. Keep in mind, when you
Wizard, see the section "Create a PivotTable remove a field you are simply removing it from the
Report from an Excel List." PivotTable report display. It still remains in the list
and you can add it again at any point.
If you have multiple fields in the Column area
you can change their order on the PivotTable. To
move a column, on the PivotTable toolbar, click
PivotTable ➪ Order to view a menu of move
options. Click the location where you want to
move the selected column. For example, Move to
Beginning places the selected column as the first
column on the left side of the PivotTable report.

MOVE FIELDS ‹ Release the mouse ■ The PivotTable updates to
button. show the field in the new
⁄ Select the desired field on area.
the PivotTable. ■ A broken line indicates the
area that will receive the new
¤ Drag the field to the new field.
area.

127