Copilot#data analysisStandard promptSaves ~15min
KPI dashboard layout for a small team
Lay out a one-tab Excel KPI dashboard with tiles, sparklines, colour rules, and a story panel.
rach_maeve16 August 2026
Fill in the Template
0 / 5 filledYour Built Prompt
Updates live as you typeThis prompt is designed to work in Microsoft Copilot in Excel. Paste into the Copilot chat sidebar.
Design me a one-tab KPI dashboard in Excel for a small team. It should show at most six numbers big, with tiny sparklines, and a short story panel.
Here is the context:
- The team or function: {{team}}
- The six KPIs that matter most: {{kpis}}
- Data sources for each: {{sources}}
- Update cadence (weekly, monthly): {{cadence}}
- Who reads it: {{audience}}
Please give me:
1. A recommended grid layout with cell coordinates: KPI tiles across the top, sparklines under each tile, story panel down the side.
2. The formula for each KPI including MoM or WoW comparison and a friendly text label such as "up 8% vs last week".
3. The exact steps to build the sparklines (Insert, Sparkline, source range).
4. Colour rules: green for on-track, amber for slipping, red for missed, tied to a threshold column.
5. A ten-line story panel template with prompts for wins, worries, decisions needed.
Do not add KPIs I did not ask for.
Tone: dashboard designer who respects the reader's time. AU English, no em-dashes.Run in
Fill in the required fields above to copy or run this prompt.
Tags
Community Feedback
0 commentsBe the first to leave feedback on this prompt.
Related Prompts
More in Data AnalysisClaude
#data analysis
Commission forecast from listings under contract
Reads your pipeline of listings under contract and forecasts the next 90 days of commission income, with risk ratings on each settlement.
Copy
Copilot
#data analysis
Find the right numbers to track in Excel for my business
Copilot explains each number in plain English, writes the exact Excel formula, sanity-checks it on row one, and flags 2 ways the number could mislead you.
Copy
Copilot
#data analysis
Excel formula generator from plain English
Describe what you want in plain English and get the exact Excel formula plus a walk-through.
Copy
Claude
#data analysis
Sales report by SKU
Ranks products by units sold, revenue, margin, and stock health for the period you pick. Tells you what to push and what to wind down.
Copy