How MS Excel Dashboards created?

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