Summit Data Analytics
How to Create a Sales Dashboard in Excel
Learn which sales metrics, charts and filters to include in an effective Excel sales dashboard.
Get a Free Price Quote →Practical analytics built for real SME decisions.
Learn which sales metrics, charts and filters to include in an effective Excel sales dashboard.
Built around your data and KPIs.
Reduce repetitive reporting.
Make trends and exceptions visible.
SME Sales Analytics Guide
Sales Dashboard in Excel: Track Sales, Revenue & Performance
A sales dashboard brings transaction data into one management view so an SME can quickly see revenue, targets, growth, customers, products and sales-team performance.
1. Start with clean sales data
Keep one row per transaction or order line. Useful fields include date, order number, customer, product or category, salesperson or region, quantity, revenue and target.
2. Track the KPIs that support decisions
Total sales value for the selected period.
Actual sales compared with the sales target.
Current-period performance compared with a previous period.
Revenue divided by the number of orders.
Identify customers contributing the highest revenue.
See which products or categories drive revenue and growth.
3. Build management views
A useful dashboard normally combines headline KPIs, monthly trends, target-versus-actual performance, top customers, top products and salesperson or region performance. Use charts only where they help answer a management question.
4. Make the dashboard interactive
Excel Tables, PivotTables, PivotCharts and slicers can make reporting easier to refresh. SUMIFS, COUNTIFS and XLOOKUP can also support structured calculations when the source data is consistent.
Practical principle
Separate raw data, calculations and the dashboard presentation. This makes the workbook easier to refresh, check and maintain.
5. Use the dashboard to ask better questions
The value of a dashboard is not the chart itself. It is the decision it supports: Which customers are growing? Which products are slowing? Are we meeting targets? Which salesperson or region needs attention?
Common mistakes to avoid
- Tracking too many KPIs without clear decisions attached to them.
- Using inconsistent customer or product names.
- Manually copying monthly totals into a presentation sheet.
- Showing revenue without targets, trends or useful comparisons.
- Building a dashboard that cannot be refreshed when new transactions are added.
Frequently asked questions
What should a sales dashboard in Excel include?
For most SMEs: revenue, orders, average order value, target achievement, margins where reliable data is available, customer and product performance, trends and relevant filters.
Can the dashboard update automatically?
Yes. Excel Tables, PivotTables, formulas and Power Query can reduce repetitive preparation when the source data is consistent.
Is Excel enough for an SME sales dashboard?
Often yes, especially where teams already use Excel and the data volume and reporting process are manageable. The right tool depends on data size, refresh needs, sharing and governance.
Need a sales dashboard built around your business?
Summit Data Analytics builds practical Excel dashboards around your existing data, KPIs and reporting requirements.