Home / Excel dashboard examples

Specimen catalogue

Forty-eight dashboards, built from your own columns

Every layout below is a working design, not a screenshot. Each one looks for the columns it needs in your spreadsheet and maps itself to whatever you actually have — so the cash-flow layout works on your cash-flow export, not just on ours. Every number is computed from your file.

48Designs
6Categories
201Excel workbooks
0Add-ins to install
One screen, four to six headline numbers, and at most two charts that explain them.

The usual failure is showing everything the data contains instead of the handful of figures a decision turns on. Every design here keeps that shape: a scorecard row, one or two charts, and a ranking table underneath.

Open all 48 in the app →

Business

09 designs
01Business

SaaS Metrics

MRR, churn, active subscriptions, and growth for subscription businesses.

binds tomrrarrrecurringrevenuesubscription
Build it from my data8 widgets
02Business

Executive Summary

The one-page board view — headline numbers, trend, and what moved.

binds torevenuesalesincometotalprofit
Build it from my data8 widgets
03Business

KPI Scorecard

Every KPI against its target, with a gauge for the ones that matter.

binds toactualvalueresulttotaltarget
Build it from my data8 widgets
04Business

Agency Client Report

What you send the client each month — spend, results, cost per result.

binds tospendcostinvestmentfeelead
Build it from my data8 widgets
05Business

Survey & NPS Results

Scores, distribution, and how sentiment splits by segment.

binds tonpsscoreratingcsatresponse
Build it from my data8 widgets
06Business

Procurement & Suppliers

Spend and savings by supplier, with on-time delivery and lead time.

binds tospendamountvaluecostpo
Build it from my data8 widgets
07Business

Professional Services Utilisation

Billable hours, utilisation and WIP by consultant and project from a timesheet export.

binds tohourstimeloggedbillablechargeable
Build it from my data8 widgets
08Business

Agency Retainer Health

Hours delivered against each retainer, the margin left, and who is over scope.

binds tofeeretainerrevenuevaluehours
Build it from my data8 widgets
09Business

Product & App Analytics

Active users, sessions and retention, and which features people actually use.

binds todaudaily activeactive usermaumonthly active
Build it from my data8 widgets

Finance

09 designs
10Finance

Finance Summary

Income, expenses, cash flow, and margin for the monthly P&L.

binds toincomerevenueinflowexpensecost
Build it from my data8 widgets
11Finance

Cash Flow

Money in, money out, and the running balance that decides your runway.

binds toinflowreceiptincomeinoutflow
Build it from my data8 widgets
12Finance

Budget vs Actual

Where spend has drifted from plan, by line and by owner.

binds tobudgetplanforecastactualspend
Build it from my data8 widgets
13Finance

Receivables Ageing

Who owes what, how overdue it is, and where the exposure sits.

binds tooutstandingbalancedueamountoverdue
Build it from my data8 widgets
14Finance

Product Profitability

Margin by product or line — the view revenue alone hides.

binds torevenuesalesturnovercogscost of
Build it from my data8 widgets
15Finance

Subscription Revenue

MRR movement — new, expansion and churned — and how it splits by plan.

binds tomrrarrrecurringnewexpansion
Build it from my data8 widgets
16Finance

Cash Runway & Burn

Cash in the bank, monthly burn and the months of runway that leaves.

binds tocashbankbalanceburnnet loss
Build it from my data8 widgets
17Finance

Expense Management

Claims by category, vendor and employee, with what is still awaiting approval.

binds toamounttotalexpensecostclaim
Build it from my data8 widgets
18Finance

Invoicing & Collections

Invoiced, paid and overdue by client, plus how long clients take to pay.

binds toamounttotalinvoicedvaluepaid
Build it from my data8 widgets

Marketing & Sales

11 designs
19Marketing & Sales

Sales Performance

Revenue, deals, and win-rate at a glance — built for sales reviews.

binds torevenuesalesamountvaluetotal
Build it from my data8 widgets
20Marketing & Sales

Marketing Overview

Spend, clicks, impressions, and conversions for campaign reporting.

binds tospendcostbudgetclickvisit
Build it from my data8 widgets
21Marketing & Sales

E-commerce

Orders, AOV, revenue, and repeat-rate for online store performance.

binds torevenuesalesgmvtotalorder
Build it from my data8 widgets
22Marketing & Sales

Web Analytics

Sessions, users, bounce, and engagement for website performance.

binds tosessionvisituservisitorpageview
Build it from my data8 widgets
23Marketing & Sales

SEO & Search Console

Clicks, impressions, CTR and average position from a Search Console export.

binds toclickimpressionctrclick-throughclick through
Build it from my data8 widgets
25Marketing & Sales

Email Marketing

