|
Exam 77-888: Microsoft Excel Expert
2010
3. Presenting Data Visually
3.4. Apply and manipulate
PivotCharts: Edit the PivotTable Field List You should
see a PivotTable on the left side of your spreadsheet but there will
not be any data in the Chart, yet.
PivotCharts, like PivotTables, need data. We will select the Fields and Count the Value
with the Field List to create a
PivotTable Report. 4. Try
This: Choose a Field Go to the
PivotTable Field List. Select:
Product. What Do
You See? The PivotTable should display each Product. The
PivotChart has a Product Filter, but the Chart is still blank. Keep
going...
PivotChart Tools ->Analyze
->Show/Hide->Field List
|
|
| |
