Combining clustered and stacked column charts

I am trying to plot a set of cost data. I am looking at
planned cost versus actual cost (clustered) for several
projects. Both the actual and the planned costs are made
of several different types of costs that need to be noted
on the chart (stacked column). Is there a way of
combining the two chart types? (What I am envisioning is
a cluster for each project, where one column is planned
cost and the other is actual cost; and each column is in
itself a stacked column.)

Does anyone have another idea of how to plot this?

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 the following MSKB article has an example:
XL2000: Creating Charts with Multiple Groups of Stacked Bars
http://support.microsoft.com/default.aspx?id=214119

Okieviking wrote:
I am trying to plot a set of cost data. I am looking at
planned cost versus actual cost (clustered) for several
projects. Both the actual and the planned costs are made
of several different types of costs that need to be noted
on the chart (stacked column). Is there a way of
combining the two chart types? (What I am envisioning is
a cluster for each project, where one column is planned
cost and the other is actual cost; and each column is in
itself a stacked column.)

Does anyone have another idea of how to plot this?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Thanks! It looks great!

-----Original Message-----
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 the following MSKB article has an example:
XL2000: Creating Charts with Multiple Groups of
Stacked Bars
http://support.microsoft.com/default.aspx?id=214119

Okieviking wrote:
I am trying to plot a set of cost data. I am looking
at
planned cost versus actual cost (clustered) for several
projects. Both the actual and the planned costs are
made
of several different types of costs that need to be
noted
on the chart (stacked column). Is there a way of
combining the two chart types? (What I am envisioning
is
a cluster for each project, where one column is planned
cost and the other is actual cost; and each column is
in
itself a stacked column.)

Does anyone have another idea of how to plot this?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

.