6 Excel Dashboard Examples: Sales, Cash Flow, Budget & More
Explore 6 practical Excel dashboard examples for sales, cash flow, budgets, operations, projects and executives—with KPI ideas, formulas and worked numbers.
Looking for Excel dashboard examples you can adapt to your own reporting? Start with these six: sales performance, cash and receivables, budget versus actual, daily operations, project status and an executive summary. Each example below explains the audience, source data, useful KPIs, chart layout and the decision it should support.
These are adaptable design patterns, not six downloadable workbooks or documented client case studies. The worked numbers are illustrative. Where a related free template exists, you will find a link in the relevant example. You can build the core layouts with Excel Tables, PivotTables, charts and slicers; the dynamic-array formulas require a supported version such as Microsoft 365, Excel 2021 or Excel 2024.
Quick pick: which example fits your problem?
| If your question is… | Use example | Main audience | Refresh |
|---|---|---|---|
| Are we on plan, and where is the gap? | 1. Monthly sales pack | Sales leadership, FP&A | Monthly |
| Who owes us, and who do we chase today? | 2. Cash and receivables | Credit control, CFO | Daily / weekly |
| Where am I overspending? | 3. Budget vs actual | Department heads | Monthly |
| Did yesterday's production go well? | 4. Operations daily | Plant / shift managers | Daily |
| Which projects are at risk? | 5. Project portfolio | PMO, directors | Weekly |
| What are the five numbers the board asks for? | 6. Executive one-pager | Board, CEO | Monthly |
What data does each dashboard need?
| Example | Minimum source fields | Important definition |
|---|---|---|
| Sales | Date, order ID, customer, revenue, cost, plan | Count distinct orders, not invoice lines |
| Cash and receivables | Invoice ID, due date, outstanding balance, customer, owner | Age unpaid balances as of a stated date |
| Budget vs actual | Period, cost centre, account, actual, budget | Use matching periods and account mappings |
| Operations | Date, shift, output, target, downtime cause and minutes | Compare consistent units and shift lengths |
| Projects | Project ID, dates, approved budget, actual cost, completion estimate | Define how completion is measured |
| Executive summary | Agreed measures from the underlying reports | Reuse definitions rather than recalculate differently |
Use one tidy Excel Table per source, with no merged cells or subtotal rows. Keep source data, calculations and the dashboard on separate sheets. Before charting, check that numeric columns are numbers and dates are real dates—not text labels that happen to look like months.
1. Monthly sales pack
Answers: are we on plan, who moved, and where is the gap coming from?
+---------------------------------------------------------+
| Revenue | GM % | Orders | AOV (each vs plan and LY) |
+------------------------------+--------------------------+
| 13-month revenue vs plan | Bridge: last month -> |
| (line + plan line) | this month (waterfall) |
+------------------------------+--------------------------+
| Top / bottom 10 customers by variance (sorted bar) |
+---------------------------------------------------------+
- KPI strip: revenue, gross margin %, orders, average order value — each with variance against plan and last year.
- 13-month revenue line with a plan line behind it.
- Sorted bar of top and bottom ten customers by variance to last month.
- Waterfall from last month's revenue to this month's: volume, price, mix, new, lost.
Key formula: keep KPIs driven by one selected month cell so the whole page moves together.
=SUMIFS(tblSales[Revenue], tblSales[Month], SelMonth)
=IF(SUMIFS(tblPlan[Revenue],tblPlan[Month],SelMonth)=0,NA(),SUMIFS(tblSales[Revenue],tblSales[Month],SelMonth)/SUMIFS(tblPlan[Revenue],tblPlan[Month],SelMonth)-1)
Here SelMonth is a named cell containing the selected month-start date, and the Month columns also contain month-start dates. For transaction-level daily dates, use SUMIFS with a start-inclusive, next-month-exclusive date window instead. A zero budget returns #N/A rather than a misleading percentage; display a clear “No budget” note on the dashboard.
Worked example: monthly revenue of 238,000 against a 240,000 plan gives a 2,000 shortfall (−0.83%). Gross profit of 80,000 means 33.61% gross margin: total gross profit divided by total revenue, not an average of row percentages. If there were 400 distinct orders, average order value is 595. These four numbers explain performance more clearly than four unrelated charts.
Decision: investigate the customers or products contributing to the 2,000 shortfall. A volume/price/mix bridge needs a consistent decomposition method and reconciliation to the total change; do not invent bridge components just to fill a waterfall.
Leave off: total-company pie charts, and any chart of a metric nobody owns.
2. Cash and receivables
Answers: what is owed, how late, and who to chase today.
- Ageing buckets as a stacked bar: current, 1–30, 31–60, 61–90, 90+.
- Days sales outstanding trend over 12 months.
- Exception table: top 20 overdue balances with contact owner and last contact date.
- A simple 13-week cash inflow projection based on payment behaviour, not invoice terms.
Key formula: a single ageing bucket column in the data table makes every chart a simple PivotTable.
=LET(d, AsOfDate - [@DueDate],
IFS(d <= 0, "Current", d <= 30, "1-30", d <= 60, "31-60", d <= 90, "61-90", TRUE, "90+"))
AsOfDate is a named report-date cell. Use valid due dates and filter to invoices with a positive outstanding balance first; paid invoices must not appear in the chase list. A fixed as-of date makes a saved month-end report reproducible instead of ageing further every time it is opened.
Worked example: an unpaid invoice of 12,000 due 45 days before AsOfDate belongs in 31–60 days, not 1–30. Put the balance, account owner and next action together in the exception table. If forecast opening cash is 100,000, expected receipts are 80,000 and payments are 90,000, ending cash is 90,000—below a hypothetical 100,000 buffer by 10,000. Those receipts are a forecast, not a guarantee based on invoice due dates.
The exception table is the part that gets used daily. Make it sortable and printable. If you need the forward-looking side, the free 13-week cash flow forecast template pairs with this layout.
3. Budget vs actual for department heads
Answers: where am I over, by how much, and is it timing or a real overspend?
- Variance bars by cost centre, sorted by absolute variance, coloured only where materially over.
- Year-to-date column next to full-year forecast so timing differences are visible.
- Commentary column — a real text field the owner fills in each month.
Key formula: flag only material variances so colour carries meaning.
=AND(ABS([@Variance]) >= MatAmount, ABS([@VariancePct]) >= MatPct)
Use that result as the conditional-formatting rule. Colour every variance and nothing stands out; threshold the formatting at a materiality level agreed with finance.
Worked example: a department spent 112,000 against a 100,000 expense budget. Define expense variance as Actual − Budget: 12,000 overspend, or 12%. With illustrative thresholds of 5,000 and 5%, both conditions are met. If the aim is to flag overspend only, add a positive-variance condition; ABS alone also flags underspend. Use a helper column for this Table formula and refer to its TRUE/FALSE result from the formatting rule.
Compare year-to-date actuals to year-to-date budget, and full-year forecast to full-year budget. Showing YTD actual next to a full-year forecast can provide context, but it is not a like-for-like variance. Ask the owner whether the gap is a delayed invoice, a recurring run-rate increase or a one-off cost, and put that explanation beside the number.
4. Operations / production daily
Answers: did yesterday go well, and what is blocking today?
- Output against target for the last 30 days as a bar-and-line combo.
- Downtime Pareto: causes sorted descending with a cumulative line.
- Scrap rate control chart with mean and control limits.
- Shift comparison as a small multiple, one panel per line.
Key formula: dynamic arrays build the Pareto source without a PivotTable.
=SORTBY(UNIQUE(tblDown[Cause]), SUMIFS(tblDown[Minutes], tblDown[Cause], UNIQUE(tblDown[Cause])), -1)
Refresh matters more than beauty here. If it is not updated by the time the shift meeting starts, nobody opens it — load the source through Power Query and set refresh on open.
The formula above produces sorted cause names; calculate each cause's total minutes in an adjacent helper column and the cumulative percentage before building the Pareto chart. Test spill formulas in the reader's Excel version. Refresh on open is not proof that a background query completed successfully: check completion and source timestamps before the shift meeting.
Worked example: downtime of 120 minutes for changeovers, 60 for breakdowns and 20 for material shortages totals 200 minutes. The first two causes account for 90% of downtime, so the meeting can focus on those causes rather than every minor incident. A scrap-rate control chart requires a justified statistical method and suitable data; target lines are not automatically control limits.
5. Project / portfolio status
Answers: which projects are at risk on time, cost or scope?
- Gantt-style bar per project with a today line.
- Budget burn versus percentage complete — anything above the diagonal is in trouble.
- RAG summary counts, with a click-through list rather than a chart.
- Milestone slippage in days, sorted worst first.
Key formula: derive RAG from rules, not opinions.
=IFS([@Burn] - [@PctComplete] > 0.15, "Red", [@Burn] - [@PctComplete] > 0.05, "Amber", TRUE, "Green")
For interactive Gantt views beyond Excel, see the GanttChartBI guide.
Worked example: a project with 100,000 approved budget and 60,000 actual cost has 60% budget burn. If independently assessed completion is 40%, the gap is 20 percentage points, which is Red under the illustrative 15-point rule above. Burn and completion must both be stored as decimal fractions, such as 0.60 and 0.40. These thresholds are example rules, not a universal project-management standard.
Spending ahead of progress is a warning to investigate, not proof a project will fail: upfront procurement may be planned. Keep the approved baseline, forecast completion date and accountable owner visible, and check missing values before assigning a Green status.
6. Executive one-pager
Answers: the five numbers the board asks about every time.
- Five KPI cards, each with a small sparkline and a single comparison.
- One chart, usually revenue and margin trend.
- Three bullet points of written commentary.
The hardest version to build, because it requires deciding what not to show. If your executive summary has 14 charts, it is not a summary. For SaaS businesses, the SaaS financial model template already produces the ARR, burn and LTV/CAC figures a board pack needs.
Example KPI strip: revenue 238,000; gross margin 33.61%; closing cash 90,000; overdue receivables 12,000; projects at risk 2. These illustrative figures can come from the underlying dashboards, but each needs its own period or as-of date. A monthly flow such as revenue is different from a point-in-time balance such as cash.
Pair the strip with three short comments: what changed, why it changed and who will act. Insert Excel sparklines through Insert > Sparklines; do not use the Google Sheets SPARKLINE worksheet function. Reconcile these KPIs to the detail reports so the board summary does not introduce a seventh set of definitions.
Design rules shared by all six
| Rule | Why |
|---|---|
| One screen, no scrolling | Scrolling hides the half nobody reads |
| Grey by default, one accent colour | Attention should be earned, not shouted |
| Sort by value, never alphabetically | Ranking is the message |
| Absolute and relative change together | 40% of a small number is noise |
| Same layout every month | Familiarity beats novelty in recurring reports |
| Data-as-of stamp visible | Prevents decisions on stale numbers |
Common mistakes that kill adoption
- Hard-coded numbers on the report sheet. One pasted value and the dashboard silently stops reconciling. Every figure should trace back to the data table.
- Too many slicers. More than four filters usually means the dashboard is trying to serve two audiences. Split it.
- 3D charts and dual axes without labels. They distort comparisons; use plain bars and a clearly labelled secondary axis only when units truly differ.
- No reconciliation check. Add a hidden cell comparing the dashboard total to the ledger total and show a warning if they differ.
- Manual copy-paste refresh. If refreshing takes more than one click, it will eventually be skipped.
Build notes
Adapt an example to your workbook
- Pick the decision and audience first, then select one of the six layouts—not all six on one sheet.
- Map your source fields to the input table above and reconcile the source totals.
- Build the summary calculations before formatting: test a known month and one department or customer.
- Add the KPI row, one trend and one ranking or exception view. Use the same filter scope throughout.
- Test a new row, an empty selection, missing data and a zero denominator. Confirm charts and KPIs agree after refresh.
- Preview the actual screen or PDF your audience will use, and write down the refresh steps and metric definitions.
Ordinary charts backed by Tables can expand as rows are appended, but PivotTables still need refreshing. SUMIFS does not automatically inherit a PivotTable slicer's filters: drive formulas from the same selector cells or use GETPIVOTDATA against the filtered PivotTable. A single slicer can connect only to compatible PivotTables sharing a data source.
Every one of these is a three-layer workbook: raw data, a Power Query and PivotTable engine, and a report canvas. The step-by-step is in how to create a dashboard in Excel, and the charting detail is in advanced Excel data visualization techniques. When a dashboard outgrows a workbook, the Excel to Power BI migration guide covers the move.
Want one of these built against your own data and handed over documented? That is exactly what the Excel dashboard service covers.