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)

Edit the Value Field The Value was displayed as Count of Amount. In this example, Amount  is money: how much was sold? This data would make more sense if the Value was displayed as the Sum of the Amount.   6. Try it: Edit the Value Field Go to the PivotTable Field List. Go to the Values. Select: Count of Amount. Click on Value Field Settings...   Keep going...   The Field options include: Move to Report Filter Move to Axis Fields (Categories) Move to Legend Fields (Series) Move to Values Hide Value Field Buttons on Chart Hide All Field Buttons on Chart Remove Field Value Field Settings... PivotChart Tools ->Analyze ->Show/Hide->Field List