How To Create A Chart With Grouped Data

How To Create A Chart With Grouped Data

1. Prepare a table and group data there.

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

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

4. Choose Stacked Column option.

5. Here you have your chart for grouped data.

Template

Further reading: 
Basic concepts 
Getting started with Excel
Cell References