Customizing your grouped column chart
This guide will walk you through the steps necessary to customize a grouped column chart as seen below. We assume that you have already uploaded your dataset into Datawrapper. This chart type helps to display related data or groups of related data, for example, revenue vs. the profit. Ideally, the "grouped" display reveals a clear and easy to understand pattern for the user.
After you've selected " Grouped Column Chart" and while you're still in the tab "Chart type", you might notice that the chart doesn't look anything like in the screenshot above. To change that, try to click on "transpose this data" below the chart type selection, or visit the first part of this tutorial "How to create a grouped column chart" to understand how your data needs to be structured for this chart type.
Once your chart looks similar to the one above, we can start to change its appearance. We will go through three tabs in step 3: Visualize to do so: "Refine", "Annotate" & "Design".
After clicking on the "Refine" tab, the first thing option at your disposal is to specify the values that you want to appear on the vertical and horizontal axis. You have different features available under each axis to customize the appearance of these axes.
For the vertical axis, you can modify:
- custom range: allows you to set your own minimum and maximum values. However, please note that the vertical axis of column chart has been set, by default, to start at zero, meaning that you can only modify the maximum value on this axis.
- show grid lines: depending on whether or not you want to highlight the display of certain values, you can choose to enable or disable this feature
- show axis labels: with the first setting ''Number format'', you can decide how to show your values. Below are three examples but there are many different formats available and choice of a format ultimately depends on how big or small your values are:
- Choose the number format "123.4k" if you have big numbers like "1,303,428" that you'd rather want to display as "1.3m"
- Choose the number format "0.0" if you have very detailed numbers like "0.1922302" that you'd rather want to display as "0.2"
- Choose the number format "0%" or "0.0%" if you have a number that is a relative number, like in our case. This setting will add a percentage sign.
For the horizontal axis, you can:
- sort columns: here you have two settings; sort columns automatically or in reverse order. If you enable the automatic setting, your columns will be arranged in descending order and reversing the order would naturally sort them in ascending order.
- rotate labels: this handy little setting allows you to rotate the labels of your individual columns, in case some of the labels are too long to fit together in a horizontal fashion. Here again, you have the choice to set the rotate option on ''auto'', ''always'' or ''never''.
Next option is ''Appearance'' where you have the option to adjust the colors of your bars. You can click on "customize colors" to assign each bar its own color. When you click on customize colors, you will have a list of labels displayed, together with a color box, depending on how many values you had. Click on a label (e.g. "net profit in mm.") and then on the color box below "Choose a Color". A small popup will open, and you'll be able to choose a new color for your selected label.
You can also "Reset all colors" (to the right) or select all or none colors below the list of labels.
Below the "customize color" feature, you have more options: You can...
- Automatically sort bars. You'll find that the bars appear in the order in your original dataset, so this feature can be helpful to create a different order. In our case, we don't want to automatically sort the bars.
- Reverse order of your bars.
- Show or hide value labels. By default, we only show the value labels on the bars if readers hover of them. Here, you can decide to disable that or to always show the value labels.
If you've created a Datawrapper chart or map before, you already know this feature. Here we can give your chart a title, a description, add notes and a source:
- We recommend using the title to tell your readers the most interesting aspect about this chart – the one key statement that you want your readers to remember from this chart, e.g. "Unemployment highest in the south"
- The description should have as much information about the data as possible: What do we see exactly? E.g. "Unemployment rates in % in all US states, 2016"
- Think of notes as footnotes, where we want to clarify any abnormalities about your data. E.g. "California unemployment rates from Jan and Feb 2016 not included in the calculation."
- The source name will give our readers the information about how trustworthy our data is. Does it come from a government institution or another trustworthy organization? The source URL lets our reader dig even deeper and have a look at the underlying data. Whenever possible, ensure that you provide a source name and source URL for every map or chart to increase transparency. E.g. US Bureau of Labour Statistics, August 2017
In the 2nd panel in the "Annotate" tab, we can emphasize certain variables. To do so, select the element(s) you want to highlight. The rest of the bars will automatically tone down:
In the ''Design'' tab under step 3: Visualize, you can select a preset layout and enable social sharing function to share your work. Users of the Free plan have two options: one layout with and one without the "Get the data" link. Users of Datawrapper's Custom and Enterprise plan have the option to select a custom layout here. The output locale option allows you to choose in which format do you want the decimals, 1000 separators and dates to appear in your visualization.
In the final step 4: Publish & Embed, you have the option to publish the chart either by sharing the URL or by copying the embed code directly on your website or CMS (recommended). You can also download your chart as a PNG (available to all users regardless of the type of subscription plan they have) or a SVG or PDF (available only to users of Custom and Enterprise plan). For more information on the different pricing plans, click here.