Microsoft Office Tutorials and References
In Depth Information
Creating dynamic charts by using PivotCharts
Any changes to the PivotTable on which the PivotChart is based are reflected in the
PivotChart. For example, if the data in an underlying data set changes, clicking the Refresh
button in the Data group on the Analyze tool tab will change the PivotChart to reflect the
new data. Also, if you filter the contents of a PivotTable, the filter will be reflected in the
PivotChart. For instance, if you click 2009 in the Year list of a revenue analysis PivotTable
and then click OK, both the PivotTable and the PivotChart will show only revenues from
2009.
10
SEE ALSO For more information on manipulating PivotTables, see “Filtering, showing, and
hiding PivotTable data” earlier in this chapter.
 
Search JabSto ::




Custom Search