Hello all:
Some one at work was asking me how to do this and after a few attempts I gave up. Please help if you can.
P Q R S
A1Q1 10% 20% 30% 40%
B1Q1 20% 30% 40% 10%
A1Q2 30% 40% 10% 20%
B1Q2 40% 10% 20% 30%
What they want is:
1. How to make a stack chart with data for P,Q,R,S stacking up in the y direction. I was able to do this very easily with one of the options for the charts. But, it becomes tricky as they want to group A1Q1, B1Q1 data together - adjacent to one another while PQRS is stacked -one on top of the other.
Like wise, they want 1A2,B1A2 to be adjacent to each other, while PQRS is stacked.
Is it possible?
Some one at work was asking me how to do this and after a few attempts I gave up. Please help if you can.
P Q R S
A1Q1 10% 20% 30% 40%
B1Q1 20% 30% 40% 10%
A1Q2 30% 40% 10% 20%
B1Q2 40% 10% 20% 30%
What they want is:
1. How to make a stack chart with data for P,Q,R,S stacking up in the y direction. I was able to do this very easily with one of the options for the charts. But, it becomes tricky as they want to group A1Q1, B1Q1 data together - adjacent to one another while PQRS is stacked -one on top of the other.
Like wise, they want 1A2,B1A2 to be adjacent to each other, while PQRS is stacked.
Is it possible?