Forum Discussion

travbum's avatar
travbum
Advocate I
9 years ago
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 currently which just isn't that good.

 

Need Help
  • Sean's avatar
    Sean
    9 years ago

    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!

     

     

     

7 Replies

  • Sean's avatar
    Sean
    Community Champion
    9 years ago

    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's avatar
      travbum
      Advocate I
      9 years ago

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

       

      UserIDQuestion1Question2Question3
      0Agree a lotAgreeNeutral
      1DisagreeAgreeAgree
      2Agree a lotDisagree a lot 
      3DisagreeAgree a lotAgree a lot
      4 DisagreeDisagree
      5AgreeDisagreeDisagree
      6Agree a lot Neutral
      7Agree a lotAgreeNeutral
      8DisagreeAgree 
      9 Disagree a lotDisagree
      10Agree a lotAgree a lotAgree a lot
      11DisagreeDisagreeDisagree
      12Disagree Disagree
      13AgreeDisagree a lotAgree
      14DisagreeDisagreeDisagree
      15Agree a lotAgree a lotAgree a lot
      16 Disagree 
      17Agree a lotAgree a lotAgree a lot
      • Sean's avatar
        Sean
        Community Champion
        9 years ago

        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!

         

         

         

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    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's avatar
    Anonymous
    Not applicable
    9 years ago

    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!