Exemple de 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.
Environ 8 minutesThis 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.
Les données dont vous avez besoin
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.
Les étapes
Le parcours exact dans PlotSet, d'un modèle vierge à un graphique terminé.
- 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.
Chaque guide commence ici. Choisissez la catégorie, puis le modèle : c'est la même grille quel que soit le type de graphique visé. - 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.
La vue données, ici sur un projet de graphique en barres. Importez un CSV, extrayez les chiffres d'une image avec 'Magic Import' ou synchronisez une Google Sheet. Le panneau est identique pour tous les types de graphique. - 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.
Les associations déterminent quelle colonne devient l'étiquette, laquelle fournit les valeurs et laquelle pilote la couleur. 'Auto Binding' les devine à partir de vos en-têtes : vérifiez-les plutôt que de les tenir pour acquises. - 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.
L'onglet 'Preview' pour un graphique Stacked Column Chart. Tous les réglages de style se trouvent dans le panneau entouré en rouge : apparence, en-tête, pied de page et les options propres à ce type de graphique, chacun dans un onglet distinct. - 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.
Partez du modèle Stacked Column Chart avec des données d'exemple déjà chargées, puis remplacez-les par les vôtres.
Ouvrir le modèlePublier, intégrer ou exporter
La dernière ligne droite est la même pour tous les types de graphique : 'Share' transforme le graphique en lien public actif et en code d'intégration, 'Export' l'enregistre sous forme de fichier statique.
Share : lien public et code d'intégration
Activer le code d'intégration et le lien public revient à publier le graphique. Le lien peut être envoyé à qui vous voulez sans risque, et le code d'intégration s'insère dans n'importe quelle page sous la forme d'une iframe qui conserve les infobulles au survol et l'interactivité. Si vous modifiez le graphique par la suite, cliquez sur 'Recreate' pour répercuter ces changements sur le lien comme sur le code.
Export : SVG, PNG ou JPG
Le bouton 'Export' génère une copie statique à la taille dont vous avez besoin. Le SVG reste net à toutes les échelles et peut encore être modifié dans un outil de design ; PNG et JPG sont les choix sûrs pour les présentations et les documents. C'est le multiplicateur d'échelle qui vous donne une image nette sur un écran retina.
Conseils de style pour un 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.
Erreurs courantes en créant un 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.
En savoir plus sur le Stacked Column Chart
Vous n'êtes pas sûr que le Stacked Column Chart soit le bon choix ? Découvrez ce que c'est, quand l'utiliser et quand l'éviter.
Stacked Column Chart : questions fréquentes
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.
Créez votre Stacked Column Chart maintenant
Gratuit pour commencer avec plus de 300 modèles. Aucune carte bancaire requise.