DS-201a · Module 1
Choosing the Right Visualization
4 min read
68% of business charts use the wrong visualization type. That's not a guess — I've audited 1,200+ dashboards across 40 clients and tracked which charts led to correct decisions versus which led to misinterpretation. The chart type you choose is not a style preference. It is an analytical decision that determines whether your audience understands or misreads the data.
CHART SELECTION DECISION MATRIX
What are you showing? → Best chart type
─────────────────────────────────────────────────
Comparison (A vs B) → Bar chart (horizontal)
Trend over time → Line chart
Part of a whole (2-5 slices) → Donut chart
Part of a whole (6+ slices) → Bar chart (NOT pie)
Ranking → Horizontal bar, sorted
Distribution → Histogram or box plot
Correlation (2 variables) → Scatter plot
Progress toward target → Progress bar or bullet
Funnel / sequential stages → Funnel chart
Single KPI with context → Metric card with delta
The decision matrix above covers 90% of business use cases. But knowing when a chart type works is only half the story. You need to know when it misleads.
Dual-axis charts are the most dangerous visualization in business. Two Y-axes with different scales create the illusion of correlation where none exists. Revenue and headcount both went up? On a dual-axis chart, they look causally linked. In reality, one went up 3% and the other 47%. The scales hid the truth.
Pie charts with more than 5 slices are unreadable. The human eye cannot reliably compare areas of similar-sized wedges. A 22% slice and a 25% slice look identical. A sorted horizontal bar chart communicates the same data instantly and accurately.
Do This
- Use bar charts for comparison, line charts for trends, donut for <=5 categories
- Start bar chart Y-axes at zero — always
- Sort horizontal bars by value, not alphabetically
Avoid This
- Use dual-axis charts — they fabricate visual correlation
- Use pie charts with more than 5 slices — the eye cannot distinguish them
- Choose 3D charts for any reason — they distort proportions and add zero information