Microsoft Office Tutorials and References
In Depth Information
Creating dynamic charts by using PivotCharts
4
Click OK to create the PivotChart and associated PivotTable.
5
In the PivotChart Fields pane, drag the Center field header from the Choose fields
to add to report area to the Legend (Series) area.
6
Drag the Year field header from the Choose fields to add to report area to the Axis
(Category) area.
7
Drag the Quarter field header from the Choose fields to add to report area to the
Axis (Category) 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.
9
Click the 2013 sheet tab to display that worksheet.
10
Select the data in cells B2:E10 , and then press Ctrl+C . Excel copies the data to the
Microsoft Office Clipboard.
10
11
On the tab bar, click the Through 2012 sheet tab to display that worksheet.
12
Select cell B147 , and then press Ctrl+V to paste the data into the worksheet and
include it in the Excel table.
13
Click the tab of the worksheet that contains the PivotTable and the PivotChart. The
PivotChart appears.
14
Select the PivotChart and then, on the Analyze tool tab, in the Data group, click
Refresh to add the data to your PivotChart.
Search JabSto ::




Custom Search