Stacked Charts

[frasernm]

Hi,

I'm trying to draw a bar chart with 6 series in each month. For each month of the chart I would like the first 4 series stacked in one bar and the next two series in different bars (on their own - not stacked). Is this combination possible of stacked bars/simple bars possible?

Thanks in advance,

Fraser

 

[jonsi]

Assuming you're using Excel it is easily possible

Taking your data range for the first 4 values in A1, A2,A3 & A4. these you want shown as a stacked bar
your next value, put in B1. Then your final value put in C1

Then to your Graph settings
Your Data range would be =Sheet1!$A$1:$C$4
Series 1 would be =Sheet1!$A$1:$C$1
Series 2 would be =Sheet1!$A$2:$C$2
Series 3 would be =Sheet1!$A$3:$C$3
Series 4 would be =Sheet1!$A$4:$C$4

Effectively your are displaying each bar stacked but the 2nd and 3rd stacks have no data past Series 1 so having nothing to show anything on the bars.

Hope this helps

hwyl
Jonsi

 

[frasernm]

Thanks Jonsi but...

I also need to be able to see more than one month on a time so I have January's 3 columns (columns 4 stacked, 1 column, 1 column), February's 3 columns (columns 4 stacked, 1 column, 1 column) etc...

How would I do this?

F

 

[jonsi]

Quickest way I can see Fraser is to drop all the data cells down one row and insert Jan or Feb above the corresponding columns. Columns A,B & C would all have Jan; D,E & F would have Feb and so on.

This way your Stack colours would all be equal too so you can compare like for like graphically.

looks OK to me on my simple sample

hwyl
Jonsi