PivotTables are the "backbone" that summarises your raw data for the dashboard. Go to and choose "New Worksheet".
Charts convert those summarised numbers into visual insights. Dashboards for excel
: Select your data and press Ctrl + T . This makes your data "dynamic," meaning your dashboard will automatically include any new rows you add later. PivotTables are the "backbone" that summarises your raw