Microsoft Office Tutorials and References
In Depth Information
SET UP You need the RevenueAnalysis_start workbook located in your Chapter10
practice file folder to complete this exercise. Open the RevenueAnalysis_start
workbook, and save it as RevenueAnalysis . Then follow the steps.
1. On the Through 2009 worksheet, click any cell in the Excel table.
2. On the Insert tab, in the Tables group, click the PivotTable arrow and then, in the
list that appears, click PivotChart .
The Create PivotTable With PivotChart dialog box opens.
3. Verify that the QuarterlyRevenue table appears in the Table/Range field and that
the New Worksheet option is selected.
4. Click OK .
Excel creates the PivotTable and associated PivotChart.
5. In the PivotTable Field List task pane, drag the Center field header from the
Choose fields to add to report area to the Legend Fields area.
6. Drag the Year field header from the Choose fields to add to report area to the
Axis Fields area.
7. Drag the Quarter field header from the Choose fields to add to report area to
the Axis Fields area, positioning it below the Year field header.
8. Drag the Revenue field header from the Choose fields to add to report area to
the Values area.
Excel updates the PivotChart to reflect the field placements.
Search JabSto ::




Custom Search