Create a PivotChart 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