Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Stacked Clustered Column?
Hi,
I have a 5 variable chart/graph requirement and I cannot find how to build it in Excel. I have 5 categories, lets say P,C,F,B,CV I have 2 sections, say A and B I have a result per section per period and tow periods, say Q1 and Q2. Ideally I would have Result A B A B A B P C F ... etc and then the column for A would show Q1, Q2 results as a stack, column B would show Q1 & Q2 for it as a stack. So, 5 categories, section A: Results for Q1 and Q2 , section B: Results for Q1 and Q2 ... 5 variables. Now Excel 2010 seems to have Clustered Columns (so I can get A & B per category) and Stacked Columns (so I can get section A: Results for Q1 and Q2) but it does not have both. Has anyone got any idea how to show 5 variables on a graph in Excel 2010? Thanks, Dave |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Stacked Clustered Column?
Hi Dave
I think this is what you mean and it works for 2007 so probably does for 2010. In C1 and D1 put Q1, Q2 In A2, 4, 6,... put your 5 main categories P, C F ... down to A10 In B2, 3, 4, 5, ... put A, B, A, B, ... down to B11 In cols C and D put your data down to row 11. Highlight A1 to D11. Everything. Insert - Column - 2D - Stacked. xt |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Clustered and Stacked Column Chart | Excel Discussion (Misc queries) | |||
Clustered stacked column | Charts and Charting in Excel | |||
How do I set up a clustered stacked column graph? Is it possible? | Charts and Charting in Excel | |||
How to mix a stacked column and a clustered one on same graph? | Charts and Charting in Excel | |||
combination of stacked and clustered column | Charts and Charting in Excel |