• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Laying Out the PivotTable

Clicking the Layout button in the Step 3 of 3 PivotTable Wizard dialog box displays the PivotTable and PivotChart Wizard - Layout dialog box shown in Figure 20.8. You can use this dialog box to control the view of data displayed in a PivotTable. The fields from the selected data appear on the right side of the dialog box. Select and drag the desired fields into the area in the center of the dialog box and drop them in the ROW, COLUMN, PAGE, and DATA sections of the dialog box to create the desired layout.

Note

The Layout dialog box is the way PivotTables were built in earlier versions. Microsoft kept this method in case users didn't like the new construction method, although usability studies rated the new method superior to the old layout design.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint