Back to library
Copilot#data analysisStandard promptSaves ~15min

Build a one-page Excel dashboard from raw data

Copilot turns a raw Excel data export into a clean one-page dashboard with key number tiles, mini trend charts, one breakdown, and a 50-word summary in your brand voice.

rach_maeve4 June 2026

Fill in the Template

0 / 7 filled

Your Built Prompt

Updates live as you type
I have a raw data table in Excel and I want a single dashboard sheet I can send to a stakeholder.

In Excel, open the workbook with the raw data and open Copilot.

Sheet and table: {{sheet_table}}
Who the dashboard is for: {{audience}}
The decision it supports: {{decision}}
The 4 to 6 KPIs that matter: {{kpis}}
Time period: {{period}}
Comparisons that matter (vs. last month, vs. budget, vs. last year): {{comparisons}}
Brand colour I want as the accent: {{colour}}

Ask Copilot:

Build a dashboard on a new sheet called "Dashboard". It should fit on one printed A4 landscape page and include:

1. **Header strip** - title, period, last updated.
2. **KPI tiles** (one per KPI in {{kpis}}) - current value, change vs. {{comparisons}}, sparkline.
3. **One trend chart** - the most important KPI over {{period}}, with a clear annotation on any inflection point.
4. **One breakdown chart** - segmented by the dimension that matters most for {{decision}}.
5. **A short text block** (50 words) - what changed and what to do about it.

Use {{colour}} as the only accent colour, neutral greys for everything else. No emojis. No 3D charts. AU English. AUD. DD/MM/YYYY.

After the dashboard, give me one line on the most important question {{audience}} will likely ask, and where on the dashboard the answer sits.
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