Can I get multiple stacked bars per entry on a stacked bar chart?

[Cheezeman]

With a regular bar chart, a bar wil appear for each, say, month on a regular
bar chart. If I define three series on a regular bar chart, I get three bars
for each entry. Can I achieve the same thing on a stacked bar chart. Every
series defined just adds to the stack of the bar.

 

[Dave Curtis]

Hi,

The trick is in knowing how to set out your source data.
Look at Jon Peltier's web site. He has several nice examples.

Dave

 

[Cheezeman]

What is his website?

Hi,

The trick is in knowing how to set out your source data.
Look at Jon Peltier's web site. He has several nice examples.

Dave

 

[Dave Curtis]

Try here:

http://peltiertech.com/Excel/ChartsHowTo/ClusterStack.html

or Andy's site, here

http://www.andypope.info/charts/stackside.htm

Dave

 

[Jon_Peltier]

I've updated my Clustered-Stacked Column Chart article, and it's now located at Clustered-Stacked Column Charts.