Microsoft Office Tutorials and References
In Depth Information
Figure 18-55: If you modify the pivot table, the pivot chart is also changed.
More about pivot charts
Keep in mind these points when using pivot charts:
• A pivot table and a pivot chart are joined in a two-way link. If you make structural or filtering changes to
one, the other is also changed.
• When you activate a pivot chart, the PivotTable Fields task pane changes to the PivotChart Fields task pane.
In this task pane, Legend (Series) replaces the Columns area, and Axis (Category) replaces the Rows area.
• The field buttons in a pivot chart contain the same controls as the pivot chart's field headers. These controls
allow you to filter the data that's displayed in the pivot table (and pivot chart). If you make changes to the
chart using these buttons, those changes are also reflected in the pivot table.
• If you have a pivot chart and you delete the underlying pivot table, the pivot chart remains. The chart's
SERIES formulas contain the original data, stored in arrays.
• By default, pivot charts are embedded in the sheet that contains the pivot table. To move the pivot chart to a
different worksheet (or to a Chart sheet), choose PivotChart Tools ⇒ Analyze ⇒ Actions ⇒ Move Chart.
• You can create multiple pivot charts from a pivot table, and you can manipulate and format the charts separ-
ately. However, all the charts display the same data.
• Slicers and timelines also work with pivot charts. See the examples earlier in this chapter.