Microsoft Office Tutorials and References
In Depth Information
6. In the PivotTable Field List task pane, drag the Year field header to the Column
Labels area.
Excel adds the Year field values to the PivotTable column area.
7. In the PivotTable Field List task pane, drag the Volume field header to the
Values area.
Excel ills in the body of the PivotTable with the Volume field values.
8. In the PivotTable Field List task pane, in the Column Labels area, drag the
Year field header to the Row Labels area, and drop it beneath the Center field
header.
Excel changes the PivotTable to reflect the new organization.
CLEAN UP Save the Creating workbook, and then close it.
Search JabSto ::




Custom Search