6 Excel Dashboard Examples: Sales, Cash Flow, Budget & More

· Data Visualization

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 exampleMain audienceRefresh
Are we on plan, and where is the gap?1. Monthly sales packSales leadership, FP&AMonthly
Who owes us, and who do we chase today?2. Cash and receivablesCredit control, CFODaily / weekly
Where am I overspending?3. Budget vs actualDepartment headsMonthly
Did yesterday's production go well?4. Operations dailyPlant / shift managersDaily
Which projects are at risk?5. Project portfolioPMO, directorsWeekly
What are the five numbers the board asks for?6. Executive one-pagerBoard, CEOMonthly

What data does each dashboard need?

ExampleMinimum source fieldsImportant definition
SalesDate, order ID, customer, revenue, cost, planCount distinct orders, not invoice lines
Cash and receivablesInvoice ID, due date, outstanding balance, customer, ownerAge unpaid balances as of a stated date
Budget vs actualPeriod, cost centre, account, actual, budgetUse matching periods and account mappings
OperationsDate, shift, output, target, downtime cause and minutesCompare consistent units and shift lengths
ProjectsProject ID, dates, approved budget, actual cost, completion estimateDefine how completion is measured
Executive summaryAgreed measures from the underlying reportsReuse 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

RuleWhy
One screen, no scrollingScrolling hides the half nobody reads
Grey by default, one accent colourAttention should be earned, not shouted
Sort by value, never alphabeticallyRanking is the message
Absolute and relative change together40% of a small number is noise
Same layout every monthFamiliarity beats novelty in recurring reports
Data-as-of stamp visiblePrevents decisions on stale numbers

Common mistakes that kill adoption

  1. 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.
  2. Too many slicers. More than four filters usually means the dashboard is trying to serve two audiences. Split it.
  3. 3D charts and dual axes without labels. They distort comparisons; use plain bars and a clearly labelled secondary axis only when units truly differ.
  4. No reconciliation check. Add a hidden cell comparing the dashboard total to the ledger total and show a warning if they differ.
  5. Manual copy-paste refresh. If refreshing takes more than one click, it will eventually be skipped.

Build notes

Adapt an example to your workbook

  1. Pick the decision and audience first, then select one of the six layouts—not all six on one sheet.
  2. Map your source fields to the input table above and reconcile the source totals.
  3. Build the summary calculations before formatting: test a known month and one department or customer.
  4. Add the KPI row, one trend and one ranking or exception view. Use the same filter scope throughout.
  5. Test a new row, an empty selection, missing data and a zero denominator. Confirm charts and KPIs agree after refresh.
  6. 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.