Creating charts with groups of stacked bars in Excel 2007

Suppose you have some data for sales of some 4 products (A, B, C, D) for the 4 quarters of a year & for 5 regions in the country, an interesting way to represent it in a graphical format may be a column graph, columns (each presenting a product stacked by location & grouped by quarters…
Here is a step by step guide about how to do it in excel 2007…

1. Arrange the data in the below pattern (this is the most important step :-) ):

   	Mumbai	Hyderabad	Delhi	Kolkata	Chennai
   Q1	20	13				A
   	25	11	0	1	1	B
   	2	1		20	3	C
   	1	1	5	7	4	D
   Q2	31	13				A
   	15	11	0	1	1	B
   	8	1				C
   	4	1		8		D
   Q3	16		10	15	5	A
   		12				B
   	5	2	10			C
   	7	5			12	D
   Q4	30		5	5	5	A
   		13				B
   	10	12	18			C
   				5	5	D

   2. Select the whole data table & go to “Insert” tab & insert a “Stacked Column” graph.
   3. On the design tab go to option “Select Data”, or choose “Select Data” from the right click option menu by clicking on the chart.
   
   
   “Edit” the horizontal Axis Labels and drag & select the last column of your data, i.e. the product names. The legend entries should show the locations, do NOT change that. Click “OK”.
   4. Click on any of the data series (any of the bars) on the graph. Right click & choose the format data series option. Set the gap width to “No Gap” & Close.
   5. Insert blank rows between each quarter in your data table. This will create the gap between each group (each quarter).
   6. The legend will also show an extra color without any text, just select & delete that color.
   7. The chart is ready, additional formatting like adding borders, or adding the quarter numbers can be done selecting options from the layout & design tabs.