Chart Type Chooser
Given the data you have and the question you're answering, picks the right chart type and explains what to avoid. No dual-axis, no pie chart traps.
The prompt
I have data. I want to communicate something with a chart. Help me pick the right chart type. Ask me first: - What data do you have? (columns, roughly how many rows) - What question are you trying to answer with the chart? - Who's the audience? (technical / executive / general public) Then output: **Recommended chart type** — one specific type (bar, line, scatter, small multiples, heatmap, etc.). NOT a list of options. **Why this one** — 2-3 sentences tying it to your question and data shape. **How to build it** — the axis choices, sort order, color rules, and any annotations or reference lines that make the point land. **Charts to AVOID for this data** — 2-3 common misfires and why they'd be worse. (Pie charts with too many slices, dual-axis, 3D anything, etc.) **One thing to double-check** — the assumption in your data that would make the chart misleading if wrong. Rules: - Never suggest 3D or animated charts. - Never suggest a pie chart for more than 5 slices, or for anything comparative. - Never suggest a dual-axis chart unless the two series share meaningful units. - If the "question" doesn't need a chart (just a number, or a table), say so. ## How to use it Paste this prompt with your data description and question. Get a chart choice + build recipe. Use in your BI tool (Metabase, Tableau, Looker) or a plotting library (matplotlib, D3, Recharts). ## Why it works Wrong chart type is the #1 reason data doesn't persuade. The choice depends on your data shape AND the question — asking about both up front produces a better call than a chart-type flowchart alone.
How to use it
I have data. I want to communicate something with a chart. Help me pick the right chart type.
Ask me first:
- What data do you have? (columns, roughly how many rows)
- What question are you trying to answer with the chart?
- Who’s the audience? (technical / executive / general public)
Then output:
Recommended chart type — one specific type (bar, line, scatter, small multiples, heatmap, etc.). NOT a list of options.
Why this one — 2-3 sentences tying it to your question and data shape.
How to build it — the axis choices, sort order, color rules, and any annotations or reference lines that make the point land.
Charts to AVOID for this data — 2-3 common misfires and why they’d be worse. (Pie charts with too many slices, dual-axis, 3D anything, etc.)
One thing to double-check — the assumption in your data that would make the chart misleading if wrong.
Rules:
- Never suggest 3D or animated charts.
- Never suggest a pie chart for more than 5 slices, or for anything comparative.
- Never suggest a dual-axis chart unless the two series share meaningful units.
- If the “question” doesn’t need a chart (just a number, or a table), say so.
How to use it
Paste this prompt with your data description and question. Get a chart choice + build recipe. Use in your BI tool (Metabase, Tableau, Looker) or a plotting library (matplotlib, D3, Recharts).
Why it works
Wrong chart type is the #1 reason data doesn’t persuade. The choice depends on your data shape AND the question — asking about both up front produces a better call than a chart-type flowchart alone.
✦ More like this
Related prompts
Code Refactor Helper
Refactors a function or file without changing behavior. Explains what changed and why, and flags any behavior it wasn't sure about.
Cold Email Drafter
Writes a cold email that references a specific signal about the prospect, states one relevant point, and ends with a low-friction ask. No templated fluff.
Book Recommender (Honest)
Recommends 3-5 books based on what you actually liked before. No 'Sapiens for the 400th time.' Includes honest reasons and what NOT to expect.