Activity 9: Pivot Table and Pivot Chart

 

Data

Create Pivot Chart with Salesperson and Order Amount - Add the Salesperson to Rows and Order Amount to Values to find out the Grand Total.

Create Pivot Chart with Region, Salesperson and Order Amount - Add the Salesperson to Rows, Region to Columns and Order Amount to Values. Insert Pivot Chart.

Create Pivot Chart with Sales Person, Month and Order Amount  - Add the Salesperson to Rows, Month to Columns, and Order Amount to Values. Change the number format of cells to Currency. Insert Slicer and Pivot Chart. Select the data you want to know.