Graph Help - Customise??

[Lotus Cars]

Right folks, you've never let me down before....

I have a graph that I need to make. it's a stacking bar graph, one value on the other. Data laid out as so

April May June
Actual CoS 20 30 15
Actual Margin 5 10 7
Budget CoS 19 33 21
Budget Margin 6 12 10

I followed the wizard for the stacking one, but that stacked all four on top of each other. What i want is the 2 actuals stacked, and the 2 budget stacked next to it, within the month.

I'm running excel 2003 if that's any help too!

Any help would be greatly appreciated.

Cheers,

Lotus Cars.

 

[baitmaster]

try inserting some columns and offsetting the results a bit, leaving some blank cells in your data table too:

April actual - April budget - May actual - May budget etc
20 - blank - 30 - blank etc
5 - blank - 10 - blank etc
blank - 19 - blank - etc

 

[GlennUK]

Arrange your data like this:

Excel Workbook
	N	O	P	Q	R	S	T	U	V
3		April Actual	April Budget		May Actual	May Budget		June Actual	June Budget
4	CoS Actual	20			30			15
5	Margin Actual	5			10			7
6	CoS Budget		19			33			21
7	Margin Budget		6			12			10
Sheet1

... make the Gap 0%. Alter series colours to match, and change any text that you don't like.

 

[Lotus Cars]

Thanks both.

Glenn, yours was more what i was looking for, thanks. baitmaster, all I could get was still the four stacking on top of each other, but looking back i think you had the same idea as Glenn.

I'm surprised you can't do somehting like this though easily..

http://imageshack.us/photo/my-images/23/graphsk.jpg/