EXERCISE 9: PIVOT TABLE AND PIVOT CHARTS

PIVOT TABLES

HOW TO CREATE A PIVOT TABLE

1. Select Cells that you want to create a pivot table from.

2. Select Insert > Pivot Table

3. Choose the data you want to analyze, Select a table or range.

4. In table/range, Verify the cell range.

5. Choose where you want to place the Pivot Table, New worksheet or Existing Worksheet.

6. Select Ok.

 

PIVOT CHARTS

HOW TO CREAT PIVOT TABLE TO CHARTS

1. Select a cell in your table.

2. Select PivotTable Tools > Analyze > PivotChart 

3. Select a chart

4. Select OK.