Horizontal bar chart maker

Rotating a chart to save the labels

A horizontal bar chart is a bar chart turned on its side. The encoding is identical — length is the value, the baseline is zero, the same rules apply. Only the orientation changes.

That sounds trivial and it solves the single most common problem in categorical charts: labels that do not fit.

Under a vertical bar, a category name gets about as much width as the bar itself. "Switched to a competitor" does not fit in that. So the label rotates to 45 degrees, or to vertical, and now the reader is tilting their head to read a deck.

Rotate the chart instead and every label sits horizontally in a left-hand column that can be as wide as it needs to be. Nothing rotates, nothing truncates, nothing gets read sideways.

The second advantage is scale. A vertical bar chart runs out of width at around fifteen bars. A horizontal one runs down the page, and pages scroll. Thirty bars is comfortable.

The rule people get backwards

The largest bar goes at the top.

Many tools default to the opposite, because they plot the first row of your data at the bottom of the y-axis and work upward — so a table sorted largest-first comes out smallest-first on the chart. It is one of the most common chart bugs in the wild, and it is easy to miss because the chart still looks tidy.

It matters because English-language readers start at the top left. Whatever sits in the top row is read first, and it should be the largest value. A ranking that ascends from the bottom forces the reader to start at the least important item and work upward against their instinct.

ChartGPT sorts descending from the top by default. Say reverse the order if you need ascending — genuinely useful for scales that run from "strongly disagree" upward, where the natural order should be preserved instead.

When to use horizontal bars

It works well for:

• Long category names — reasons, job titles, product names, survey options, country names
• Rankings with many entries — top ten, top twenty, league tables
• Survey results, especially open-response categories that got coded into phrases
• Anything with fifteen to thirty categories, where a vertical chart runs out of width
• Mobile and narrow layouts. Phones are tall and narrow, which is exactly the shape a horizontal bar chart wants and exactly the wrong shape for a vertical one

Reach for something else when:

Your situation	Better chart	Why
Short labels and fewer than ten categories	Bar chart	Vertical is the more familiar default
Your categories are time periods	Bar or line	Time is conventionally read left to right
More than about thirty bars	A table	Past that it is a list, not a chart
Parts of a single whole	Pie or donut	Bars do not signal a total
Two or three series per category	Grouped bar	One bar carries one value
Total and composition together	Stacked bar	Shows both at once

The time-period exception is worth remembering. Months running top to bottom read oddly, because we expect time to move left to right. Keep time vertical even when the labels are long — abbreviate the labels instead.

Two worked examples

1. Cancellation reasons

Data:

Reason	Count
Price	312
Missing a feature we needed	244
Switched to a competitor	198
Poor support experience	121
No longer needed the product	87
Budget was cut	54

Prompt: Horizontal bar of the top reasons customers cancelled, sorted

What you get: six bars, longest at the top, full labels reading horizontally on the left.

Try this as a vertical chart and "No longer needed the product" rotates to 45 degrees and collides with its neighbours.

2. A long ranking

Data: twenty-two products by units sold.

Prompt: Horizontal bar of units sold by product, top 15 only, group the rest into Other

What you get: fifteen bars plus an "Other" row placed last regardless of its size, since it is a residual rather than a category. Fifteen horizontal bars fits comfortably in a slide; twenty-two vertical ones would not fit at all.

Three things that ruin a horizontal bar chart

1. Ascending order. Covered above. Largest at the top unless the categories have their own sequence.

2. Truncated labels. If the left column is too narrow, labels get cut with an ellipsis — which defeats the entire reason for choosing this chart. Give the labels the width they need; the bars can be shorter.

3. Too many bars. Thirty is the ceiling. Past that the chart becomes a very tall list that nobody scrolls, and a table would serve better.

Getting your data in

Two columns: category and value. Same shape as a vertical bar chart — only the rendering differs.

Long labels are the point of this chart, so do not pre-truncate them in your spreadsheet. Paste the full text and let the left column size itself.

The usual messy-input handling applies: totals rows are read as totals rather than drawn as one enormous bar, numbers stored as text are parsed, and blank rows are skipped.

The paste limit is 500 rows, on every plan — though thirty bars is the readability ceiling regardless.

How to make one

1. Paste two columns, category and value, with labels written out in full.
2. Say horizontal bar chart so it does not infer the type.
3. Name your units so the axis reads correctly.
4. Say what the chart is for so the title states the finding.
5. Adjust in words. Top 15 only, group the rest into Other. Reverse the order. Sort descending.
6. Export — SVG for slides, PNG for a quick paste, PDF for print.

Related chart types

• Bar chart — the vertical version, and free on every plan. Better for short labels and fewer categories.
• Stacked bar — when each row needs to show composition as well as a total.
• Grouped bar — two or three series per category.

Exporting

SVG, PNG and PDF on every plan. SVG is worth using here because these charts are label-heavy, and text is the first thing to blur when a PNG is scaled up.