Choose the Right Chart Type for Your Data
Recommends the best and runner-up chart type for your message, variables, and audience with encoding guidance.
Picking a chart is a decision about your message, not your data, and that is the part people skip. A line chart, a bar chart, and a slope chart can all show the same two numbers, but each tells a different story about trend, comparison, or change. This prompt makes you state the message first, then matches an encoding to it, which is the order good data viz actually follows. Feeding it the variable types and how many categories you have rules out the classic blunders fast: pie charts that become unreadable past three slices, dual axes that imply correlations that are not there, line charts on categorical data. The runner-up suggestion is useful because the best chart for accuracy is not always the best for a board deck, and you get to choose with the tradeoff in front of you. Use it before building anything, especially when you feel tempted to reach for whatever your tool offers by default.
You are a data visualization expert. Recommend the single best chart type for the situation below, plus one runner-up. Context: What I want the audience to understand: [MESSAGE] Variables involved: [VARIABLES AND TYPES] Number of categories or series: [CARDINALITY] Audience: [AUDIENCE] Medium: [MEDIUM] For your top pick, explain in 2-3 sentences why it fits this message and data type, what to put on each axis or encoding (color, size, position), and one common mistake to avoid with it. Then name the runner-up and when it would be better. Do not suggest pie charts for more than three categories or dual-axis charts unless I explicitly need correlation. Keep it concise and decision-ready.
What you can expect back
Top pick: a multi-series line chart. Time goes on the x-axis, signups on the y-axis, and each of the five channels is one colored line, so the audience reads the overall trend and the April inflection at a glance while still seeing which channel drove the jump. Mistake to avoid: five lines can tangle, so mute the minor channels to gray and highlight only the one or two that matter, and add a vertical annotation at the launch date. Runner-up: a stacked area chart. Choose it instead if the story is about total volume and channel mix over time rather than comparing individual channel trajectories, but skip it if executives need to track any single channel precisely, since stacked baselines make exact reading hard.
Illustrative example — your results will vary by tool and inputs.
Get sharper results
- 01Lead with the verb in your message, grew, compared, distributed, related, it maps almost directly to chart families.
- 02If you have more than five series, ask for a small-multiples layout instead of cramming them onto one chart.
- 03Tell it the medium honestly; dense interactive charts fail on a projected slide where people have ten seconds.
- 04Ask for one annotation suggestion; a single callout often does more than the chart choice itself.
Adapt it for your case
Describe or paste the chart you already made and ask whether the type fits the message and how to fix it.
Add 'flag color-blind-safe palettes and label placement' to make the recommendation inclusive.
Append your tool, e.g. 'give steps to build this in Tableau or matplotlib'.
Common questions
Why does it refuse to give me a pie chart?
The prompt blocks pie charts above three categories because humans compare angles poorly; for more slices a bar chart is almost always clearer.
Can it just pick for me?
Yes, it commits to a single top choice, the runner-up is only there so you can override based on the deck versus accuracy tradeoff.
What if my message is unclear?
Then the chart will be too; write the one-sentence takeaway first, and if you cannot, that is a signal to rethink what the data shows before visualizing it.
You may also need
Interpret an A/B Test Result Without Overclaiming
Interprets A/B test numbers honestly, flags validity risks, and gives a ship or keep-running recommendation.
Write a Precise, Unambiguous Metric Definition
Produces a precise metric definition with formula, grain, inclusion rules, and resolved edge cases.
Write a Dashboard Spec Before You Build It
Drafts a build-ready dashboard spec with KPIs, layout, filters, drill-downs, and out-of-scope guardrails.
Explain a Statistical Concept to Non-Technical Stakeholders
Translates a statistical concept into a plain-language explanation tied to a real decision for non-technical stakeholders.