Combining clustered and stacked column charts

  • Thread starter Thread starter Okieviking
  • Start date Start date
O

Okieviking

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?
 
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/ExcelTips/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



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

.
Click to expand...
 
Back
Top