Back to library
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 filled

Your Built Prompt

Updates live as you type
This 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 comments
Be the first to leave feedback on this prompt.

Related Prompts

More in Data Analysis