Add Another Field

At this point, our PivotTable has one field in the Axis (the Category) and the Sum of Amount for the Value. When you add another field to the PivotTable, you add another layer of complexity to your chart.

 

This lesson will add a field to the Legend, (the Series). This will create a Cross-Tab PivotTable. It will also change how the data is displayed in the PivotChart.

 

Before You Begin: Select the PivotChart. The PivotChart Tools should be available.

 

1. Try it: Add Another Field

Go to PivotChart Tools ->Analyze.

Go to Show/Hide->Field List
Select: Category

Drag Category to the Legend Fields.

 

Keep going...

Exam 77-888: Microsoft Excel Expert 2010

3. Presenting Data Visually

3.4. Apply and manipulate PivotCharts

PivotChart Tools ->Analyze ->Show/Hide->Field List