Multiple Stacked Bar Charts

[travbum]

Is something like this possible? I have a bunch of questions of "Do you agree with X" that I need to be able to display side by side and the following is the best I can come up with currently which just isn't that good.

[Anonymous]

Hi,

Does anyone know if it is possible to do Multiple Stacked Bar Charts like that but broken down into time sectors . So In my case I want time periods on the X axis then columns representing different scenarios which is then broken down into stacks which represent different costs.Example drawn badly in paint!

[Anonymous]

Hi,

Does anyone know if it is possible to do Multiple Stacked Bar Charts like that but broken down into time sectors . So In my case I want time periods on the X axis then columns representing different scenarios which is then broken down into stacks which represent different costs.Example drawn badly in paint!

[Sean]

@travbum How is your data organized ? Can you post a sample of your data?

If you can set up the Chart like this you should get the result in the top picture!

Axis - Question

Legend - Answer/Response

Value - Your Measure (counting or summing the responses depending on your setup)

[travbum]

@Sean - I can't say I understand your solution. Here is the data:

UserID	Question1	Question2	Question3
0	Agree a lot	Agree	Neutral
1	Disagree	Agree	Agree
2	Agree a lot	Disagree a lot
3	Disagree	Agree a lot	Agree a lot
4		Disagree	Disagree
5	Agree	Disagree	Disagree
6	Agree a lot		Neutral
7	Agree a lot	Agree	Neutral
8	Disagree	Agree
9		Disagree a lot	Disagree
10	Agree a lot	Agree a lot	Agree a lot
11	Disagree	Disagree	Disagree
12	Disagree		Disagree
13	Agree	Disagree a lot	Agree
14	Disagree	Disagree	Disagree
15	Agree a lot	Agree a lot	Agree a lot
16		Disagree
17	Agree a lot	Agree a lot	Agree a lot

[Sean · Accepted solution]

@travbum As I suspected you have to Unpivot the Data.

With the sample you posted => Edit Queries => select the User ID column => Unpivot Other => Close & Apply

Then set up as my original answer!

[gorli]

Hi,

I have a very similar problem. But when I try to unpivot and apply changes I get an error message saying that the ID cannot be double.

Any idea?

[travbum]

@Sean - Excellent answer thank you so much.