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.
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.