Microsoft Office Tutorials and References
In Depth Information
Filtering Data in the Chart with Field Buttons
Filtering Data in the Chart with Field Buttons
Click the PivotChart tabs and you’ll recognize nearly all the button groups, because
you’ve seen them on the Chart Tools contextual tab, too. There is, however, a fourth tab—
Analyze—that contains buttons you won’t see associated with standard Excel charts (see
Figure 8–65).
Figure 8–65. The contents of the PivotChart Tools Analyze tab
NOTE: Clicking the Clear drop-down arrow on the Analyze tab will reveal a Clear All option,
which when clicked will remove both the PivotChart and the PivotTable but leave the underlying
grids for the two objects . It’s a way allowing you to start all over again by selecting a new set of
fields for the PivotTable, which in turn immediately generate a PivotChart. The Clear button is
also available in the PivotTable Tools Action button group.
But PivotCharts themselves reveal an element that is nowhere to be found in
conventional charts: field buttons . These represent the PivotTable fields that contribute
the source data to the chart, and when they’re clicked they enable you to make various
changes to the chart.
For example, clicking the arrow on the Salesperson button on the chart triggers the menu
shown in Figure 8–66.
Figure 8–66. Ticking any check box will remove that salesperson’s name—and column—from the chart.
To illustrate, if you click Peacock and then OK, Peacock’s column bar will be banished
from the chart (see Figure 8–67).
Search JabSto ::

Custom Search