惯性聚合 高效追踪和阅读你感兴趣的博客、新闻、科技资讯
阅读原文 在惯性聚合中打开

推荐订阅源

博客园 - 三生石上(FineUI控件)
博客园 - Franky
GbyAI
GbyAI
B
Blog
WordPress大学
WordPress大学
D
Docker
小众软件
小众软件
月光博客
月光博客
博客园 - 【当耐特】
T
The Blog of Author Tim Ferriss
IT之家
IT之家
腾讯CDC
Engineering at Meta
Engineering at Meta
Vercel News
Vercel News
H
Help Net Security
M
MIT News - Artificial intelligence
L
LangChain Blog
云风的 BLOG
云风的 BLOG
S
SegmentFault 最新的问题
freeCodeCamp Programming Tutorials: Python, JavaScript, Git & More
美团技术团队
让小产品的独立变现更简单 - ezindie.com
让小产品的独立变现更简单 - ezindie.com
V
V2EX
OSCHINA 社区最新新闻
OSCHINA 社区最新新闻

The Data Drop

The Lives of Great Hotels The Houseplant Atlas A running list of self-hosted apps, and what they replace Player One — Fifty Years of Video Game Heroes Semicolon | The Data Drop No one introduced us The Costume Contest, Re-Voted What we can Indian Railways, 1853–2026: The Full History, Drawn When we ask how to help Day One with Fable Every Starlink, orbiting now You've Got a Friend in Me: Before Toy Story 5, One Last Goodbye A Day in the Life of ChatGPT World Cup 2026 Roland-Garros highlights, point by point The Boring Truth About Passive Income The Anatomy of 1:59:30 I'm not a robot. (They already know.) Inside Every iPhone Celebrating Doodles Save the Date: Every WWDC Invitation, 1990 to 2026 Ryanair's Roast iPhone ads are a masterclass. Slurp. A Video Museum of Ramen. Station Melodies of Greater Tokyo The London Public Houses Royal Pop Resale Prices: AP × Swatch StockX, eBay, 4-Year Data Every ChatGPT · Seven eras of the chatbot that changed everything Power On · Iconic boot chimes from 1977 to today
How to Choose the Right Chart: 24 Types with Live Examples
sheets.works · 2026-03-04 · via The Data Drop

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