Multiple stacked bar charts

[Gargamil]

I have a project where i have to chart the compliance of three groups over a
number of months. So for each data set there is a Compliance#1 stacked upon
NonCompliance#1, then Compliance#2 stacked upon NonCompliance#2 and finally,
you guessed it, Compliance#3 stacked upon NonCompliance#3.
When i design a chart in excel it wants to place everything on top of each
other producing one column of six not the required three columns of two for
each week in the display. Can anyone point me i the right direction for
this one??

 

[Nicky]

Hi
you can achieve this effect by having two layers in your x axis
the attached may be what you're afte

Attachment filename: stacked side by side chart.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=45403

 

[Nicky]

Hi
you can achieve this effect by having two layers in your x axis.
The attached may be what you're after

Attachment filename: stacked side by side chart.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=45404

 

[Gargamil]

Nicky,

That's got it thanks. at the risk of stretching the friendship is there
any way to have different colour combinations for each of the groups

Rod

 

[Nicky]

Hi,

The easiest way might be to change the colours by hand or with a simpl
macro, eg

Sub colour_charts()

group1col1 = 11
group1col2 = 32
group2col1 = 42
group2col2 = 4
group3col1 = 30
group3col2 = 3


For n = 1 To ActiveChart.SeriesCollection(1).Points.Count Step 3
ActiveChart.SeriesCollection(1).Points(n).Interior.ColorIndex
group1col1
On Error Resume Next
ActiveChart.SeriesCollection(1).Points(n + 1).Interior.ColorIndex
group2col1
On Error Resume Next
ActiveChart.SeriesCollection(1).Points(n + 2).Interior.ColorIndex
group3col1
Next

For n = 1 To ActiveChart.SeriesCollection(2).Points.Count Step 3
ActiveChart.SeriesCollection(2).Points(n).Interior.ColorIndex
group1col2
On Error Resume Next
ActiveChart.SeriesCollection(2).Points(n + 1).Interior.ColorIndex
group2col2
On Error Resume Next
ActiveChart.SeriesCollection(2).Points(n + 2).Interior.ColorIndex
group3col2
Next

End Sub


Or, you need a separate item in the stach for each group's return.
(see attached

Attachment filename: multiple stack.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=45539