A
Anand
Hi,
I am trying to create a column chart using Excel 2007. The data set is
like below
Season Tea Coffee Cold drinks Others
Sec A S 29% 21% 18% 32%
W 18% 29% 32% 21%
Sec B S 21% 31% 28% 20%
W 20% 28% 30% 22%
Sec C S 18% 25% 34% 23%
W 29% 18% 21% 32%
Sec D S 22% 20% 30% 28%
W 29% 18% 32% 21%
I want main category to be Sec A, B, C, and D and then divide into
subcategories S and W for each Sec. Somehow while plotting graph (Bar/
Column) Excel plots only after Sec A as major category. Could someone
suggest what's wrong in my method?
Regards,
Anand Kumar
I am trying to create a column chart using Excel 2007. The data set is
like below
Season Tea Coffee Cold drinks Others
Sec A S 29% 21% 18% 32%
W 18% 29% 32% 21%
Sec B S 21% 31% 28% 20%
W 20% 28% 30% 22%
Sec C S 18% 25% 34% 23%
W 29% 18% 21% 32%
Sec D S 22% 20% 30% 28%
W 29% 18% 32% 21%
I want main category to be Sec A, B, C, and D and then divide into
subcategories S and W for each Sec. Somehow while plotting graph (Bar/
Column) Excel plots only after Sec A as major category. Could someone
suggest what's wrong in my method?
Regards,
Anand Kumar