Create a chart from data in a PivotTable report
This procedure creates a regular, noninteractive chart rather than a PivotChart report.
- Select the data in the PivotTable report that you want to use in your chart. To include field buttons and data in the first row and column of the report, start dragging from the lower-right corner of the data you're selecting.
- Click Copy .
- Click a cell in a blank area.
- On the Edit menu, click Paste Special.
- Click Values, and then click OK.
- Click Chart Wizard and follow the instructions in the wizard to create the chart.