Guidelines
Suggest edit

Use a column chart for only a few time points

For showing ordered-time data with only a few time points, prefer a column chart over a line chart to improve readability and address sparse point-in-time comparisons for general audiences.

  • purpose:select
  • basis:heuristic
  • task:trend
  • time:ordered-time
  • chart:bar:use
  • chart:line:avoid
  • lever:chart-family
  • quality:readability

advice

Column chart for sparse time points

Choose a column chart when the time series contains only a few dates. For example, show values for the past five years with columns rather than drawing a line through just a handful of points.

reason

Why columns work better for a short run of dates

A few time points read more like a set of discrete comparisons than a continuous development. A column chart fits that sparse structure directly.

Mechanism: Columns emphasize each observed time point as its own value instead of implying a longer continuous path.

Evidence: For just a few points in time, a column chart is presented as the usual good fit, while line charts are introduced as the classic choice for showing how values changed over months or years (https://www.datawrapper.de/blog/chart-types-guide">Muth, 2025).

context

Use when the timeline is short

  • User Goal: Show how a value changed across a short run of dates.
  • Task: Compare a few observed time points.
  • Data: Ordered-time data with only a small number of dates.
  • Chart Setting: A simple time chart for a mainstream audience.
  • Audience: A mainstream audience.
  • Success Criterion: Each time point is easy to compare without a sparse line doing unnecessary work.

exceptions

Do not use when the development across many dates matters

Break it when: The chart covers months or years with enough dates that the evolution of the line itself is important. Why: A line chart is the classic intuitive choice for showing how values changed over longer time spans.

costs

Costs of switching to columns

Sacrifice: You give up the continuous path that a line chart shows.
Risk: If there are many dates, columns can stop fitting the time sequence well.
Mitigation: Use columns only when the time series really has just a few points.

mistakes

Common failure with short time series

Mistake: Draw a line chart for a very short series of dates just because the data is temporal. Why it fails: The chart adds a connected line where readers mainly need to compare a small set of separate time points.

check

Check whether the line is doing useful work

Failure Sign: The chart contains only a handful of dates, and the connected line adds little beyond linking sparse points.
Quick Check: Compare a column version and a line version of the same short series; if the columns make the few time points easier to compare, keep the column chart.
Stronger Test: Ask whether the chart’s message depends on the path between many dates or simply on the values at a few dates.

fix

Fix the sparse time series display

  • Replace the line chart with a column chart.
  • Keep one column per time point.
  • Use the line chart only if the series extends across enough dates that the development between them matters.

References

Muth, L. C. (2025). A friendly guide to choosing a chart type. https://www.datawrapper.de/blog/chart-types-guide