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?!?

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/E...ps/Columns.htm

and Jon Peltier has links to other sites with information:

http://peltiertech.com/Excel/ChartsH...sterStack.html


hrussell wrote:
> 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
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html