Microsoft Office Tutorials and References
In Depth Information
l The PivotChart appears.
l The PivotChart Filter
Pane appears.
7
Click here and then
select the fields you
want to appear in your
chart.
7
8
Click here and then
select the fields you
want to appear in your
legend.
8
Excel filters your chart.
9
Click the PivotTable Field List button.
l The PivotTable Field List appears.
0
Modify your PivotTable layout.
Note: See Task #50 to learn how to modify
your layout.
l Excel changes the layout of your chart.
9
0
Did You Know?
When you use the PivotChart Filter Pane to filter
your chart, Excel also filters your PivotTable. As
such, information you remove from the PivotChart
is also removed from the PivotTable.
Remove It!
To remove all the filters from your PivotChart, click
your chart to activate the PivotChart tools. Click the
Analyze tab, click Clear, and then click Clear Filters.
To clear your PivotChart and your PivotTable, click
the chart to activate the PivotChart tools, click the
Analyze tab, click Clear, and then click Clear All.
Chapter 5: Explore the Patterns in Your Data
123
Search JabSto ::




Custom Search