Chart

[LeeQRS]

Hi All. I need to create a chart that shows the differences in attitude to 5 statements amongst 2 different audiences all on the same chart. Assuming we are going to use a stacked bar.

1) There are 2 different audiences Male & Female so they need to show in the labels on the left.
2) There are 5 statements so the statement label should show to the left of male and female.
3) It is a 5 point scale which can show in the legend.

Any ideas?

Thanks Everyone!

 

[thisoldman]

You can do an internet search for "Likert scale charts".

Cole Nussbaumer Knaflic, author of Storytelling with Data, used 100% scales in her article "Logic in Order": http://www.storytellingwithdata.com/blog/2013/09/logic-in-order

Jon Peltier links to that article and shows many good variations of stacked bar charts for Likert scales in his article, "Charting Survey Results":
https://peltiertech.com/charting-survey-results/

 

[thisoldman]

First attempt, a suggestion for you to try:

Image also posted at: https://www.dropbox.com/s/ti5am2kje79nlxm/likert_first_attempt.png?dl=0

I combined "Question 1" and "Male" into one cell, the two text strings are separated by 6 spaces. Ditto for "Question 2" and "Male". This gave the best axis labeling, to my eye.

The blank row between populated rows creates the separation between question sets.

I selected all six rows and eleven columns, and chose 100% Stacked Bar from the Insert tab. I then brought up the right-click chart context menu, chose "Select Data..." and pressed the "Switch Row/Column" button. The rest was just formatting.

You're on your own for color choices—I'm not happy with these colors but it separates male and female. The "Neutral" color is the same for all the stacked bars.