Create a PivotChart
-
Select a cell in your table.
-
Select Insert > PivotChart
. -
Select OK.
Create a chart from a PivotTable
-
Select a cell in your table.
-
Select PivotTable Tools > Analyze > PivotChart
. -
Select a chart.
-
Select OK.
Source: Microsoft