Delivered, opens, clicks and unsubscribes per campaign, with the rates that matter.

binds todeliveredsentrecipientopenclick
Build it from my data8 widgets
26Marketing & Sales

Social Media

Reach, engagement and follower growth across channels and post formats.

binds toimpressionreachviewengagementinteraction
Build it from my data8 widgets
27Marketing & Sales

Content Performance

Which articles and pages earn traffic, time and conversions.

binds tosessionpageviewpage viewvisitconversion
Build it from my data8 widgets
28Marketing & Sales

CRM Pipeline

Open pipeline by stage and owner, weighted by probability, from a CRM deal export.

binds toamountvaluedeal sizeacvdeal
Build it from my data8 widgets
29Marketing & Sales

Sales Rep Leaderboard

Bookings against quota, activity and win rate, ranked by rep.

binds tobookingrevenuesalesclosedquota
Build it from my data8 widgets

Operations

07 designs
30Operations

Project Tracker

Progress, effort and slippage across tasks, owners and phases.

binds totaskitemticketstorycomplete
Build it from my data8 widgets
31Operations

Inventory & Stock

Stock on hand, value tied up, and what is about to run out.

binds tostockon handquantityqtyvalue
Build it from my data8 widgets
32Operations

Logistics & Delivery

On-time rate, cost per drop, and where the delays cluster.

binds todeliveryshipmentconsignmentdropon time
Build it from my data8 widgets
33Operations

Production & Quality

Output, yield and defects by line, shift or product.

binds tooutputproducedunitsvolumedefect
Build it from my data8 widgets
34Operations

Customer Support

Ticket volume, response time, and what people keep asking about.

binds toticketcaserequestissueresolved
Build it from my data8 widgets
35Operations

Field Service

Jobs completed, first-time fix, response time and SLA by technician.

binds tojobwork ordervisitcallfirst time fix
Build it from my data8 widgets
36Operations

Fleet & Maintenance

Mileage, fuel, servicing and downtime per vehicle from telematics or a fuel-card export.

binds tomileagemileskmdistancefuel
Build it from my data8 widgets

People

03 designs
37People

HR & Headcount

Headcount, attrition and cost by department — the people P&L.

binds toheadcountemployeestaffftesalary
Build it from my data8 widgets
38People

Hiring Funnel

Applications through to offer, and where candidates drop out.

binds toapplicationapplicantcandidateinterviewscreen
Build it from my data8 widgets
39People

Payroll & Compensation

Salary, bonus and overtime cost by department, band and contract type.

binds tosalarygrossbasicpaybonus
Build it from my data8 widgets

Sector

09 designs
40Sector

Property Portfolio

Rent roll, yield and occupancy across a portfolio.

binds torentincomerevenuevaluevaluation
Build it from my data8 widgets
41Sector

Clinic & Caseload

Appointments, waiting times and caseload by clinician.

binds toappointmentvisitconsultationsessionpatient
Build it from my data8 widgets
42Sector

Student Performance

Attainment, attendance and progress by cohort or subject.

binds tostudentpupillearnergradescore
Build it from my data8 widgets
43Sector

Hotel & Restaurant

Occupancy, ADR, RevPAR and covers, with revenue by room type or outlet.

binds torevenuesalestakingsoccupancyocc
Build it from my data8 widgets
44Sector

Nonprofit Fundraising

Donations, donors and grants by campaign and programme, with donor retention.

binds todonationamountgiftraiseddonor
Build it from my data8 widgets
45Sector

Construction Projects

Budget, committed and actual cost per project, with percent complete and retention held.

binds tobudgetcontractestimatecommittedordered
Build it from my data8 widgets
46Sector

Retail Store Performance

Sales, footfall, conversion and transaction value ranked store by store.

binds tosalesrevenuetakingsnetfootfall
Build it from my data8 widgets
48Sector

Membership & Fitness

Members joined and lost, class attendance and revenue by plan.

binds tomemberactivesubscriberjoinednew
Build it from my data8 widgets

Common questions

What makes a good Excel dashboard?

One screen, four to six headline numbers, and at most two charts that explain those numbers. The common failure is a dashboard that shows everything the data contains rather than the handful of figures a decision actually turns on.

How many KPIs should a dashboard show?

Four to six on the top row. Past that the eye stops treating any of them as headline figures. If more matter, they belong in the table beneath, not as tiles.

Can I use these layouts with my own spreadsheet?

Yes. Each design binds to column intent rather than to a fixed schema — it looks for columns whose names suggest revenue, date, region and so on, and maps itself to whatever your file has. Every number is computed from your data.

Do I need an Excel add-in?

No. These run in the browser on an uploaded .xlsx or .csv. No add-in, no macro, no VBA.

Keep reading