How to Choose the Right Chart Type for Your Data
Choose a chart by deciding what the reader should see first (a comparison, a trend, a distribution, a relationship, or parts of a whole) and then using the chart built for that job, such as a bar chart for comparing categories or a line chart for change over time. If no chart clearly fits, use a bar chart, which works for most comparisons and is hard to misread.
Quick answer: Match the chart to the question. Comparing categories: bar chart (horizontal if the labels are long). Change over time: line chart. Distribution of one variable: histogram, or box plots to compare groups. Relationship between two numeric variables: scatter plot. Parts of a whole: pie chart only for 2-5 slices, otherwise a bar chart; parts of a whole over time: stacked area chart. When unsure, use a bar chart sorted by value.
Which Chart Type Should You Use for Each Goal?
Pick the chart by the job it has to do: bars compare categories, lines show change over time, histograms and box plots show distributions, scatter plots show relationships, and pies or stacked areas show parts of a whole.
1. Comparing Values โ Bar Chart
Use when: Comparing quantities across categories
Examples: Sales by region, revenue by product, count by department
Why it works: Humans easily compare bar lengths
โ
Good: Horizontal bar chart (easier to read long labels)
โ Avoid: 3D bars, too many categories (>15)
2. Showing Trends Over Time โ Line Chart
Use when: Continuous data over time periods
Examples: Revenue over months, website traffic over days, stock prices
Why it works: Shows direction and rate of change clearly
Axis rule: A line chart doesn't need a zero baseline, because it encodes value by position and slope rather than length. Label the axis range clearly instead. See line chart best practices.
โ
Good: Label the y-axis range so readers can judge the change
โ Avoid: More than 4 lines (use small multiples instead)
3. Showing Proportions โ Pie Chart (Use Sparingly!)
Use when: Parts of a whole (must add to 100%)
Examples: Market share, budget breakdown by category
Limitations:
- Only use for 2-5 categories max
- Humans are bad at comparing angles
- Often a bar chart is better!
โ
Good: 3 clear segments
โ Avoid: 10+ tiny slices, 3D pie charts, exploded slices
4. Showing Distribution โ Histogram or Box Plot
Histogram: See shape of distribution
Box plot: See median, quartiles, outliers
Examples: Age distribution, salary ranges, test scores
Histogram: Shows if data is normal, skewed, bimodal
Box plot: Great for comparing distributions across groups
5. Showing Relationships โ Scatter Plot
Use when: Exploring correlation between two variables
Examples: Price vs sales, age vs income, ad spend vs revenue
Why it works: Reveals patterns, clusters, outliers
โ
Add trendline to show correlation
โ
Color points by category for extra dimension
6. Showing Part-to-Whole Over Time โ Stacked Area Chart
Use when: Multiple categories summing to a total, over time
Examples: Revenue by product line over years, traffic sources over months
Warning: Hard to compare middle segments. Only use for general trends.
What Is a Quick Decision Tree for Choosing a Chart?
Start from the question you want the chart to answer: "How do categories compare?" means a bar chart, "How has this changed over time?" means a line chart, "Is there a relationship?" means a scatter plot, and "Where are the outliers?" means a box plot or scatter plot. The table below covers the common cases.
| Your Question | Chart Type |
|---|---|
| How do categories compare? | Bar chart |
| How has this changed over time? | Line chart |
| What's the breakdown? | Pie chart (2-5 items) or Bar chart |
| What's the distribution? | Histogram or Box plot |
| Is there a relationship? | Scatter plot |
| How do parts change over time? | Stacked area chart |
| Where are the outliers? | Box plot or Scatter plot |
What Are the Most Common Chart Selection Mistakes?
The most common mistakes are pie charts with too many slices, 3D effects, careless dual y-axes, too many colors, unlabeled axes, and bar charts whose y-axis doesn't start at zero. Each one makes the comparison harder to read or distorts it, and each has a simple fix.
- โ Pie chart with 10+ slices โ Use bar chart instead
- โ 3D charts โ Distort perception, use 2D
- โ Dual Y-axes โ Can mislead, use with caution
- โ Too many colors โ Stick to 5-7 max
- โ Not labeling axes โ Always include units!
- โ Misleading Y-axis scales โ Start at 0 for bar charts
The "When in Doubt" Rule
If you can't decide, use a bar chart, sorted by value unless the categories have a natural order such as months. It is the safest default for most comparisons; see when to use a bar chart for the details.
- โ Easy to understand
- โ Works for most comparisons
- โ Harder to mess up than pie charts
- โ Accessible (colorblind-friendly if properly designed)
Golden Rule: Choose the chart that requires the least mental effort from your audience. If they have to study it for 10 seconds to understand, try a different chart type.