Good Data, Bad Chart: Why Mistakes Still Happen
Data visualization mistakes don't usually come from bad intentions — they come from default settings, habit, and not knowing what to look for. The good news: most common mistakes are easy to fix once you know what they are. Here are ten of the most damaging errors, with practical fixes for each.
1. Truncating the Y-Axis
The mistake: Starting the value axis at something other than zero (e.g., starting at 95 to make a small change look dramatic).
The fix: Always start bar and column chart axes at zero. For line charts showing relative change, truncation can be acceptable — but label it clearly and add a note explaining the axis range.
2. Using Pie Charts with Too Many Slices
The mistake: A pie chart with 8, 10, or 12 slices. Human perception cannot accurately compare angles and arc lengths beyond about 5 categories.
The fix: Limit pie charts to 5 or fewer slices. Group smaller categories into an "Other" segment. Better yet, switch to a horizontal bar chart — it's almost always more readable.
3. Rainbow Color Schemes
The mistake: Assigning a different color to every data point or series without a meaningful reason — just to make the chart "colorful."
The fix: Use color deliberately. One color for a single series. Use color variation to show categorical differences or to highlight a specific data point. Ensure your palette is accessible to colorblind readers (avoid red/green pairs).
4. Missing or Vague Labels
The mistake: A chart with no axis labels, no units, or a title like "Chart 1." The viewer has no idea what they're looking at.
The fix: Every chart needs a descriptive title, labeled axes with units, and a data source note. The title should state the insight, not just the topic: "Q3 Revenue Up 18% Year-Over-Year" beats "Q3 Revenue."
5. Using 3D Charts
The mistake: Adding depth to pie charts, bar charts, or line charts for visual impact. 3D distorts proportions and makes accurate reading nearly impossible.
The fix: Always use 2D charts. There is no data visualization scenario where a 3D effect improves comprehension. It only reduces it.
6. Overloading a Single Chart
The mistake: Trying to show too many metrics, too many series, or too many time periods in one chart. Complexity doesn't signal sophistication — it signals confusion.
The fix: Each chart should answer one question. Split complex charts into small multiples (a grid of simple charts) or use focused, separate charts for each insight.
7. Ignoring Data-Ink Ratio
The mistake: Heavy grid lines, thick borders, background fills, drop shadows, and decorative elements that add visual noise without adding information.
The fix: Remove anything that doesn't carry data. Light gray grid lines, no borders on bars, minimal tick marks. Let the data be the most prominent element on the page.
8. Inconsistent Scales Across Multiple Charts
The mistake: Placing two charts side by side that are meant to be compared, but with different axis scales. The visual comparison becomes invalid.
The fix: Whenever two or more charts are meant to be compared directly, use identical axis scales. Many dashboard tools can sync axes across panels automatically.
9. Using Area Charts for Multiple Overlapping Series
The mistake: Filling the area under multiple lines in a chart with several series. The overlapping fills create a confusing, layered mess.
The fix: For multiple series, use a line chart. Reserve area charts for single series or properly stacked data where parts sum to a total.
10. No Context or Benchmark
The mistake: Showing a metric in isolation with no target, historical average, or comparison point. A 12% conversion rate means nothing without context.
The fix: Add reference lines for targets, averages, or prior-period comparisons. Context transforms a data point into an insight. Add annotations to explain significant spikes or drops.
The Underlying Principle
Every mistake on this list shares a root cause: the chart designer prioritized aesthetics or convenience over the reader's understanding. Great data visualization is an act of communication. Every design decision should make the message clearer, not more impressive. When in doubt, simplify.