Select Analyze Data at the top and Excel automatically selects the table on your sheet. You can check suggested pivot tables and charts from the side menu. Select the button below to insert them.

Your pivot table is ready for analysis. Head to Insert > Charts and add one of the relevant charts to your Excel sheet. Lets ...