• 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 and PivotChart Wizard dialog box displays the PivotTable and PivotChart Wizard - Layout dialog box shown in Figure 24.7. 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. Descriptions of each section are coming up later in this section.

Note

After a field is applied to a Row, Page, Column, or Data section, you can double-click the field to access and change the type of summary information, such as count, average, or sum. You can also customize the field name. Note that anything in the Page area creates a “filter” effect for those fields, allowing them to home in on one of the items in the field. The row area lists the items for the field down each row in the spreadsheet, whereas the column area lists items for a field across each column in the spreadsheet.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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