Forum Discussion
Solved
Multiple Stacked Bar Charts
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 currentl...
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)
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 |
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!
