Beispiel-CSV
| Quarter | Hardware | Software | Services |
|---|---|---|---|
| Q1 2024 | 42000 | 68000 | 21000 |
| Q2 2024 | 45500 | 71000 | 23500 |
| Q3 2024 | 51000 | 76500 | 26000 |
| Q4 2024 | 58500 | 84000 | 29500 |
How to Create a Grouped Column Chart
A step by step walkthrough for turning a spreadsheet with two to four series into a published grouped column chart in PlotSet, from shaping the sheet to exporting or embedding it.
Etwa 8 MinutenHere's how to create a grouped column chart in PlotSet, starting from a spreadsheet with one row per category and one column per series, and ending with something you can embed or export. You will upload something like quarterly revenue split by product line or headcount split by department, confirm PlotSet mapped every series column, then fix the group order and colors before publishing.
If your sheet is already wide (one category column, then a column per series), this takes about eight minutes. Add five more if you are reshaping a long format export first: pivoting a date/series/value table into one row per period, or renaming headers so the legend reads cleanly.
Die Daten, die Sie brauchen
Wide format, one row per category and one column per series. The category (quarter, region, channel) goes first; every column after it is a series, and its header becomes the legend label.
This is wide format, not long format. If your export instead has three columns (period, series name, value) with one row per combination, pivot it in your spreadsheet tool first so each series gets its own column.
The header of each series column becomes its legend label and its name in the hover tooltip, so write it the way you want readers to see it: "Software" not "software_rev".
Two series is comfortable and four is about the ceiling before columns get too thin to read. A fifth series is usually a sign the data wants a small multiple instead.
A blank cell in a series column renders as a missing column in that group, not zero. Decide on purpose whether a gap should read as zero or as no data, and fill or leave it accordingly.
Die Schritte
Der genaue Klickpfad in PlotSet, von einer leeren Vorlage bis zum fertigen Diagramm.
- 01
Start a new project from the Grouped Column Chart template
From the PlotSet dashboard, start a new project and choose the Grouped Column Chart template. It loads with sample data already bound, so you can see exactly how the first column becomes the category axis and the rest become series before you touch your own file.
Jede Anleitung beginnt hier. Wählen Sie erst die Kategorie, dann die Vorlage. Das Raster ist für jeden Diagrammtyp dasselbe. - 02
Shape your sheet wide, one row per category
Put the category in the first column and one series per remaining column, with the series name as the header. If your source is a long format export with a series column and a value column, pivot it in your spreadsheet first: this chart needs series side by side, not stacked as rows.
- 03
Upload your file or connect a sheet
Use the data panel to import a CSV or .xlsx file, paste rows directly from a spreadsheet, or connect a Google Sheet if you want the chart to refresh when the source changes. PlotSet reads the first row as headers automatically.
Die Datenansicht, hier in einem Balkendiagramm-Projekt. Laden Sie über "Upload CSV File" eine CSV-Datei hoch, holen Sie die Zahlen mit "Magic Import" aus einem Bild oder verbinden Sie ein Google Sheet. Der Bereich sieht bei jedem Diagrammtyp gleich aus. - 04
Check the value binding covers every series
The category slot takes the first column; the value slot takes a range, not a single column, for example B through D for three series. If a series is missing from the chart, this range is the first place to check, it is the most common reason a column just does not show up.
Die Zuordnungen legen fest, welche Spalte zur Beschriftung wird, welche die Werte liefert und welche die Farbe steuert. "Auto Binding" errät sie anhand Ihrer Spaltenüberschriften. Prüfen Sie das Ergebnis, statt sich darauf zu verlassen. - 05
Fix the category order
Sort chronologically if your categories are periods, or by whatever series matters most otherwise. Alphabetical order is rarely the right read for a grouped column chart, and PlotSet will not reorder categories for you once they are mapped.
- 06
Set the group gap wider than the column gap
The space between categories needs to look clearly wider than the space between columns inside one category, or the groups stop reading as groups. If every column looks evenly spaced, open the layout settings and widen the group gap.
- 07
Fix series colors and add value labels
Assign one color per series and keep that assignment if you reuse the same series elsewhere in your report. Turn on value labels if the exact numbers matter more than the shape, and keep the value axis starting at zero either way.
Der Tab "Preview" für ein Diagramm vom Typ "Grouped Column Chart". Alle Gestaltungsoptionen stecken im umrandeten Bereich: Aussehen, Kopfzeile, Fußzeile und die Optionen, die es speziell für diesen Diagrammtyp gibt, jeweils in einem eigenen Tab. - 08
Publish it, or grab the embed code
Publish for a live, interactive chart with hover tooltips and a shareable link, grab the embed code to drop it into a page, or export a PNG, SVG or PDF if you need a static image for a deck or a report.
Starten Sie mit der Grouped Column Chart-Vorlage samt bereits geladenen Beispieldaten und ersetzen Sie diese durch Ihre eigenen.
Vorlage öffnenVeröffentlichen, einbetten oder exportieren
Der letzte Abschnitt ist bei jedem Diagrammtyp gleich: "Share" macht aus dem Diagramm einen öffentlichen Live-Link und einen Einbettungscode, "Export" schreibt es als statische Datei heraus.
"Share": öffentlicher Link und Einbettungscode
Aktivieren Sie den Einbettungscode und den öffentlichen Link, um das Diagramm zu veröffentlichen. Den Link können Sie bedenkenlos an alle weitergeben, und der Einbettungscode fügt sich als iframe in jede Seite ein. Die Tooltips beim Überfahren mit der Maus und die volle Interaktivität bleiben erhalten. Wenn Sie das Diagramm später bearbeiten, überträgt "Recreate" die Änderungen auf Link und Einbettung.
"Export": SVG, PNG oder JPG
"Export" schreibt eine statische Kopie in der Größe heraus, die Sie brauchen. SVG bleibt in jeder Skalierung scharf und lässt sich weiterhin in einem Design-Tool bearbeiten; PNG und JPG sind die sichere Wahl für Folien und Dokumente. Der Skalierungsfaktor sorgt dafür, dass das Bild auf einem Retina-Display gestochen scharf wirkt.
Styling-Tipps für Grouped Column Chart
Cap it at four series
Two series is the easy case and three is fine. At four, columns are already narrow; a fifth pushes each group into a picket fence nobody can compare accurately. Split into small multiples (one panel per series, shared axis) instead of adding a fifth color.
Lock colors to series, not to position
If "Software" is teal in Q1, keep it teal in every quarter and in every other chart in the same report. Readers learn the color once and reuse that memory; changing it mid-report forces them to check the legend every time.
Sort categories on purpose
Time periods sort chronologically. Anything else (regions, channels, products) should sort by the series that matters most for the story, largest to smallest, not alphabetically. Alphabetical order is a default, not a decision.
Keep the value axis at zero
Column height is the encoding here, the same as a single-series column chart. A truncated axis exaggerates every gap between series, which matters more in a grouped chart because readers are already comparing several bars against each other at once.
Häufige Fehler bei Grouped Column Chart
One series never shows up in the chart
This almost always means the value binding is a single column instead of a range. Open the data mapping, check that the range covers every series column (B through D for three series, not just B), and re-check after adding a new series later.
Columns inside a group look merged into one block
The group gap and the column gap are set to roughly the same width, so the eye cannot tell where one category ends and the next begins. Widen the group gap in the layout settings until there is a clear visual break between categories.
The same series shows a different color in each category
This happens when column order in the source sheet does not match between an old upload and a new one, so PlotSet assigns colors by position rather than by the header you expect. Re-check the column order in your spreadsheet matches the series legend, then reassign colors if needed.
Mehr über Grouped Column Chart erfahren
Nicht sicher, ob Grouped Column Chart die richtige Wahl ist? Erfahren Sie, was es ist, wann Sie es verwenden sollten und wann nicht.
Grouped Column Chart: häufige Fragen
Same data, different orientation. Grouped columns stand vertically and suit short category labels or a time axis; grouped bars lie horizontally and suit long category names or many categories. Build the sheet the same way for either one.
Jetzt Grouped Column Chart erstellen
Kostenlos starten mit über 300 Vorlagen. Keine Kreditkarte erforderlich.