Chapter 18

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:

  1. What is my message? What specific insight do I want to communicate?
  2. What type of data do I have? Categorical? Numerical? Time series?
  3. What comparison am I making? Categories? Trends? Relationships? Parts of whole?

Decision Framework Flow

Step 1: Start Here

What do I want to show?

↓
Step 2: Consider

What data do I have?

↓
Step 3: Ask

What comparison makes sense?

↓
Step 4: Result

2-3 chart options that fit

↓
Step 5: Choose

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
⚠️ Common Data-Chart Mismatch:
  • 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.

Color Blind Safe Palettes:
  • 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
Resist the Temptation to Impress

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?