How to create a grouped bar chart
The bar chart is probably the most all-rounder chart type out there. But sometimes, your bars fall into categories (like continents, regions or countries, positive or negative growth or years), which you really want to show to make your statement. Grouped bar charts are perfect for that. In Datawrapper, we have a chart type called "Grouped bars" but any kind of bar chart can be turned into a grouped bar chart.
In this tutorial, you will learn how to prepare and upload your dataset to create a grouped bar chart with Datawrapper.
If you want to create a simple bar chart in Datawrapper, please refer to our tutorial "How to create a bar chart".
-
Preparing and importing the data
Your data needs to be in a certain format for Datawrapper to create a grouped bar chart. You'll need three columns:
- Descriptive labels in the first column.
This will determine the label in front of each bar. In our case, these are the countries. - Corresponding values in the second column.
These values need to be numeric in order to determine the length of each corresponding bar. In our case, the values are road fatalities. - Categories in the third column.
With these categories, you decide what each bar will be grouped by. In our example, we chose to group the countries by continent.
Country Road fatalities per 100,000 motor vehicles Continent Mexico 43 North America Italy 7.3 Europe Switzerland 4.7 Europe Singapore 20.2 Asia - Descriptive labels in the first column.
Tips
- These columns don't need to be in this exact order: Datawrapper will automatically plot the column with the numeric values; no matter if they're in the first, second or third column.
- You can upload more than three columns and later choose which column you want to set as your labels, values, and groups. And the rows don't need to be in the exact order (you can sort them later).
- Make sure that the category names don't include unnecessary white space. (e.g.
Europe
. andEurope
with white space at the end will be interpreted as two separate groups)
Check & Describe
In the second step, you can check if your dataset was imported correctly and make changes to it - if necessary. If you don't have a header, you have to untick "First row as label" to avoid losing your first row of data. Always remember to do this if you don't have descriptive row and column headers.
By selecting a certain output locale, Datawrapper chooses the correct decimal and thousand separators for you.
Click on "Proceed" to get to the visualization process.
Visualize
In this section, you have four tabs: "Chart Type", "Refine", "Annotate" and "Design". If Datawrapper did not automatically choose a bar chart for this data, you can click on the icon for "bar chart" in the upper-left corner of the "Chart Type" tab:
Now you will see your data in form of a bar chart – although not as a grouped bar chart yet. Since the tool can't be sure that you want a grouped bar chart, we will need to tell Datawrapper that. To do so, click on the tab "Refine". At the bottom, you'll see the feature "Group bars by column". If it's not already open, click on it to open this feature and you will see the following options:
Here you can choose which column you want to have your bars grouped by. Since we want the bars to be grouped according to the continent, we will select "Continent". You also have the option to show group labels and bar labels too. Try them out yourself to see what happens!
Remember, Grouping is possible in any of our bar charts (split bars, stacked bars, bullet bars)!
Once you do that, you arrive at a grouped bar chart! From here you can customize your bar chart. We cover this in another article titled: "Customizing your bar chart".