Microsoft Office Tutorials and References
In Depth Information
See Also For more information on manipulating PivotTables, see “Filtering, Showing, and
Hiding PivotTable Data” in Chapter 9, “Creating Dynamic Worksheets by Using PivotTables.”
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.