Insert-> Tables-> PivotTable->PivotChart

Create a Pivot Chart

2. Try This: Create a PivotChart

Go to the Original Data spreadsheet.

Select All.

Go to Insert->Tables->PivotTable.

Click on PivotChart.

 

 

You will be asked to confirm the location of the data and whether you would like to place the new PivotChart in a new spreadsheet.

 

Keep going, please...

Exam 77-888: Microsoft Excel Expert 2010

3. Presenting Data Visually

3.4. Apply and manipulate PivotCharts