Next, we want to tell Excel to extract the value into our third column if ... Now that you've applied your new parameters to your table, you're ready to add this to your chart.

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.