Part V: Analyzing Data with Excel
738
If you modify the underlying pivot table, the chart adjusts automatically to display the new sum-
mary data. Figure 35.27 shows the pivot chart after I changed the Date group to quarters.FIGURE 35.27If you modify the pivot table, the pivot chart is also changed.
More about pivot charts
Keep in mind these points when using pivot charts:l (^) 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.
l (^) 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.
l (^) 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.
l (^) 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 ➪ Tools ➪ Design ➪ Location ➪ Move Chart.
l You can create multiple pivot charts from a pivot table, and you can manipulate and
format the charts separately. However, all the charts display the same data.
l Slicers also work with pivot charts. See the example in the earlier previous section,
“Filtering Pivot Tables with Slicers.”
l Don’t forget about themes. You can choose Page Layout ➪ Themes ➪ Themes to change
the workbook theme, and your pivot table and pivot chart will both reflect the new
theme.