Step 1
A spreadsheet containing all data
Located in the sheet tab named Data table
Step 2
Create pivot table from the spreadsheet
Located in the sheet tab named Pivot Tables
Step 3
Insert chart from the pivot table or outside Pivot table
Located in the sheet tab named Dashboard
And/Or
Insert Text Boxes linked to cells inside Pivot table or outside Pivot table using a formula

Share:
How to update MS Excel dashboard spreadsheet values?
How to change the Excel data table header name?