Creating a combination chart using cluster column & stacked bar t.

[Guest]

I need to create a combination chart, using cluster column and stacked bar
types. I need to "cluster" two columns side by side without space in
between, with stacked bars within each of these columns. Then, have space
along the x axis, and have 2 more columns clustered made up of stacked bars
within.

I am charting 2 years side by side, with different types of data within the
columns, so need to stack/segment the column.

How do I create and combination chart, and how do I select these 2 types to
combine together?

HELP, PLEASE?!?

 

[Debra Dalgleish]

If you stagger your data, you can create side-by-side stacked columns.

Bernard Liengme has an example and instructions on his site:
http://www.stfx.ca/people/bliengme/ExcelTips/Columns.htm

and Jon Peltier has links to other sites with information:

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