PlotSet LogoPlotSet
Alle Diagrammtypen

Column Chart Maker

Vertical bars, built from your spreadsheet. Upload a CSV or Excel file, pick a label column and a value column, and publish an interactive column chart you can embed anywhere — free.

Column Chart erstellen — kostenlosGalerie ansehen

Was ist ein Column Chart?

A column chart compares values across categories by drawing one vertical bar per category, with height carrying the number. It is the same encoding as a bar chart — length against a common baseline, which is the most accurately read encoding there is — turned through ninety degrees. The rotation is not cosmetic. Vertical bars sit naturally on a horizontal axis that reads left to right, so a column chart is the better shape whenever the categories have an order the reader already expects to run that way: months, quarters, years, age bands, score ranges. Horizontal bars are the better shape when the category names are long or the list is deep. Everything else about the two charts is identical.

Wann ein Column Chart sinnvoll ist

  • Your categories have a left-to-right order

    Months, quarters, years, age brackets, survey scales. Readers already expect time and ordered bands to run along the bottom of a chart, and a column chart puts them there.

  • You have a handful of short labels

    Up to roughly a dozen categories whose names fit under a bar without tilting. Beyond that, or once the names get long, the horizontal bar chart stops fighting the labels and starts helping.

  • The comparison is the whole point

    Height against a shared baseline is read more accurately than angle, area or colour. If your reader has to say which of these is bigger and by how much, columns answer it faster than anything else.

  • You want it to sit beside a line chart

    Columns and lines share the same axis convention, so a column chart of monthly volume next to a line of monthly rate reads as one story rather than two unrelated pictures.

Wann ein Column Chart nicht passt

  • The category names are long

    Vertical bars give a label about as much width as the bar itself. "Business and administrative services" under a 40-pixel column becomes tilted, truncated or unreadable — use a bar chart and let the names run along the left.

  • You have more than about fifteen categories

    Columns get thin and the chart turns into a picket fence. A ranked horizontal bar chart scrolls comfortably to fifty rows; a column chart does not.

  • You are showing a continuous distribution

    Binned numeric data belongs in a histogram, where the bars touch because the axis underneath is a number line. The gaps in a column chart mean the categories are separate things.

  • You have many time points

    Two or three years of monthly columns is a wall. Once the shape of the trend matters more than each individual value, a line chart says it in far less ink.

Column Chart erstellen: Schritt für Schritt

Von der Tabelle zum veröffentlichten Diagramm, Schritt für Schritt.

01

Start from the column chart template

Open the PlotSet column chart template. Sample data comes bound, so you can see the shape of spreadsheet it expects before you bring your own.

02

Bring one label column and one value column

One row per category: the category name in one column, its number in another. If your data is currently one row per transaction, summarise it first — the chart draws what you give it.

03

Upload or connect your data

Import a CSV or Excel file, paste straight from a spreadsheet, or connect a Google Sheet so the chart can be refreshed when the source moves.

04

Decide the order deliberately

Time and ordered bands keep their natural sequence. Everything else should usually be sorted by value, because a ranked chart answers "which is biggest" without the reader scanning for it.

05

Format the numbers and label the axis

Set thousands separators, currency or percentage formatting once and it applies everywhere. Name the unit on the value axis so nobody has to guess whether it is dollars, thousands or per cent.

06

Publish, embed or export

Publish for a live interactive chart with hover values, or export a PNG, SVG or PDF for a report or a deck.

Starten Sie mit der Column Chart-Vorlage samt Beispieldaten und ersetzen Sie diese durch Ihre eigenen.

Vorlage öffnen

Die Bestandteile eines Column Chart

Column
One vertical bar per category. Its height is the value, measured from the baseline — which is why the baseline has to be zero.
Category axis
The horizontal axis, listing the separate things being compared. Gaps between the columns are meaningful: they say these categories are distinct, not points on a scale.
Value axis
The vertical scale. Label it with its unit, and start it at zero unless you have a very good reason and a very visible note.
Baseline
The zero line every column is measured from. Move it and the ratio between two columns stops matching the ratio between two numbers.
Gap width
The space between columns. Around half a column width is the usual balance — too wide and the comparison scatters, too narrow and it starts to look like a histogram.
Value label
The number printed on or above a column. Worth turning on for a small chart where readers want exact figures; worth turning off once there are enough columns for the labels to collide.

Häufige Fehler bei einem Column Chart

Truncating the value axis

Starting at 90 instead of 0 turns a three per cent difference into a doubling. Columns encode magnitude by height, so a cut baseline is not a zoom — it is a different number.

Tilting the category labels to 45 degrees

Diagonal text is slow to read and a sign the chart is the wrong way round. If the labels do not fit horizontally, switch to a bar chart rather than rotating them.

Leaving categories in spreadsheet order

Alphabetical or whatever-order-they-were-entered makes the reader do the ranking. Unless the sequence carries meaning, sort by value.

Using 3D or perspective columns

Depth adds a second, false encoding and makes the front row look taller than it is. It has never made a chart easier to read.

Colouring every column differently

Colour should mean something. A different hue per category tells the reader to look for a grouping that is not there — use one colour, and a second only to highlight.

Column Chart: häufige Fragen

Orientation, and nothing else about the encoding. Column charts run vertically and suit ordered categories like months and short labels; bar charts run horizontally and suit long category names and longer lists. Both compare length against a shared baseline.

Erstellen Sie jetzt Ihr Column Chart

Kostenlos starten mit über 300 Vorlagen. Keine Kreditkarte nötig.

Column Chart erstellen — kostenlosAlle Diagrammtypen