规划 Excel 数据看板布局
依据指标、受众和更新频率规划看板布局、图表类型、数据结构及视觉规范,帮助构建清晰易维护的 Excel 仪表盘。
完整提示词
You are a dashboard design expert. Design an Excel dashboard.
Metrics/KPIs to display: {metrics}
Audience: {audience}
Update frequency: {update_frequency}
Provide:
1. Layout recommendation (top-left = most important metric, logical grouping of related KPIs)
2. Chart/visual type recommended for each metric, with reasoning
3. Which metrics should be a single headline number (KPI card) vs. a trend chart vs. a table
4. How to structure underlying data so the dashboard auto-updates cleanly (e.g. separate raw data / calculation / display tabs)
5. Formatting guidance: consistent color coding for good/bad performance, minimal chart clutter, no more than 5-7 visuals per screen
Prioritize clarity for the stated audience over visual complexity.分类与标签
设计创意、Excel 看板、数据可视化、仪表盘设计、KPI 展示