Choosing charts

Beyond "Is It Time-Series?": Three Lenses for Choosing the Right Chart

"Line for time-series, bar for everything else" — most of us have heard this rule. It's a useful rule of thumb, but it isn't precise. The real criterion is whether the categories on the X-axis carry meaningful order — which is to say, look at the structure of the data itself.

Many of us were taught early on: "time-series → line; categorical → bar." It's simple, easy to remember, and gets you to the right answer in most cases. But spend long enough working with charts in practice and you start to notice that something important is missing from this rule.

Imagine "sales of products A, B, C, D, E." Not time-series, so by the rule it's a bar chart, end of story. But what if the order is "from cheapest to most expensive"? Or "from youngest target audience to oldest"? When the order carries meaning, a line chart may convey the structure better.

It's all about whether the axis is continuous or discrete

The real criterion is whether the X-axis represents continuous variation or discrete categories. Continuous means the "space between" adjacent values has meaning. Between January and February sit January 15 and the last day of January, physically. Between age 20 and age 30 sits age 25. These are continuous.

Discrete means there's no meaning to the space between adjacent values. There's nothing "halfway between Product A and Product B." There's no meaningful midpoint between Tokyo and Osaka. These are discrete categories.

A line chart connects points with line segments. That implies "there's something between the points, too." It's appropriate for continuous data, but using it on discrete categories visually creates "in-betweens" that don't actually exist.

Figure 1: Sales by product drawn as a line chart. A nonexistent "midpoint" appears between Products A and B as a line segment, falsely implying that something is varying continuously.
Figure 2: The same data redrawn as a bar chart. Each product is recognized as an independent entity and the comparison is made correctly.

Ordered categories — the middle ground

There's a class of data that's neither pure time-series nor pure discrete categories — a middle ground. Examples: population by age bracket (20s, 30s, 40s…), satisfaction scale (very satisfied, satisfied, neutral, dissatisfied, very dissatisfied), product sizes (S, M, L, XL).

These are discrete, but the order matters. There's no "25-bracket" between the 20s and 30s, but the 30s come right after the 20s — you don't jump straight to the 40s. Reverse the order and the meaning changes. We call these ordered categories.

For ordered categories, either a bar or a line chart can work. The deciding factor is "what do you want the reader to take away?" If you want to show "the 30s stand out as the biggest" in a population distribution, use a bar chart. If you want to show "the distribution spreads out around the 30s as the peak," use a line chart. Same data, different message — the right choice changes.

Figure 3: User counts by age bracket, drawn as a line chart. The shape of the distribution — "peaks in the 30s and tapers on both sides" — registers immediately. Drawn as a bar chart, the focus would shift to "the 30s are the largest" — an individual comparison.

Cases where bar charts work for time-series too

Conversely, even time-series data sometimes calls for a bar chart. When you primarily want to compare the values themselves across periods — "quarterly revenue," "monthly new contracts" — bars often work better.

Quarterly sales as a line chart emphasize the "flow of change" from Q1 → Q2 → Q3. As a bar chart, the focus moves to the absolute comparison of each quarter — "Q3 was the biggest, Q2 the smallest."

A useful hint: "When the reader compares, do they look only at adjacent values, or do they take in all values at once?" Watching monthly PV trends, our eye traces the line from January to December. If you want attention on adjacent change, line is the better fit. With four data points per year, however, the intent is usually to compare all four flatly. That's bar chart territory.

Not "use a line because it's time-series" — use a line because the relationship between adjacent values carries meaning.

Hybrid needs come up surprisingly often

In practice, the request "show me both the individual comparison and the trend" comes up all the time. Monthly revenue, where you want to compare each month and communicate the year's trajectory.

Forcing both into a single chart leads you to a combo chart (bar + line). That's not a bad choice in itself, but the second line is best used to carry a different metric from the bar — a moving average or a cumulative total — not the same numbers in another shape. Overlaying the same values as both bars and a line just adds visual noise without adding information.

Another solution: place two charts side by side. A bar chart on the left where you can compare each month, a line chart on the right where you can see the year's trend. Don't try to say everything in one chart; say it in two views. When the layout space allows, this is often the most honest choice.

A decision flow

Let's organize the discussion into a usable decision flow.

If the X-axis holds unordered categories (regions, departments, products — anything where shuffling them doesn't change the meaning), reach for a bar chart without hesitation. Vertical or horizontal? Decide by label length: long labels → horizontal.

If the X-axis holds continuous values (time, age, temperature, income), a line chart is the first candidate. Switch to a bar chart only when "individual comparison" matters more than "the flow of change."

If the X-axis holds ordered categories (age brackets, sizes, satisfaction levels), pick by the message you want to send. Trend-focused → line; individual-comparison-focused → bar. When either works, the textbook recommendation is to respect the discreteness and choose a bar chart.

The simplest rules are the strongest

"Line for time-series" is genuinely useful. It's still effective for new-hire training. But for anyone wanting a bit more confidence in chart selection, I recommend going one level deeper.

The deeper view is "look at the structure of the data." Is the X-axis continuous or discrete? If discrete, ordered or unordered? Just being conscious of these two questions lets you pick a chart without doubt in nearly every situation. What's left is just deciding by message priority.

Tool choice ultimately starts with reading the material. The "material" in chart-making is the structure of the data. The next time you face a dataset, take five seconds to ask yourself "is this axis continuous or discrete?" Your chart-selection accuracy will jump a notch.