Microsoft Office Tutorials and References
In Depth Information
Analyzing data dynamically by using PivotTables
8
Verify that the DailyVolumes table name appears in the Table/Range field and that
the New Worksheet option is selected.
9
Click OK to create a PivotTable on a new worksheet.
10
In the PivotTable Fields pane, drag the Center field header to the Rows area. Excel
adds the Center field values to the PivotTable row area.
11
In the PivotTable Fields pane, drag the Year field header to the Columns area. Excel
adds the Year field values to the PivotTable column area.
12
In the PivotTable Fields pane, drag the Volume field header to the Values area. Excel
ills in the body of the PivotTable with the Volume field values.
13
In the PivotTable Fields pane, in the Columns area, drag the Year field header to the
Rows area, and drop it beneath the Center field header. Excel changes the PivotTable
to reflect the new organization.
10
 
Search JabSto ::




Custom Search