You can fill in PivotChart fields just like PivotTables. However, PivotCharts have some different fields.

 

Series Fields	Groups data in the chart.
Category Fields	Indicates how data will be grouped vertically.
Data Fields	Add numeric fields here.
Filter Fields	Filter data using these criteria.

 

Here’s a sample:

 

 

This is a graphic representation of the PivotTable we saw in the last lesson. We can easily see which transactions were the most expensive.