To create a chart in an Excel report sheet: Select Insert ... into the values area of the PivotTable fields pane. You'll see the data imported from the source sheet into your pivot table.