Create Stacked column of multiple values across categories
 

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)

Create Stacked column of multiple values across categories
 

Hi,

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

Cheers
Andy

Elynn wrote:
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, Microsoft MVP - Excel
http://www.andypope.info

Create Stacked column of multiple values across categories
 

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?

"Andy Pope" wrote:

Hi,

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

Cheers
Andy

Elynn wrote:
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, Microsoft MVP - Excel
http://www.andypope.info

Create Stacked column of multiple values across categories
 

Hi again! I got the method. Thanks!

"Elynn" wrote:

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?

"Andy Pope" wrote:

Hi,

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

Cheers
Andy

Elynn wrote:
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, Microsoft MVP - Excel
http://www.andypope.info