Author: Oscar Cronquist Article last updated on August 29, 2018

The image above shows you categories (countries) grouped into regions making this chart a lot cleaner and easier to read.

How to construct

This image shows the countries in a simple column chart without groups and the data used to build the chart. Follow these steps to group the categories (countries).

  1. Insert a new column before the Category column (Country).

    Column B contains the group names, however, they are located at the very first category (country) name and there is only one instance.
  2. Select the data.
  3. Go to tab "Insert" on the ribbon.
  4. Press with left mouse button on the "Insert Column or Bar Chart" button open a menu.
  5. Press with left mouse button on the "Clustered Column Chart" button.
  6. Change the chart title, resize the chart so the category names may fit the chart area without being rotated if you prefer.

Adjust chart data range

If you already have a chart created you simply need to change the chart data source.

  1. Press with right mouse button on on chart.
  2. Press with left mouse button on "Select Data..."
  3. Press with left mouse button on the "arrow" button to select a new chart data range.
  4. Select the data.

The chart changes to something like this.

Get Excel *.xlsx file

Group chart categories.xlsx