Microsoft Office Tutorials and References
In Depth Information
Filtering Data in the Chart with Field Buttons
Figure 8–67. The salespersons, minus Peacock. Note the filter symbol that now appears on the Salesperson field
button, indicating that a name has been filtered out of the chart.
Peacock has flown the coop, and as a result, the value axis, which had established a
maximum of 10,000 in order to be able to record Peacock’s high sales total, has been
reset to 3,000, now that Leverling is the leading salesperson. But more importantly, take
a look now at the source PivotTable (see Figure 8–68).
Figure 8–68. Peacock’s missing here, too .
What we see is that filtering the data in the PivotChart changes the source PivotTable
correspondingly. If you make a change in the data recorded by the chart, you’ll also
change the PivotTable that gave rise to the chart in the same way. And, needless to say,
the reverse is true, too; any data change in the PivotTable changes the PivotChart as
And if you don’t want to see those field buttons on the chart, right-click any button and
select the Hide All Field Buttons on Chart option on the resulting menu. You can also delete a
particular field button by right-clicking it and selecting Remove Field (see Figure 8–69).