Create a Pivot Chart

 

Create a PivotChart

Select a cell in your table.

 

Select Insert > PivotChart  PivotChart option on the ribbon .

 

Select OK.

 

Create a chart from a PivotTable

Select a cell in your table.

 

Select PivotTable Tools > Analyze > PivotChart  PivotChart option on the ribbon .

 

Select a chart.

 

Select OK