Select the data, Go to tab (top) named Insert, Select Chart, then pivot table, Select table /range data, Select New Worksheet.

Pivot table steps - AAT

Theme

Options

Leaderboard

Switch template

Interactives

Restore auto-saved: ?