graphic2
graphic1

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

PivotTable Field List

You should see a PivotTable on the left side of your spreadsheet but there will not be any data in the Chart, yet.

 

PivotCharts, like PivotTables, need data. We will select the Fields and Count the Value with the Field List to create a PivotTable Report.

 

4. Try This: Choose a Field

Go to the PivotTable Field List.

Select: Product.

 

What Do You See? The PivotTable should display each Product. The PivotChart has a Filter on the Row Labels in Cell A1, but the Chart is still blank.

 

Keep going...

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

 

graphic3