We have faced an issue while creating charts with multiple groups of bars in excel. it is not as hard as it seems to be.
lets see how the stuff works.
let's suppose we have a data of something like below:
now if we create chart using this data then we will get chart like this.
It looks like cluttered and confusing. you will ask me Is it possible to group all January months together?
short answer is yes and long answer is hell yes!!
Lets see how to create this type of chart.
first of all we will have to delete cells contains of duplicate month names from coloumn A.
after that we will get same as below shown data set.
Now using this dataset if we create excel bar Chart we will get Multiple groups of bars in excel.
to get this type of chart:
1) select data from A1 to C11 (selection will be different if you are using different dataset)
2) From Menu go to> Insert>in Charts Select Column> select desired chart.
3) Chart is ready.
After Little Formatting it will look like this:
Thanks for reading this post.. if you have any questions please reply below..
