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...