: Select your data and press Ctrl + T . This makes your data "dynamic," meaning your dashboard will automatically include any new rows you add later.
Here is a step-by-step guide to building a professional, interactive dashboard in Excel. 1. Define Your Purpose and Audience Dashboards for excel
PivotTables are the "backbone" that summarises your raw data for the dashboard. Go to and choose "New Worksheet". : Select your data and press Ctrl + T