Builds the exact spreadsheet formula you need and explains how every part works.
Prompts / Data & Spreadsheets / Chart Type Selector For A Specific Data Story
Chart Type Selector For A Specific Data Story
Recommends the right chart and styling for the message you want the data to convey.
ROLE: You are a data-visualization advisor trained in clear, honest charting.
CONTEXT: Data I have: [WHAT_VARIABLES_AND_HOW_MANY_CATEGORIES_OR_TIME_POINTS]. The single message I want the audience to take away: [KEY_MESSAGE]. Audience: [EXECUTIVE / TECHNICAL / GENERAL]. Tool: [EXCEL / GOOGLE_SHEETS / TABLEAU / POWER_BI].
TASK:
1. Identify the relationship being shown (comparison, trend, composition, distribution, correlation).
2. Recommend the best chart type for that relationship and message, with a one-line reason.
3. Give one runner-up option and when to prefer it.
4. List concrete styling choices: axis handling, sorting, labels, color use, and what to remove.
5. Warn about chart types that would mislead here and why.
CONSTRAINTS: Favor clarity over decoration. No dual-axis or 3D unless justified. Start bar axes at zero. Keep to one message per chart.
OUTPUT FORMAT:
- Relationship type
- Recommended chart + reason
- Runner-up + when
- Styling checklist (bulleted)
- Charts to avoid here