|
Look at
the bottom of the PivotTable Field List. There is only one
value: the Product is in the Axis Fields. So far so good.
PivotTables and PivotCharts calculate: COUNT, SUM,
AVERAGE. This is done by adding a field to the Values.
5.
Try it: Add a Value Go to the
PivotTable Field List. Select:
Amount. Drag the
Amount to the Values. What Do
You See? The Value was displayed as
Count of Amount in the PivotTable as well as the PivotChart. Keep
going...
Exam 77-888: Microsoft Excel Expert
2010
3. Presenting Data Visually
3.4. Apply and manipulate PivotCharts:
Add a Value
PivotChart Tools ->Analyze
->Show/Hide->Field List
|
|
| |
