Beispiel-CSV
| Quarter | New | Renewal | Expansion |
|---|---|---|---|
| Q1 2025 | 120000 | 340000 | 45000 |
| Q2 2025 | 145000 | 360000 | 52000 |
| Q3 2025 | 138000 | 375000 | 61000 |
| Q4 2025 | 162000 | 390000 | 74000 |
How to Create a Stacked Column Chart
A step by step walkthrough for turning a spreadsheet into a published stacked column chart in PlotSet, from shaping the columns to ordering the stack and exporting the result.
Etwa 8 MinutenThis guide covers how to create a stacked column chart in PlotSet, starting from a raw spreadsheet and ending with a chart you can publish, embed or export. You will end up with columns that show both a total and the parts underneath it, stacked in an order you chose on purpose, not whatever order your spreadsheet happened to list the columns in.
Eight minutes, roughly, if your data already sits one row per period with a clean numeric column for each segment. Pulling those numbers out of a pivot table first adds a few more, and it's the step most people underestimate: flattening a wide report into the one-row-per-period shape this chart actually needs.
Die Daten, die Sie brauchen
One row per time period or category, with the period in the first column and one numeric column per segment. Every numeric column becomes one band in the stack, in the order the columns appear.
Keep the period column as plain text, not a date field. If a spreadsheet auto-converts "Q1 2025" into a date, PlotSet will chart whatever that date resolves to, not the label you typed.
Do not add a Total column. PlotSet sums the segment columns itself to draw the full column height, and an extra total column will get read as one more band, roughly doubling every column's apparent size.
Every segment needs its own column with a consistent header across every sheet you upload. A segment named "Renewal" in one file and "Renewals" in another counts as two different bands, not one.
A blank cell in a segment column renders as a zero-height band rather than being skipped, so a quarter with no expansion revenue still needs a 0 in that cell, not an empty one.
Die Schritte
Der genaue Klickpfad in PlotSet, von einer leeren Vorlage bis zum fertigen Diagramm.
- 01
Open the stacked column chart template
From the PlotSet dashboard, start a new project and choose the Stacked Column Chart template. It loads with sample data already shaped correctly, so you can see the column layout 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 into one row per period
Put the time period or category in the first column and one numeric column per segment after it. If your source is a pivot table with the segments spread across a wider report, flatten it into this layout before you upload anything.
- 03
Import the file or connect a sheet
Use the data panel to import a CSV or .xlsx file, paste rows straight from a spreadsheet, or connect a Google Sheet if you want the chart to update later without a re-upload. PlotSet reads the first row as your segment headers.
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
Confirm the axis column and the segment columns
Confirm which column feeds the horizontal axis and which columns feed the stack. This is usually correct automatically, but check it if your sheet carries extra columns, like a growth rate or a note field, that should not be charted as a band.
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
Set the stack order
Drag the segments into the order you want them to appear, bottom to top. Put whichever series your reader most needs to compare across periods at the bottom, since that is the only band sitting on a shared baseline.
Der Tab "Preview" für ein Diagramm vom Typ "Stacked 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. - 06
Decide between raw values and percentages
Leave the chart on raw values if the totals themselves are part of the story. Switch to the 100% stacked variant if you only care about how the share of each segment shifted, since that view normalises every column to the same height.
- 07
Style the bands, add labels, and publish
Give each segment a distinct colour, turn on a total label above the column if the sum is worth calling out, and confirm the value axis starts at zero. Then publish for a live embed with hover tooltips, or export a PNG, SVG or PDF.
Starten Sie mit der Stacked 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 Stacked Column Chart
Bottom slot goes to the series you actually compare
Every band above the bottom one floats at a different starting height in each column, which makes it hard to compare by eye. If your reader needs to track one segment closely across periods, put that segment on the baseline, not the total.
Add a total label when the sum is the headline
Reading a stacked total off the value axis is imprecise, since it means adding up several segment heights by eye. If the total itself is news (revenue crossed a milestone, headcount hit a target) turn on the label that prints it above the column.
Only switch to 100% stacking if totals genuinely do not matter
The percentage view hides the totals completely to make shares easy to compare. That is the right trade when a reader only cares about proportion, and the wrong one the moment someone asks "but how big was Q3 actually?"
Pick colours that stay distinct at three bands and start to break at six
A handful of clearly different hues works for two to five segments. Once you are past five, either merge the smallest categories into an "Other" column before upload, or the bands start blurring into a colour gradient nobody can read accurately.
Häufige Fehler bei Stacked Column Chart
One column is far taller than the rest
This almost always means a segment column snuck in that duplicates a total, or one column is in different units than the others (dollars next to thousands of dollars). Check every segment column for a matching scale before you upload again.
The bands appear in a different order in different columns
PlotSet stacks columns in the order the segment columns are mapped, so this happens when a later batch of rows was pasted in with the segment columns rearranged. Open the data table and confirm every row uses the same column order and the same header spelling.
A small segment disappears or blends into its neighbour
Thin bands with similar default colours are hard to see, especially past four or five segments. Either assign that segment a colour that stands apart from the ones next to it, or roll the smallest categories into an "Other" column before you upload.
Mehr über Stacked Column Chart erfahren
Nicht sicher, ob Stacked Column Chart die richtige Wahl ist? Erfahren Sie, was es ist, wann Sie es verwenden sollten und wann nicht.
Stacked Column Chart: häufige Fragen
One row per time period or category, with the period in the first column and one numeric column per segment after it. Each of those numeric columns becomes one band in the stack, so a chart with three segments needs exactly three value columns plus the period column, and no separate total column.
Jetzt Stacked Column Chart erstellen
Kostenlos starten mit über 300 Vorlagen. Keine Kreditkarte erforderlich.