How to Choose the Right Chart
24 chart types. When to use them. When not to. With live examples.
Comparison
Bar Chart
Use when comparing values across categories
Avoid when you have more than 12 items
Mistake y-axis not starting at zero
Grouped Bar Chart
Use when comparing sub-categories side by side
Avoid when you have more than 3 groups
Mistake too many colors making it unreadable
Horizontal Bar Chart
Use when labels are long or you have many categories
Avoid when showing data over time
Mistake not sorting bars by value
Diverging Bar Chart
Use when showing positive vs negative from a baseline
Avoid when all values are on the same side
Mistake not clearly marking the zero line
Trend
Line Chart
Use when tracking a metric over time
Avoid when you have fewer than 5 data points
Mistake plotting too many lines (>5)
Multi-Line Chart
Use when comparing 2-4 trends over time
Avoid when lines overlap too much
Mistake using similar colors for each line
Area Chart
Use when emphasizing magnitude over time
Avoid when comparing two overlapping series
Mistake using with non-continuous data
Stacked Area Chart
Use when showing parts contributing to a total over time
Avoid when individual values matter more than total
Mistake putting volatile series at the bottom
Distribution
Histogram
Use when showing frequency of continuous data
Avoid when data is categorical
Mistake choosing the wrong bin size
Box Plot
Use when comparing spread across groups
Avoid when your audience is non-technical
Mistake ignoring outlier data points
Violin Plot
Use when showing full density shape of data
Avoid when a quick summary is all you need
Mistake not including a median reference line
Composition
Pie Chart
Use when showing 2-5 slices where one dominates
Avoid when slices are similar in size or >5
Mistake adding 3D effects
Donut Chart
Use when same as pie, but wanting a cleaner look
Avoid when comparing two compositions side by side
Mistake making the center hole too small
100% Stacked Bar
Use when comparing composition across groups
Avoid when middle segments are the focus
Mistake using too many segments (>5)
Treemap
Use when showing hierarchical part-to-whole
Avoid when exact comparisons are needed
Mistake too many tiny rectangles
Relationship
Scatter Plot
Use when showing correlation between two variables
Avoid when one variable is categorical
Mistake claiming causation from correlation
Bubble Chart
Use when adding a 3rd dimension via bubble size
Avoid when size differences are subtle
Mistake not including a size legend
Bubble Matrix
Use when showing patterns across 2 categorical dimensions
Avoid when too many rows or columns
Mistake not sorting rows/columns meaningfully
Ranking
Ordered Horizontal Bar
Use when showing a ranked list or leaderboard
Avoid when the ranking is secondary info
Mistake omitting value labels on bars
Lollipop Chart
Use when ranking many items with less visual clutter
Avoid when audience expects traditional bars
Mistake making the circle too large
Slope Chart
Use when showing rank change between 2 time points
Avoid when >2 time points or >8 items
Mistake too many crossing lines
Specialized
Heatmap
Use when showing density or intensity across 2 axes
Avoid when exact values are needed
Mistake using a rainbow color scale
Waterfall Chart
Use when showing incremental changes to a total (e.g. P&L)
Avoid when steps don't form a running total
Mistake unclear increase vs decrease colors
Dual-Axis Line Chart
Use when comparing 2 metrics with different units
Avoid when it risks implying false correlation
Mistake manipulating axis ranges to align lines
Need a custom dashboard?
We build interactive dashboards and data visualizations inside Google Sheets. Your data, beautifully told.
Start a build