Back to prompts
Data AnalysisChatGPTClaudeGemini

Data Visualization Recommendations

Get expert recommendations on the best chart type, layout, and color choices to communicate your data clearly.

Prompt Template

You are a data visualization expert. Recommend the best way to visualize the following:

Data description: [what the data is]
Key message to communicate: [the insight you want to show]
Audience: [who will see this — executives, data team, customers]
Context: [slide deck / dashboard / report / print]
Tool available: [Tableau / Looker / Excel / Python / Figma / other]
Design constraints: [color scheme, brand colors, accessibility needs]

For each recommendation provide:
1. Chart type and why it's the best choice
2. What goes on each axis / dimension
3. Color scheme recommendation
4. Annotations or callouts to add
5. What to avoid and why
6. A written alt-text description of the ideal final chart

Example Output

Visualization Plan: Monthly Revenue by Product Tier

Primary Chart: Stacked Area Chart

**Why:** Shows total revenue trend AND composition by tier simultaneously. Executive-friendly — one glance communicates both growth and mix shift.

Axes:

- X: Month (Jan–Dec, full year)

- Y: Revenue in USD (start at 0, never truncate)

- Stacks: Starter (light teal) → Pro (medium blue) → Enterprise (dark indigo)

**Color scheme:** Sequential, colorblind-safe. Use brand blues with 40% opacity for stacks. Highlight the most recent month with a vertical reference line.

**Callout to add:** Annotate the month where Enterprise tier crossed 50% of revenue — that's the story.

**Avoid:** Pie charts (terrible for time-series), 3D effects (distort perception), more than 4 color categories (hard to distinguish)

**Alt text:** 'Stacked area chart showing monthly revenue from January to December 2025, broken into three tiers. Total revenue grew from $32K to $127K. Enterprise tier grew from 12% to 53% of revenue mix over the year.'

Tips for Best Results

  • 💡Always start your Y-axis at zero for bar and area charts — truncated axes are the most common chart lie
  • 💡Ask 'what's the one thing I want the viewer to remember?' and design around that — every element should serve that message
  • 💡Test your color scheme with a colorblindness simulator — 8% of men have red-green color blindness

Try it with

ChatGPTClaudeGemini

Related Prompts

Data Analysis

Dashboard KPI Definition Framework

Define the right KPIs for your business dashboard with clear formulas, targets, and data sources.

ChatGPTClaudeGemini
Data Analysis

SQL Query Writer for Business Reports

Generate SQL queries for common business reporting needs — revenue trends, cohort analysis, funnel metrics, and more.

ChatGPTClaude
Data Analysis

Dataset Summary and Insights

Paste or describe a dataset and get an instant summary of key statistics, patterns, anomalies, and actionable insights.

ChatGPTClaudeGemini