CSV de ejemplo
| 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.
Unos 8 minutosThis 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.
Los datos que necesitas
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.
Los pasos
El camino exacto en PlotSet, desde una plantilla en blanco hasta el gráfico terminado.
- 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.
Todas las guías empiezan aquí. Elige la categoría y luego la plantilla. Es la misma cuadrícula sea cual sea el tipo de gráfico que busques. - 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 vista de datos, aquí en un proyecto de gráfico de barras. Sube un CSV, saca los números de una imagen con Magic Import o sincroniza una Google Sheet. El panel es el mismo en todos los tipos de gráfico. - 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.
Las asignaciones deciden qué columna se convierte en la etiqueta, cuál aporta los valores y cuál define el color. Auto Binding las deduce de tus encabezados, así que revísalas en lugar de darlas por buenas. - 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.
La pestaña Preview de un gráfico de tipo Stacked Column Chart. Todos los controles de estilo están en el panel enmarcado: apariencia, encabezado, pie de página y las opciones propias de este tipo de gráfico, cada grupo en su propia pestaña. - 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.
Empieza con la plantilla de Stacked Column Chart, que ya trae datos de ejemplo cargados, y sustitúyelos por los tuyos.
Abrir la plantillaPublícalo, incrústalo o expórtalo
El último tramo es igual en todos los tipos de gráfico: Share convierte el gráfico en un enlace público en vivo y un código de incrustación, y Export lo guarda como un archivo estático.
Share: enlace público y código de incrustación
Al activar el código de incrustación y el enlace público, el gráfico queda publicado. El enlace se lo puedes enviar a cualquiera sin problema, y el código de incrustación se coloca en cualquier página como un iframe que conserva los tooltips al pasar el cursor y toda la interactividad. Si editas el gráfico más adelante, haz clic en Recreate para llevar esos cambios a ambos.
Export: SVG, PNG o JPG
Export guarda una copia estática en el tamaño que necesites. El SVG se mantiene nítido a cualquier escala y se puede seguir editando en una herramienta de diseño; PNG y JPG son la opción segura para diapositivas y documentos. El multiplicador de escala es lo que te da una imagen nítida en una pantalla retina.
Consejos de estilo para 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.
Errores comunes al hacer 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.
Aprende más sobre el Stacked Column Chart
¿No estás seguro de que el Stacked Column Chart sea la opción correcta? Descubre qué es, cuándo usarlo y cuándo no.
Stacked Column Chart: preguntas frecuentes
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.
Crea tu Stacked Column Chart ahora
Gratis para empezar con más de 300 plantillas. No se necesita tarjeta de crédito.