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