Choosing the Right Visualization
Master the decision framework for visualization selection
π― Learning Objectives
Decision Framework
Master the systematic approach to choosing the right visualization
Message-First Thinking
Start with your message to select the perfect chart type
Data Type Matching
Match your data structure to the appropriate visualization
Best Practices
Apply accessibility, simplicity, and effectiveness principles
π§ The Visualization Decision Framework
Choosing the right visualization isn't about picking what looks prettyβit's about effectively communicating your message. Use this three-question framework:
Three Key Questions:
- What is my message? What specific insight do I want to communicate?
- What type of data do I have? Categorical? Numerical? Time series?
- What comparison am I making? Categories? Trends? Relationships? Parts of whole?
Decision Framework Flow
What do I want to show?
What data do I have?
What comparison makes sense?
2-3 chart options that fit
The simplest, clearest option
π¬ Message-First Approach
Always start with: "I want to show..." Your message determines your chart.
"I want to show how things changed over time"
Best choices:
- π Line chart - for precise trends
- π Area chart - for magnitude over time
- π Column chart - for discrete time periods
Example: "Monthly sales revenue for the past year"
"I want to show which category is largest"
Best choices:
- π Bar chart - horizontal comparison
- π Column chart - vertical comparison
Example: "Sales by product category"
"I want to show the relationship between two variables"
Best choice:
- π΅ Scatter plot - correlation between numerical variables
Example: "Advertising spend vs. sales revenue"
"I want to show parts of a whole"
Best choices:
- π₯§ Pie chart - for few categories (2-5)
- π Stacked bar - for many categories or comparison
- π³ Treemap - for hierarchical data
Example: "Market share by company"
"I want to show distribution of values"
Best choice:
- π Histogram - frequency distribution
- π¦ Box plot - quartiles and outliers
Example: "Distribution of customer ages"
"I want to show progression through stages"
Best choice:
- π» Funnel chart - conversion through stages
Example: "Website visitor to customer conversion"
"I want to show how we got from A to B"
Best choice:
- π§ Waterfall chart - incremental changes
Example: "How profit changed from Q1 to Q2"
"I want to show patterns across two dimensions"
Best choice:
- π₯ Heatmap - intensity across grid
Example: "Website traffic by day and hour"
π Data Type Considerations
Your data structure heavily influences which charts will work. Match your data pattern to the right visualization:
| Data Pattern | Description | Best Chart Types | Example |
|---|---|---|---|
| 1 Categorical + 1 Numerical | Categories with associated values | Bar chart, Column chart | Sales by product |
| Time + 1 Numerical | Values changing over time | Line chart, Area chart | Revenue by month |
| 1 Categorical (Proportions) | How categories split a total | Pie chart, Donut chart | Market share |
| 2 Numerical | Relationship between variables | Scatter plot | Height vs. Weight |
| 1 Numerical (Distribution) | How values are spread | Histogram, Box plot | Age distribution |
| Sequential Process | Flow through ordered stages | Funnel, Waterfall | Conversion funnel |
| 2 Categorical + 1 Numerical | Values across two dimensions | Heatmap, Grouped bar | Sales by region & quarter |
- Using pie charts for >5 categories (hard to compare)
- Using bar charts for time series (line is better)
- Using scatter plots for categorical data (won't work)
- Using area charts for negative values (confusing)
π Comparison Type Guide
What kind of comparison are you making? Different comparisons need different charts.
1. Comparing Categories
Goal: Which category has the highest/lowest value?
Best charts: Bar chart, Column chart
Why: Humans compare lengths better than angles or areas
Example: "Which product sold the most units?"
2. Comparing Over Time
Goal: How did values change across time periods?
Best charts: Line chart, Area chart
Why: Continuous lines show trends clearly
Example: "How have our sales trended this year?"
3. Comparing Parts of a Whole
Goal: What proportion does each part represent?
Best charts: Pie chart (few parts), Stacked bar (many parts), 100% Stacked area
Why: Shows how pieces sum to 100%
Example: "What percentage of revenue comes from each region?"
4. Comparing Distributions
Goal: How are values spread? Where are clusters and outliers?
Best charts: Histogram, Box plot
Why: Shows shape of data distribution
Example: "What's the typical customer age range?"
5. Comparing Relationships
Goal: Is there a correlation between two variables?
Best charts: Scatter plot
Why: Each point shows X-Y relationship
Example: "Does ad spending correlate with sales?"
π Master Visualization Selection Chart
Your comprehensive reference guide for choosing charts:
| Purpose | Data Requirements | Best Charts | When to Use | Example Scenario |
|---|---|---|---|---|
| Show Trend | Time + Numerical | Line, Area | Tracking changes over continuous time | Stock price over 6 months |
| Compare Categories | Categorical + Numerical | Bar, Column | Ranking or comparing discrete groups | Sales by product line |
| Show Composition | Parts of whole | Pie, Stacked bar, Treemap | Displaying proportions that sum to 100% | Market share by company |
| Show Distribution | Single numerical variable | Histogram, Box plot | Understanding spread and frequency | Age distribution of customers |
| Show Relationship | Two numerical variables | Scatter plot | Exploring correlation between variables | Marketing spend vs. revenue |
| Show Process/Flow | Sequential stages | Funnel, Sankey | Visualizing conversion or flow through steps | Website visitor β customer funnel |
| Show Changes | Starting value + increments | Waterfall | Breaking down how total changed | Profit bridge from Q1 to Q2 |
| Show Patterns | 2 categorical + 1 numerical | Heatmap | Finding intensity patterns across grid | Website traffic by day & hour |
π οΈ Interactive Chart Selector Tool
Answer a few questions to get chart recommendations:
Chart Recommendation Tool
π Multiple Charts for the Same Data
The same dataset can be visualized differently depending on your message. Each chart answers a different question.
Example: Quarterly Sales Data for 3 Products
Dataset: Q1-Q4 sales for Product A, B, and C
Question 1: "How do total sales trend across quarters?"
Answer: Use a Line chart showing total sales by quarter
Insight: "Sales increased 15% from Q1 to Q4"
Question 2: "Which product sells the most?"
Answer: Use a Bar chart comparing total sales by product
Insight: "Product A accounts for 45% of total sales"
Question 3: "What's each product's contribution to total revenue?"
Answer: Use a Stacked area chart showing all products over time
Insight: "Product C is growing while A is stable and B is declining"
Question 4: "Is there a relationship between price and quantity sold?"
Answer: Use a Scatter plot with price on X, quantity on Y
Insight: "Higher prices correlate with lower quantities (negative correlation)"
Key Lesson: Your question/message determines the chart, not the data. Always start with "What do I want to show?" before choosing a visualization.
π When to Use Multiple Visualizations
Sometimes one chart isn't enough. Use multiple visualizations when:
π± Building Dashboards: Dashboards need multiple charts to provide a complete overview. Combine trend lines, comparison bars, and key metrics. Example: Sales dashboard with revenue trend (line), top products (bar), regional breakdown (map)
π Comprehensive Reports: Reports tell a complete story that requires multiple perspectives on the data. Example: Annual report with growth trends, market share, geographic distribution, and financial breakdown
π Telling a Data Story: Guide your audience through insights using a sequence of visualizations. Example: Start with the big picture (trend), zoom into details (comparison), then show composition (stacked)
π¨ Chart Combinations That Work Well
Line + Bar (Combo Chart)
Use when: Comparing values at different scales
Example: Sales volume (bars) + Profit margin % (line)
Why it works: Dual axes let you show related metrics with different magnitudes
Multiple Small Charts (Small Multiples)
Use when: Comparing patterns across many categories
Example: Sales trends for 12 different products, each in its own mini chart
Why it works: Easy to spot differences and outliers
Heatmap + Bar (Marginal Totals)
Use when: Showing both grid patterns and totals
Example: Heatmap of sales by region & product + bars showing total by region
Why it works: Combines detail view with summary
Map + Chart
Use when: Geographic data with additional metrics
Example: Sales map + pie chart showing product mix per region
Why it works: Location context plus detailed breakdown
β Common Selection Mistakes
Learn from these frequent errors in chart selection:
β Mistake: Using pie chart when bar chart is better
Problem: Pie with 8+ slices is hard to compare
Fix: Use horizontal bar chart instead - length is easier to compare than
angles
When pie IS okay: 2-5 categories with clear differences
β Mistake: Using bar chart when line chart is better
Problem: Time series shown with bars creates false discrete impression
Fix: Use line chart to show continuous trend over time
When bar IS okay: Comparing distinct time periods (e.g., annual totals)
β Mistake: Using complex chart when simple would work
Problem: 3D exploded pie chart with gradients for 3 simple values
Fix: Use simple flat pie or bar chart
Rule: Complexity should match data complexity, not exceed it
β Mistake: Wrong chart for data type
Problem: Scatter plot for categorical data, or pie chart for negative
values
Fix: Match chart requirements to your data structure
Check: Review the data type table in this chapter
β Mistake: Dual-axis charts with unrelated metrics
Problem: Two Y-axes with arbitrary scaling can mislead
Fix: Only use dual-axis when metrics are genuinely related
Example OK: Revenue (left) + Profit margin % (right)
βΏ Accessibility Considerations
Make your visualizations accessible to everyone:
π¨ Don't rely only on color: Use patterns, shapes, or labels in addition to color. About 8% of men have color blindness. Good: Line chart with different line styles (solid, dashed, dotted) + colors. Bad: Only using red vs. green to distinguish series
π Provide clear labels and legends: Every chart needs a descriptive title, axis labels with units, and legend when needed. Example: "Monthly Revenue (USD)" not just "Revenue"
π¬ Include alt text descriptions: For digital charts, provide text describing the key insight for screen readers. Example: "Line chart showing revenue increased from $10k in Jan to $25k in Dec, a 150% growth"
π€ Use readable font sizes: Minimum 10pt for printed, 12px for digital. Avoid light gray on white backgrounds.
- Use blue + orange instead of red + green
- Use purple + yellow for strong contrast
- Test with color blindness simulators online
π Cultural and Context Considerations
Color Meanings Vary by Culture:
- Red: Danger/stop in Western cultures, good luck/prosperity in Chinese culture
- White: Purity in Western cultures, mourning in some Asian cultures
- Green: Go/positive in most cultures, but sacred in Islam
Best practice: When presenting globally, use neutral colors or provide context
Familiarity with Chart Types:
- Universal: Bar, line, pie charts are understood worldwide
- Advanced: Waterfall, funnel, treemap may need explanation
- Context: Match complexity to audience expertise
Industry Standards:
- Finance: Candlestick charts for stocks, waterfall for financial statements
- Healthcare: Control charts, survival curves
- Marketing: Funnel charts for conversion
Tip: Use industry-standard charts when communicating with domain experts
β¨ The Simplicity Principle
Core Rule: Simpler is Usually Better
The best visualization is the simplest one that clearly communicates your message.
β Signs You've Chosen Right:
- Insight is immediately obvious
- No explanation needed
- Audience says "I see!" not "What am I looking at?"
- Chart enhances understanding, doesn't just look pretty
β Signs You've Overcomplicated:
- Need 5 minutes to explain the chart
- Multiple legends and annotations needed
- More than 3 variables on one chart
- Chosen advanced chart when simple would work
Don't use an advanced chart type just because it looks sophisticated. A clear bar chart beats a confusing radar chart every time. Your goal is communication, not decoration.
π Quick Reference Guide
Your one-page cheat sheet for chart selection:
| Chart Type | When to Use | Data Needed | Quick Example |
|---|---|---|---|
| Bar | Compare categories | Categories + Numbers | Sales by product |
| Column | Compare categories or time periods | Categories/Time + Numbers | Quarterly revenue |
| Line | Show trends over time | Time + Numbers | Stock price trend |
| Pie | Parts of whole (2-5 parts) | Categories + Proportions | Market share |
| Area | Volume/magnitude over time | Time + Numbers | Cumulative users |
| Scatter | Show correlation | 2 numerical variables | Ad spend vs. sales |
| Histogram | Show distribution | 1 numerical variable | Age distribution |
| Funnel | Conversion through stages | Sequential stages | Sales pipeline |
| Waterfall | Incremental changes | Starting + changes | Profit bridge |
| Heatmap | Patterns across 2D grid | 2 categorical + 1 numerical | Traffic by day/hour |
π― Practice: The Chart Selection Challenge
Test your skills with these real-world scenarios. Choose the best chart and explain why.
Scenario 1: Product Performance
Data: You have total sales for 8 different products
Goal: Show which products are top performers
Question: What chart should you use?
Show Answer
Best choice: Horizontal Bar Chart
Why:
- Comparing categories (products)
- 8 products = horizontal bars better than vertical (easier to read labels)
- Can sort by value to clearly show ranking
Alternative OK: Column chart if product names are short
Avoid: Pie chart (too many slices to compare)
Scenario 2: Website Traffic Patterns
Data: Hourly website visitors for each day of the week (7 days Γ 24 hours)
Goal: Find when traffic is highest/lowest
Question: What chart should you use?
Show Answer
Best choice: Heatmap
Why:
- Two categorical dimensions (day + hour)
- Numerical value (visitor count)
- Color intensity quickly reveals patterns
- 168 data points (7Γ24) - too many for other charts
Alternative: Small multiples (7 line charts, one per day)
Scenario 3: Customer Age Distribution
Data: Ages of 5,000 customers (ranging from 18 to 75)
Goal: Understand the typical age range and identify any clusters
Question: What chart should you use?
Show Answer
Best choice: Histogram
Why:
- Single numerical variable (age)
- Shows distribution/frequency
- Bins reveal clusters (e.g., many 25-35 year olds)
- Can see if distribution is normal, skewed, or bimodal
Alternative: Box plot (shows median, quartiles, outliers)
Avoid: Bar chart of individual ages (too many bars)
Scenario 4: Revenue Growth Over Year
Data: Monthly revenue for the past 12 months
Goal: Show the overall growth trend
Question: What chart should you use?
Show Answer
Best choice: Line Chart
Why:
- Time series data (months)
- Continuous trend visualization
- Easy to see if growing, declining, or stable
- Can spot seasonal patterns
Alternative: Area chart (if emphasizing total magnitude)
Avoid: Bar chart (makes continuous trend look discrete)
Scenario 5: Market Share by Company
Data: Market share percentages for 4 major companies
Goal: Show how the market is divided
Question: What chart should you use?
Show Answer
Best choice: Pie Chart or Donut Chart
Why:
- Parts of a whole (sums to 100%)
- Only 4 categories (manageable for pie)
- Proportions are the message
- Familiar format for market share
Alternative: 100% stacked bar (easier to compare if shares are similar)
OK here: Pie works because few categories with clear differences
Scenario 6: Conversion Funnel
Data: 10,000 visitors β 5,000 signups β 1,000 trials β 300 customers
Goal: Show drop-off at each stage
Question: What chart should you use?
Show Answer
Best choice: Funnel Chart
Why:
- Sequential process through stages
- Narrowing shape visually represents drop-off
- Industry standard for conversion analysis
- Easy to identify biggest drop-off points
Alternative: Horizontal bar chart (shows same data, less visual metaphor)
Shows: 50% signup rate, 20% trial rate, 30% trial-to-customer rate
Scenario 7: Profit Changes Breakdown
Data: Q1 profit $100k, +$30k from new customers, -$10k from costs, +$5k from price increase = Q2 profit $125k
Goal: Show how we got from $100k to $125k
Question: What chart should you use?
Show Answer
Best choice: Waterfall Chart
Why:
- Shows starting value + incremental changes
- Visually "walks" from start to end
- Positive changes float up, negative float down
- Perfect for profit bridges, variance analysis
Shows: Each component's contribution to total change
Common in: Finance, accounting, business analysis
Scenario 8: Employee Satisfaction vs. Tenure
Data: For 200 employees, you have years at company and satisfaction score (1-10)
Goal: See if longer tenure correlates with higher/lower satisfaction
Question: What chart should you use?
Show Answer
Best choice: Scatter Plot
Why:
- Two numerical variables (years, score)
- Exploring correlation/relationship
- Each dot = one employee
- Can add trend line to show correlation direction
Potential insights: Negative correlation (satisfaction drops with tenure), positive, or no pattern
Avoid: Bar chart (can't show individual relationships)
π Knowledge Check
Test your mastery of visualization selection with instant feedback!
1. What should be your FIRST consideration when choosing a visualization?
2. You have hourly website traffic data for each day of the week. Which chart is BEST for finding patterns?
3. When is a pie chart the BEST choice?
4. What's a key principle for accessible visualizations?
5. You want to show how quarterly profit changed from $100k to $125k through specific factors. Which chart?
6. What does the "Simplicity Principle" in visualization mean?
7. You have data for two numerical variables and want to explore if they're correlated. Which chart?
8. What's the most common mistake when using bar charts for time series data?
9. You need to show how monthly revenue is distributed across 4 regions. Which chart type is best?
10. What is the "5-second rule" in data visualization?