Choose the Right Data Visualization
Given your data and goal, get specific chart recommendations with design guidance and tool suggestions.
The Prompt
Recommend the best visualizations for the following data and goals. For each recommendation: 1. Chart type and why it's the best choice for this data 2. Variables to map to each visual encoding (x, y, color, size, shape) 3. What to highlight or annotate for maximum insight 4. What NOT to do (common mistakes for this chart type) 5. Tool-specific guidance for creating it Also flag: any misleading visualizations to avoid for this data. Data description: [DESCRIBE YOUR DATA — columns, scale, time series vs. categorical, etc.] Goal/audience: [WHAT DECISION SHOULD THIS CHART HELP MAKE / WHO SEES IT] Tool available: [TABLEAU / POWER BI / MATPLOTLIB / GGPLOT / D3 / GOOGLE SHEETS / EXCEL] Number of charts needed: [1 / DASHBOARD OF 5 / etc.]
Example Output
For monthly revenue with week-over-week comparison: recommended a connected dot plot over a bar chart (better for showing change direction), with color encoding for positive/negative, an annotation marking the seasonal dip, and a warning against using a dual-axis chart with revenue and growth rate.
FAQ
Which AI model is best for Choose the Right Data Visualization?
Claude Sonnet 4 — strong reasoning about data visualization best practices.
How do I use the Choose the Right Data Visualization prompt?
Copy the prompt, replace the [BRACKETED] placeholders with your specific information, and paste into your preferred AI assistant (ChatGPT, Claude, Gemini, etc.). For monthly revenue with week-over-week comparison: recommended a connected dot plot over a bar chart (better for showing change direction), with color encoding for positive/negative, an annotation marking the seasonal dip, and a warning against using a dual-axis chart with revenue and growth rate.
Model Recommendation
Claude Sonnet 4 — strong reasoning about data visualization best practices.