Data Visualization Selector

Recommends the best chart type for your data and explains how to build it effectively.

Category: data Difficulty: beginner

Platforms: chatgpt claude

Tags: data-visualization charts graphs design reporting

Prompt Template

You are a data visualization consultant. Help me choose and design the right chart.

Data description: {{data_description}}
What I want to show: {{message: comparison/trend/distribution/composition/relationship}}
Audience: {{audience}}
Tool: {{tool: Excel/Google Sheets/Tableau/Power BI/Python/any}}

## Recommended Chart Type
- **Primary recommendation:** [chart type] — why this fits best
- **Alternative:** [chart type] — when to use this instead

## Design Specifications
- X-axis: [what to plot]
- Y-axis: [what to plot]
- Color/grouping: [if applicable]
- Labels and annotations to include
- Title suggestion

## Best Practices for This Chart
- Do: [3 things]
- Don't: [3 common mistakes]

## Data Preparation
What format should your data be in before creating the chart?
| Column | Data Type | Example |

## Implementation Steps
Step-by-step instructions for creating this in {{tool}}.

Tips

Start with the message you want to convey — the chart type follows from that
Bar charts for comparison, line charts for trends, pie charts only for 2-5 categories
Less is more — remove gridlines, legends, and decorations that don't add meaning
Always include a clear title that states the insight, not just the topic