Step 1

A spreadsheet containing all data

Located in the sheet tab named Data table

Excel Data table | www.other-levels.com

Step 2

Create pivot table from the spreadsheet

Located in the sheet tab named Pivot Tables

Excel Pivot Table

Step 3

Insert chart from the pivot table or outside Pivot table

Located in the sheet tab named Dashboard

Dashboard Chart | www.other-levels.com

And/Or

Insert Text Boxes linked to cells inside Pivot table or outside Pivot table using a formula

Excel Text Boxes linked to cells inside Pivot table or outside Pivot table | www.other-levels.com