Exemple de CSV
| 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.
Environ 8 minutesThis 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.
Les données dont vous avez besoin
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.
Les étapes
Le parcours exact dans PlotSet, d'un modèle vierge à un graphique terminé.
- 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.
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 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 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
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.
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
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.
L'onglet 'Preview' pour un graphique Grouped Bar 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. - 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.
Partez du modèle Grouped Bar 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 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.
Erreurs courantes en créant 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.
En savoir plus sur le Grouped Bar Chart
Vous n'êtes pas sûr que le Grouped Bar Chart soit le bon choix ? Découvrez ce que c'est, quand l'utiliser et quand l'éviter.
Grouped Bar Chart : questions fréquentes
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.
Créez votre Grouped Bar Chart maintenant
Gratuit pour commencer avec plus de 300 modèles. Aucune carte bancaire requise.