Modify the PivotChart

2. Try This: Choose a Field

Go to the PivotTable Field List.

Select: Month.

 

Try This, Too: Add a Value

Go to the PivotTable Field List.

Select: Amount.

Drag the Amount to the Values.

You should see Count of Amount.

 

And This: Edit the Value Field Settings

Go to the Values.

Select: Count of Amount.

Click on Value Field Settings...

Summarize Field Value by: SUM.

 

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