Microsoft Office Tutorials and References
In Depth Information
USING A DIALOG BOX TO LAY OUT A PIVOT TABLE
Clicking the Layout button in Step 3 of the PivotTable and PivotChart
Wizard. You then can use a dialog box to lay out the pivot table.
Clicking the Finish button to create a blank pivot table. You then can use
the PivotTable Field List toolbar to lay out the pivot table.
I describe both of these options in the following subsections.
USING A DIALOG BOX TO LAY OUT A PIVOT TABLE
When you click the Layout button of the wizard’s last dialog box, you get the
dialog box shown in Figure 9-8. The fields in the database appear as buttons along
the right side of the dialog box. Simply drag the buttons to the appropriate area of
the pivot table diagram (which appears in the center of the dialog box).
Figure 9-8: Specify the table layout.
For versions prior to Excel 2000, this dialog box appears as Step 3 of the
wizard. For these versions, using the Layout dialog box is the only way to lay out
a pivot table.
The pivot table diagram has four areas:
Page: Values in the field appear as page items in the pivot table.
Row: Values in the field appear as row items in the pivot table.
Data: The field is summarized in the pivot table.
Column: Values in the field appear as column items in the pivot table.
You can drag as many field buttons as you want to any of these locations, and
you don’t have to use all the fields. Any fields that you don’t use simply don’t
appear in the pivot table.
Search JabSto ::




Custom Search