Select Insert > Tables > PivotTable > From Table/Range. Your pivot table is ready for analysis. Head to Insert > Charts and add one of the relevant charts to your Excel sheet. Lets add a line chart ...