Excel Dashboard Template
A ready-made sales dashboard: paste your data, name your regions and products, and the KPIs and charts update.
Download the template
Download excel-dashboard-template.xlsx Excel workbook (.xlsx), 22 KB. Works in Microsoft Excel, LibreOffice Calc and Google Sheets.
What is inside
- Dashboard: Six KPIs, region and product tables, a month-by-month table and two charts.
- Data: Date, region, product, units, revenue and cost: where your rows go.
Key columns and cells
- KPIs: total revenue, cost, profit, margin, units and revenue per unit.
- Region and product names (blue): must match the Data sheet.
- Year (B4): controls the monthly table and line chart.
How to use it
- Replace the sample rows on the Data sheet.
- Type your region and product names on the Dashboard.
- Set the year.
- Read the KPIs and charts, and adapt the layout to your needs.
Notes and assumptions
- Holds 500 data rows. For more, extend the ranges.
- Read how to build an Excel dashboard to learn how it works.
Frequently asked questions
Can I add a slicer?
Convert the data to a Table and use PivotTables with slicers. The guide explains the steps.
Why are the charts empty?
The names on the Dashboard may not match the Data sheet, or the year may not match your dates.