Charting: 2 sets of stacked bars in the same chart

[MVF]

Hi All!
My question is that I have six rows of data. I would like to generate a chart with 2 stacked bars over a date range, with each stacked bar containing 3 rows of data. Ideally, the 2nd stacked bar is against a secondary Y axis.

I know how to set up a secondary axis, and have put rows 3-6 against it, but how do I stack them and keep them together? Same with stacking data rows 1-3 on the primary?

Any help would be most appreciated!!

 

[Andrew Poulsom]

You need to set out your data like this:

Excel 2003
	A	B	C
1		Col1	Col2
2	Row1	1
3	Row4		10
4	Row2	2
5	Row5		20
6	Row3	3
7	Row6		30
Sheet2

 

[MVF]

Thank you!!!