If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
Combining clustered and stacked column charts
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 |
#3
|
|||
|
|||
Combining clustered and stacked column charts
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 . |
Thread Tools | |
Display Modes | |
|
|