CSV de exemplo
| 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.
Cerca de 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.
Os dados que você precisa
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.
Os passos
O caminho exato no PlotSet, de um modelo em branco até o gráfico finalizado.
- 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.
Todo guia começa aqui. Escolha a categoria e depois o modelo: a grade é a mesma, seja qual for o tipo de gráfico que você quer. - 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.
A visualização de dados, aqui em um projeto de gráfico de barras. Envie um CSV, extraia os números de uma imagem com o Magic Import ou sincronize um Google Sheet. O painel é idêntico para todos os 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.
Os vínculos definem qual coluna vira o rótulo, qual fornece os valores e qual comanda a cor. O Auto Binding tenta adivinhá-los a partir dos seus cabeçalhos, então confira o resultado em vez de dar como certo. - 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.
A aba Preview de um gráfico do tipo Grouped Bar Chart. Todos os controles de estilo ficam no painel contornado em vermelho: aparência, cabeçalho, rodapé e as opções específicas desse tipo de gráfico. Cada grupo fica em sua própria aba. - 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.
Comece pelo modelo de Grouped Bar Chart com dados de exemplo já carregados, depois substitua-os pelos seus.
Abrir o modeloPublique, incorpore ou exporte
A reta final é igual para todo tipo de gráfico: o Share transforma o gráfico em um link público interativo e em um código de incorporação; o Export gera um arquivo estático.
Share: link público e código de incorporação
Ativar o código de incorporação e o link público é o que publica o gráfico. O link pode ser enviado com segurança para qualquer pessoa, e o código de incorporação entra em qualquer página como um iframe que mantém a interatividade e os tooltips ao passar o mouse. Edite o gráfico depois e clique em Recreate para levar essas mudanças aos dois.
Export: SVG, PNG ou JPG
O Export grava uma cópia estática no tamanho que você precisar. O SVG continua nítido em qualquer escala e ainda pode ser editado em uma ferramenta de design; PNG e JPG são as escolhas seguras para slides e documentos. É o multiplicador de escala que garante uma imagem nítida em uma tela retina.
Dicas de estilo para um 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.
Erros comuns ao fazer um 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.
Saiba mais sobre o Grouped Bar Chart
Não tem certeza se o Grouped Bar Chart é a escolha certa? Veja o que é, quando usar e quando evitar.
Grouped Bar Chart: perguntas frequentes
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.
Crie seu Grouped Bar Chart agora
Grátis para começar com mais de 300 modelos. Sem cartão de crédito.