Excel: What Happened? Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22

Pivot Chart Options

Select the Fields and Count the Value, just as you did for the PivotTable Report.

 

Choose the Field: Department

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

 

Count the Data: Computer ID

Drag and Drop the Computer ID field to the Value on the bottom.

 

Well, did you get a Chart?

PivotTable Tools ->Design ->Chart Layout