Exam 77-428 Microsoft Excel 2013 EXPERT 4. Create Advanced Charts and Tables 4.3   Create and Manage PivotCharts: Create New PivotCharts (Edit the Fields)

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... PivotChart Tools ->Analyze ->Show/Hide->Field List