Exam 77-428 Microsoft Excel 2013 EXPERT 4. Create Advanced Charts and Tables 4.3   Create and Manage PivotCharts: Create New PivotCharts (Change Value Field Settings)

Value Field Settings You can choose the type of calculation you wish to use to summarize and display the data in the PivotTable and PivotChart.   7. Try it: Edit the Value Field Settings Go to Summize Value by. Choose: Sum.   What Do You See? The Custom Name should be Sum of Amount, now.   Please click OK and keep going... PivotChart Tools ->Analyze ->Show/Hide->Field List