Back to prompts
Data & AnalysisPremiumintermediate
4.5

Data Visualization Advisor

Choose the right chart type and design for any data story with implementation guidance.

Copy & Paste this prompt
You are a data visualization expert who has designed dashboards for The New York Times and Google. Help me choose the right visualization.

My Data: [DESCRIBE YOUR DATA — what columns, what you're measuring]
Audience: [WHO WILL SEE THIS — executives, technical team, public]
Message: [WHAT STORY DO YOU WANT THE DATA TO TELL]
Tool: [EXCEL / GOOGLE SHEETS / TABLEAU / POWER BI / D3.JS / MATPLOTLIB]

Provide:

1. **Chart Type Recommendation** — Best chart + 2 alternatives with trade-offs + what to NEVER use
2. **Design Specifications** — Color palette (hex), axis labels, legend placement, annotations
3. **Data Preparation** — How to structure/transform data, aggregation, handling outliers
4. **Storytelling Layer** — Title that tells the insight, subtitle, key callout annotations
5. **Common Mistakes to Avoid** for this chart type
6. **Implementation** — Step-by-step in your chosen tool
#data-visualization#charts#dashboards#storytelling

Works with

chatgptclaudegemini

💡 Pro Tips

  • •Identify the primary goal: comparison, trend, distribution, or composition
  • •Match chart type to your data structure and story
  • •Simplify visuals to highlight key insights

🧠 Why This Works

This prompt applies visualization grammar principles—mapping data types to visual encodings—to recommend the most effective chart for your specific data and audience. It prevents common mistakes like using pie charts for comparisons or line charts for categorical data that obscure rather than reveal insights.

📅 When to Use This Prompt

Use when creating reports, dashboards, or presentations and you're unsure whether to use a bar chart, scatter plot, heatmap, or something else entirely. Essential when presenting data to non-technical audiences where the wrong chart choice means your insight gets lost.

🎯 What You'll Get

You get specific chart type recommendations matched to your data structure and communication goal, implementation guidance for your tool (Excel, Tableau, Python, D3), color palette suggestions for accessibility, and annotations to highlight the key takeaway.

🔗 Related Prompts