In your PivotTable, select a cell. Select any chart option from the Insert Chart dropdown menu on the Insert tab. The graph is now visible in the worksheet.
To make a chart from a PivotTable, follow these steps:
- Choose a cell from your table.
- Select PivotTable Tools > Analyze > PivotChart from the PivotTable Tools menu.
- Choose a graph.
- Click OK.
Share a personalized message with your friends.