The Data Drop / Chart Guide

How to Choose the Right Chart

24 chart types. When to use them. When not to. With live examples.

Comparison

Comparison

Bar Chart

Use when comparing values across categories

Avoid when you have more than 12 items

Mistake y-axis not starting at zero

Build this for your data →
Comparison

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

Build this for your data →
Comparison

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

Build this for your data →
Comparison

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

See live demo →

Trend

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)

Build this for your data →
Trend

Multi-Line Chart

Use when comparing 2-4 trends over time

Avoid when lines overlap too much

Mistake using similar colors for each line

Build this for your data →
Trend

Area Chart

Use when emphasizing magnitude over time

Avoid when comparing two overlapping series

Mistake using with non-continuous data

Build this for your data →
Trend

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

Build this for your data →

Distribution

Distribution

Histogram

Use when showing frequency of continuous data

Avoid when data is categorical

Mistake choosing the wrong bin size

Build this for your data →
Distribution

Box Plot

Use when comparing spread across groups

Avoid when your audience is non-technical

Mistake ignoring outlier data points

Build this for your data →
Distribution

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

Build this for your data →

Composition

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

Build this for your data →
Composition

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

Build this for your data →
Composition

100% Stacked Bar

Use when comparing composition across groups

Avoid when middle segments are the focus

Mistake using too many segments (>5)

Build this for your data →
Composition

Treemap

Use when showing hierarchical part-to-whole

Avoid when exact comparisons are needed

Mistake too many tiny rectangles

Build this for your data →

Relationship

Relationship

Scatter Plot

Use when showing correlation between two variables

Avoid when one variable is categorical

Mistake claiming causation from correlation

Build this for your data →
Relationship

Bubble Chart

Use when adding a 3rd dimension via bubble size

Avoid when size differences are subtle

Mistake not including a size legend

Build this for your data →
Relationship

Bubble Matrix

Use when showing patterns across 2 categorical dimensions

Avoid when too many rows or columns

Mistake not sorting rows/columns meaningfully

See live demo →

Ranking

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

Build this for your data →
Ranking

Lollipop Chart

Use when ranking many items with less visual clutter

Avoid when audience expects traditional bars

Mistake making the circle too large

Build this for your data →
Ranking

Slope Chart

Use when showing rank change between 2 time points

Avoid when >2 time points or >8 items

Mistake too many crossing lines

Build this for your data →

Specialized

Specialized

Heatmap

Use when showing density or intensity across 2 axes

Avoid when exact values are needed

Mistake using a rainbow color scale

Build this for your data →
Specialized

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

Build this for your data →
Specialized

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

Build this for your data →

Need a custom dashboard?

We build interactive dashboards and data visualizations inside Google Sheets. Your data, beautifully told.

Start a build
Buy me a coffee