SPSS Statistics

SPSS Statistics

Your hub for statistical analysis, data management, and data documentation. Connect, learn, and share with your peers! 

 View Only
Back to discussions
Expand all | Collapse all

Possible to create a clustered bar chart showing percentage of sub-group selecting each choice in a multiple response set?

  • 1.  Possible to create a clustered bar chart showing percentage of sub-group selecting each choice in a multiple response set?

    Posted Tue September 05, 2023 12:30 PM

    When making a clustered bar chart using a multiple responses set, with Statistic set to Percentage and the Denominator set to Total for Each X-Axis Category, the percentages appears to be calculated by the total number of choices selected by each sub-group rather than the percentage of the sub-group who selected each choice.

    What I want, for example, is if 100% of a sub-group 1 select choice A, 50% select choice B, and 12% choice C, then I want the chart to show bars of 100%, 50% and 12% respectively for sub-group 1.

    Instead what I'm getting is if 100% of a sub-group consisting of 10 respondents select choice A, and they make 50 choices in total, then choice A has a bar of 20%.

    Is there a way to accomplish what I want?



    ------------------------------
    Seán Adams
    ------------------------------


  • 2.  RE: Possible to create a clustered bar chart showing percentage of sub-group selecting each choice in a multiple response set?

    Posted Fri September 08, 2023 08:05 PM

    Workaround:

    Multiple Response > Crosstabs > create relevant crosstabulation > double-click on crosstab table > right-click table > Create Graph > Bar > copy graph to Word as Microsoft Office Graphics Object

    Alternatively the crosstab table can be copied to Excel and the graph made there (I found this quicker for my needs).



    ------------------------------
    Seán Adams
    ------------------------------

    Original Message