Useful Data Tips

Line Chart Best Practices

⏱️ 30 sec read 📊 Visualization

Line charts show trends over time better than any other visualization. But small design choices dramatically affect how people interpret your data. Here's how to get them right.

1. When to Use Line Charts

✅ Perfect For:

❌ Wrong Choice For:

2. The Y-Axis Controversy: To Zero or Not to Zero?

This is the most debated question in line charts. The answer: it depends on context.

Start at Zero When:

✅ Comparing magnitudes
   Example: Total revenue ($0 to $10M)
   Why: Shows absolute scale accurately

✅ Showing growth from nothing
   Example: New product sales starting from launch

✅ Context requires it
   Example: Temperature in Celsius (0° is meaningful)

DON'T Start at Zero When:

✅ Showing small variations matter
   Example: Blood pressure (90-120 range)
   Starting at 0 would hide critical changes

✅ Focus is on trend, not magnitude
   Example: Stock price movements (relative change matters)

✅ Data doesn't naturally include zero
   Example: pH levels (0-14 scale)

The rule: If you don't start at zero, clearly label your axis range and consider adding a note.

3. Handling Multiple Lines

Limit Number of Lines

✅ 1-3 lines: Ideal - easy to follow
⚠️  4-5 lines: Maximum - gets busy
❌ 6+ lines: Too many - chart becomes spaghetti

Solution for many series:
- Use small multiples (separate mini charts)
- Highlight 1-2 key lines, gray out others
- Use interactive filtering

Make Lines Distinguishable

Technique When to Use
Different colors 2-5 lines, good contrast
Different line styles (solid, dashed, dotted) Printing in black & white
Different line thickness Emphasizing one primary line
Direct labels on lines Always! Better than legends

4. Time Axis Best Practices

Use Consistent Intervals

❌ Bad: Jan, Feb, Mar, Apr, Aug, Dec
   (Skips months - distorts trend)

✅ Good: Jan, Feb, Mar, Apr, May, Jun...
   (Even spacing = honest representation)

Exception: If you MUST skip time periods, add a break symbol (//) in the axis

Choose Appropriate Granularity

5. Markers: Points on Lines

Add Markers When:

✅ Few data points (< 12)
✅ Emphasizing specific values
✅ Users need to see exact measurements

Example: Quarterly results (4 points per year)

Skip Markers When:

❌ Many data points (daily data over a year)
❌ Focus is on overall trend
❌ Makes chart cluttered

Example: Daily stock prices (365 points)

6. Common Line Chart Mistakes

❌ Mistake #1: Connecting Unrelated Points

Bad: Line chart of categories
Example: Products on X-axis (A, B, C, D)

Why wrong: Lines imply continuity
No relationship between Product A and Product B

Fix: Use bar chart instead

❌ Mistake #2: Too Much Data

Showing 10 years of daily data (3,650 points) creates visual noise.

Solutions:

❌ Mistake #3: Misleading Truncated Y-Axis

Example: Revenue chart
Y-axis: $98M to $102M (zoomed in)
Result: 4% change looks like 10x

Solution: Either start at zero OR clearly label range with note:
"Chart zoomed to highlight 4% variation"

❌ Mistake #4: Inconsistent Time Periods

Bad: Mixing monthly and quarterly data on same axis
Result: Misleading patterns

Good: Convert all to same granularity first

7. Annotations: Tell the Story

Raw data rarely speaks for itself. Add context:

✅ Annotate significant events:
   - "Product launch" arrow
   - "Competitor entered market" marker
   - "Holiday spike" label

✅ Highlight trends:
   - "30% growth period" shaded region
   - Trendline showing overall direction

✅ Add reference lines:
   - Goal or target (dashed line)
   - Historical average
   - Benchmark comparison

8. Design & Styling Tips

9. Advanced Techniques

Small Multiples

Instead of 10 lines on one chart:
Create 10 small charts in a grid, same axes

Benefits:
- Easy to compare patterns
- No overlapping lines
- Clear individual trends

Confidence Bands

Show uncertainty with shaded regions around forecasts or predictions.

Dual Y-Axes (Use with Caution!)

⚠️  Can be misleading if scales are manipulated
✅ OK when:
   - Two related but different units (temperature & rainfall)
   - Relationship is the point, not absolute values
   - Clearly labeled

Quick Checklist Before Publishing

Golden Rule: The slope of a line is more important than its absolute position. Design your chart so trends are obvious at a glance. If someone has to squint or study your chart for 30 seconds, your Y-axis range or aspect ratio is wrong.

← Back to Visualization Tips