How to create a chart with grouped data?

This time you will teach yourself how to group data in your chart. The Excel tutorial may be useful for preparing consolidated chart for report or some kind of summary.

1. Consider a grouped data like shown below.

data table

2. Select data and under Insert option in toolbar, In Column select first option.

insert column chart

3. Now in Toolbar under Design option, select Change Chart Type option.

Change Chart Type

4. Choose Stacked Column option.

stacked column

5. Here you have your chart for grouped data.

chart for grouped data ready