Multiple chart types on one chart

[Benny79]

Hi all,


I have a chart with for each month 2 bars : 2006 and 2007. My 2007 bar is a sum of 2 data sets. I would like the 2007 bar to be splitted to represent the sum. Basically im looking for a way to have "group" and "empiled" chart types on a single chart.

Is it possible, and how do I do it ?

Hope I made myself clear, dont hesitate to ask questions.

Thanks,

Ben

 

[PaddyD]

Bonjour!

Can you describe how your data is set up (where on the sheet etc). An example would help...

 

[Benny79]

I have 3 columns (turnover) and 12 lines (months).

For the moment, my chart shows 2006 data (1 column) and 2007 data making 2 bars for each month. The idea is to compare 2006vs2007 month by month.

But my 2007 data is the sum of two columns : i would like the 2007 bar to be split between the two elements of this sum.

I dont want 3 bars for each month, because I want to compare 06vs07.

Is that any clearer ?

 

[PaddyD]

"But my 2007 data is the sum of two columns : i would like the 2007 bar to be split between the two elements of this sum.

I dont want 3 bars for each month, because I want to compare 06vs07. "

Sorry this is taking so long, but still don't get it - describe your data in detail & give us a worked example - consider showing us your data using the html maker:

http://www.mrexcel.com/board2/viewtopic.php?t=92622

 

[Benny79]

Here is a pic of how my data is organised. The 2007 bar represents the "total" column. But the total column is itself the sum of "Comm" + "Laser"
I would like the 2007 Bars to reflect this. So I need 2007 bars to be split in 2, Comm & Laser, the total of the 2 being equal to what it is now.

Sorry again, but this time I cant be any clearer.

Thanks !

Benny

 

[Jan Hoffmann]

Hi Benny79,

Try to set up you table like this:

Diagramexcel.xls
	A	B	C	D	E
1			Realise	Comm	Laser
2	Jan	2006	500
3		2007		300	200
4	Feb	2006	450
5		2007		350	200
6	Mar	2006	450
7		2007		350	200
8	Apr	2006	450
9		2007		350	200
10	May	2006	450
11		2007		350	200
12	Jun	2006	450
13		2007		350	200
14	Jul	2006	450
15		2007		350	200
16	Aug	2006	450
17		2007		350	200
18	Sep	2006	450
19		2007		350	200
20	Oct	2006	450
21		2007		350	200
22	Nov	2006	450
23		2007		350	200
24	Dec	2006	450
25		2007		350	200
Sheet1

 

[Benny79]

Hi Yan,

I have done what youre saygin, but then how do I build the chart ?

 

[Jan Hoffmann]

Hi Benny,

You just select the entire table, as you normally do, and then select "column" as Chart type and "Stacked column" as your sub-type.

I would post a screen dump, but I dont know how, but basically its just the same routine as when you create your standard chart...

I hope you'll work it out...

 

[Jan Hoffmann]

I've uploadet the excelfile I've made: http://www.janhoffmann.dk/Diagramexcel.xls