Google Sheets

With large data sets, create a pivot table and not a simple chart.
Select the data cells a:1 to g:12
Go to Data, Pivot table

Add/assign your values in the pivot table editor. And, powee! Magic!

We created a custom pivot table using sample data. It's helps to practice the process so we can actually reproduce on the exam.'