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. Prepare a table and group data there.

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

Template

You can download the Template here – Download