Stacked Bars

[Mike]

Hi. I would like to create a stacked bar chart that
actually has two stacked bars for each "X" category.

Series 1 is in b3 through b7
Series 2 is in c3 through c7
Series 3 is in d3 through d7
Series 4 is in e3 through e7

I would like to stack series 1 and 2 together and series
3
and 4 together.

Is there a way to do this?

Thanks,
Mike.

..

 

[Debra Dalgleish]

If you stagger your data, you can create side-by-side stacked columns.
Jon Peltier has links to instructions on his web site:

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

 

[Mike]

Debra:

Thanks for your help! I also found some similar
instructions at
http://www.stfx.ca/people/bliengme/ExcelTips/Columns.htm

Mike.