Combining clustered and stacked column charts

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

OkieViking

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

.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top