CSV de ejemplo
| Quarter | Streaming | Hardware | Services |
|---|---|---|---|
| Q1 | 182000 | 64000 | 41000 |
| Q2 | 201000 | 58000 | 47000 |
| Q3 | 195000 | 71000 | 52000 |
| Q4 | 238000 | 89000 | 60000 |
How to Create a Grouped Bar Chart
A step by step walkthrough for turning a wide spreadsheet into a published grouped bar chart in PlotSet, from shaping the columns to publishing, embedding or exporting the finished chart.
Unos 8 minutosThis guide covers how to create a grouped bar chart in PlotSet: a chart with two or more bars sitting side by side inside every category, so you can compare a handful of series against each other and against the category next door in one picture. You'll end with a published chart built from your own columns, sorted on purpose, coloured consistently, and either embedded on a page or exported as an image.
If your spreadsheet already has one column per series, this takes about eight minutes, most of it spent choosing an order and locking down colours rather than fighting the upload. Add another five or ten if your data currently sits in long format, one row per category-series pair, and needs pivoting into columns first.
Los datos que necesitas
Wide format: one row per category, one column per series. The category name goes first, then one number column for every series you want to compare, with a single header row.
This is wide format, not long format. If your source data instead has three columns, category, series name, value, stacked into many rows, pivot it in your spreadsheet first so each series gets its own column.
Two to four series is the sweet spot. PlotSet will happily chart a fifth or sixth column, but a group of six bars is hard to scan and usually reads better as small multiples.
The column headers become the legend labels, so write them the way you want them to read on the chart. 'Streaming' beats 'streaming_rev' or a generic 'Series 1'.
A blank cell in a series column renders as a bar with no height rather than being skipped. Fill in the real number, or delete the row if a category has no data for one series.
Los pasos
El camino exacto en PlotSet, desde una plantilla en blanco hasta el gráfico terminado.
- 01
Open the grouped bar chart template
From the PlotSet dashboard, start a new project and choose the Grouped Bar Chart template. It loads with sample data already bound, so you can see exactly how categories and series map onto groups before your own file goes in.
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 wide format
Put the category in the first column and give every series its own column after that, one row per category. If your export currently has a separate 'series' column with repeated category names, pivot it in your spreadsheet so each series becomes a column instead of a row value.
- 03
Upload your file or connect a sheet
Import a CSV or .xlsx file from the data panel, paste rows directly, or connect a Google Sheet if you want the chart to refresh later without a re-upload. PlotSet reads the first row as headers and treats every column after the category as a separate series.
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
Map the category column and the series columns
Confirm which column feeds the category axis and which columns feed the bars within each group. This is usually right by default when your headers are clean, but double check it if your sheet carries extra columns you don't want charted.
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
Order the categories on purpose
Sort by a series that matters, or keep a natural order such as quarters or age brackets. Alphabetical order almost never tells the right story, and getting this right does more for readability than any colour choice later.
- 06
Lock a colour to each series
Assign one fixed colour per series and leave it alone. The legend is the only thing telling a reader which bar in group four matches which bar in group one, so a colour that shifts partway through a report undoes that link.
La pestaña Preview de un gráfico de tipo Grouped Bar 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. - 07
Widen the gap between groups
Check that the space between categories is clearly bigger than the space between bars inside a category. If PlotSet's default gap looks tight, increase it in the chart settings until each group reads as one unit rather than a continuous row of bars.
- 08
Publish, embed or export
Publish for a live, interactive chart with hover tooltips and a shareable link, grab the embed code for a page, or export a PNG, SVG or PDF for a deck or report.
Empieza con la plantilla de Grouped Bar 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 Grouped Bar Chart
Two series is ideal, four is the ceiling
Below three bars per group, comparisons are instant. Past four, the eye starts losing track of which colour belongs to which series across groups. If you have more, drop the series nobody asks about or split into small multiples.
Keep the axis at zero
Every bar's length is the thing being compared, so a truncated axis exaggerates every gap between series. If two series are close in value, add value labels instead of zooming the axis in.
Horizontal bars for long category names
If your categories are department names, product names or survey questions rather than short codes, switch the chart to horizontal. Long labels get a full line each with nothing rotated or truncated.
Put the legend in series order
Set the legend to list series in the same left-to-right order they appear inside each group. It saves the reader a lookup on every single group instead of just the first one.
Errores comunes al hacer un Grouped Bar Chart
One column loaded as a giant series instead of several
This usually means the sheet was still in long format, category and series stacked into extra rows, when it was uploaded. Pivot the data into one column per series in your spreadsheet, then re-upload or reconnect the sheet.
Groups blur into one continuous row of bars
This happens when the gap between categories is set too close to the gap between bars inside a category. Open the chart's spacing controls and increase the group gap until each category is visibly separated from its neighbour.
A series changes colour partway through the chart
This is almost always a manual colour override on one group that didn't get applied everywhere. Remove the one-off override and assign colour by series globally, in the legend or series settings, so the mapping stays fixed across every group.
Aprende más sobre el Grouped Bar Chart
¿No estás seguro de que el Grouped Bar Chart sea la opción correcta? Descubre qué es, cuándo usarlo y cuándo no.
Grouped Bar Chart: preguntas frecuentes
Wide format: one row per category and one column per series, with the category name in the first column. A quarterly revenue sheet with columns for each product line is a typical example. CSV and .xlsx both work, and a pasted range from any spreadsheet tool is fine too.
Crea tu Grouped Bar Chart ahora
Gratis para empezar con más de 300 plantillas. No se necesita tarjeta de crédito.