Create Stacked column of multiple values across categories

[Elynn]

Current Excel is able to create stacked column bars charts only on a single
value across categories, eg, X-axis - Jan, feb, etc, only one stacked bar.

Any advise if it is possible to create "stacked colums" comparing "valueS
across categories"? (Eg, X-axis - Jan will consite of a few stacked column,
feb same few stacked columns, etc)

 

[Andy Pope]

Hi,

Links to cluster/stacks can be found here.
http://peltiertech.com/Excel/ChartsHowTo/ClusterStack.html

Cheers
Andy

 

[Elynn]

Hi Andy,

thank you.
The example shows up to 2 axes (Pri and Secondary) to plot 2 stacked column
bars. However, I need to plot 4 columns bars. Possible?

 

[Elynn]

Hi again! I got the method. Thanks!

Hi Andy,

thank you.
The example shows up to 2 axes (Pri and Secondary) to plot 2 stacked column
bars. However, I need to plot 4 columns bars. Possible?