Microsoft Office Tutorials and References
In Depth Information
Creating dynamic charts by using PivotCharts
A PivotChart has tools with which you can filter the data in the PivotChart and PivotTable.
Clicking the Year arrow, clicking (All) in the list that appears, and then clicking OK will
restore the PivotChart to its original configuration.
If you ever want to change the chart type of an existing chart, you can do so by selecting
the chart and then, on the Design tab, in the Type group, clicking Change Chart Type to
display the Change Chart Type dialog box. When you select the type you want and click OK,
Excel re-creates your chart.
IMPORTANT If your data is the wrong type to be represented by the chart type you select,
Excel displays an error message.
In this exercise, you’ll create a PivotTable and associated PivotChart, change the underlying
data and update the PivotChart to reflect that change, change the PivotChart’s type, and
then filter a PivotTable and PivotChart.
SET UP You need the RevenueAnalysis workbook located in the Chapter10 practice
file folder to complete this exercise. Open the workbook, and then follow the steps.
On the Through 2012 worksheet, click any cell in the Excel table.
On the Insert tab, in the Charts group, click the PivotChart button to open the
Create PivotChart dialog box.
Verify that the QuarterlyRevenue table appears in the Table/Range field and that
New Worksheet is selected.