Dashboards For Excel -

PivotTables are the "backbone" that summarises your raw data for the dashboard. Go to and choose "New Worksheet".

The foundation of a good dashboard is clean, structured data. Dashboards for excel

: Track real-time or daily activities and frontline tasks. PivotTables are the "backbone" that summarises your raw

: Create a separate PivotTable for each visual you plan to have on your dashboard. 4. Visualise with Pivot Charts Dashboards for excel

Drag your categories (like "Product") into and your metrics (like "Revenue") into Values .