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. Click the "Insert Column or Bar Chart" button open a menu.
  5. Click 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. Right click on chart.
  2. Click "Select Data..."
  3. Click the "arrow" button to select a new chart data range.
  4. Select the data.

The chart changes to something like this.

Download Excel *.xlsx file

Group chart categories.xlsx