Prompts / Data & Spreadsheets / Chart Type Selector For A Specific Data Story

Chart Type Selector For A Specific Data Story

Data & Spreadsheets
#charts#visualization#reporting

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
Get PromptJectManager Browse more