How to Create a Sales Dashboard in Excel

To create a sales dashboard in Excel, turn your sales export into a Table, build PivotTables for revenue by month, product and region, chart them, and tie them together with slicers. The steps below take about an hour the first time; the shortcut after them takes a minute.

Build the dashboard yourself with the steps below, or upload your sales file and get the same dashboard — revenue, orders, trend and top products — in one step.

1. Put the data in a Table

Start from one row per order or order line, with a date, an amount and the things you want to break it down by (product, region, channel). Click inside the data and press Ctrl+T. A Table grows when you paste next month's rows in, which is what keeps the dashboard working after the first month.

Check three things first: dates are real dates (not text), amounts are numbers, and there are no subtotal rows mixed into the data.

2. Build the PivotTables

Insert → PivotTable from the Table, on a new sheet called Calc. Make one for each view: revenue by month (Date in Rows, grouped by Months and Years), revenue by product, revenue by region. Add a count of order IDs for number of orders. Keep them on the Calc sheet so the dashboard sheet only holds the visuals.

3. Chart them and add KPI cards

Insert a PivotChart for each PivotTable: a line for the monthly trend, bars for products and regions. For the headline numbers — total revenue, orders, average order value — use GETPIVOTDATA or a SUM on the Table in a large-font cell. Average order value is revenue divided by the count of distinct orders, not the average of the amount column when an order has several lines.

4. Connect them with slicers

Select a PivotTable, Insert → Slicer, and pick Region or Product; then Report Connections to attach the slicer to every PivotTable. Add a Timeline for dates. Now one click filters the whole dashboard. Each month, paste the new rows into the Table and use Data → Refresh All.

Upload a spreadsheet, get the dashboard

Excel, CSV or Google Sheets. DataMimi recognises what the data is and builds:

Headline figures with the change against the previous period
The trend over time, and breakdowns by category, product and region
Written findings, checked against the figures
Filters: pick a period, press a bar to narrow everything to that group
Next month's file added without counting a month twice
Or connect Google Sheets and refresh on a schedule

Or ask a question about the file first — no account

Free account, no card. The free plan includes credits to build your first dashboards.

What usually goes wrong with it

Dates that are text
Exports often write dates as text, so PivotTables cannot group them by month and the trend comes out as one bar per day or as nothing at all.
DataMimi It reads text dates as dates and says which column it converted, so the trend groups by month from the start.
Subtotal rows counted twice
A total row left inside the data doubles the revenue in every PivotTable built on top of it.
DataMimi It finds total and subtotal rows, checks them against what they sum, and leaves them out of every figure.
Average order value over lines, not orders
When one order has three lines, averaging the amount column gives the average line, which understates what a customer spends.
DataMimi It counts distinct orders for average order value and shows the formula it used under the number.
Next month breaks it
A range instead of a Table, or a new column name in next month's export, leaves the PivotTables pointing at last month's data.
DataMimi Next month's file goes in with Update data: a month sent again replaces the old one, and the dashboard keeps its settings.

Common questions

How do I create a sales dashboard in Excel?

Put the sales data in a Table, build PivotTables for revenue by month, product and region, chart each one, add KPI cells for totals, and connect everything with slicers so one click filters the whole sheet.

What should a sales dashboard include?

Total revenue and orders with the change against the previous period, average order value, the monthly trend, and the top products, regions or channels. More than six or seven visuals and nobody reads it.

How do I make the sales dashboard interactive?

Slicers and a Timeline connected to every PivotTable (Report Connections) make it interactive: pick a region or a date range and every chart and KPI follows.

How do I create a daily, weekly or monthly sales report in Excel?

Use the same Table and group the date field in the PivotTable by Days, by 7-day periods or by Months. A sales performance dashboard is the monthly report with the comparison to last period added.

Is there a free sales dashboard template for Excel?

Templates exist, but your columns rarely match theirs, so most of the work is reshaping your data to fit. Building from your own export, or uploading it to DataMimi, skips that step.

How do I update the dashboard every month?

Keep the data in a Table, paste the new month's rows at the bottom and press Refresh All. In DataMimi, add the new file with Update data or connect the Google Sheet and refresh on a schedule.

Can I create a sales report in Excel with formulas instead of PivotTables?

Yes: SUMIFS and COUNTIFS against the Table work and are easier to audit. They are slower to build and to change than PivotTables.

Turn your file into a dashboard

Upload the spreadsheet and DataMimi lays it out — figures, trend, breakdowns and findings — in one step.