How to create a Pivot Chart in Excel?

Select a cell in your PivotTable. On the Insert tab, select the Insert Chart dropdown menu, and then click any chart option. The chart will now appear in the worksheet.

Following steps are used to create a chart from a PivotTable

  1. Select a cell in your table.
  2. Select PivotTable Tools > Analyze > PivotChart .
  3. Select a chart.
  4. Select OK.