Frequency distribution of a questionare
Hi
I want to do a view of the answer distribution in a questionnaire.
There are roughly 35 questions where respondents rate from 1-9
For each question I want to display bins and the response rate in those bins.
This is my data structure:
| Question 1 | Question 2 | Question 3 | Question 4 | Question 5 | Question 6 | Question | |
| Respondent 1 | 7 | 7 | 6 | 7 | 8 | 6 | 8 |
| Respondent 2 | 8 | 8 | 8 | 8 | 7 | 7 | 6 |
| Respondent 3 | 7 | 5 | 4 | 6 | 8 | 5 | 3 |
| Respondent 4 | 8 | 8 | 8 | 8 | 6 | 7 | 8 |
| Respondent 5 | 6 | 8 | 6 | 7 | 8 | 7 | 6 |
| Respondent 6 | 6 | 7 | 4 | 5 | 4 | 5 | 3 |
| Respondent 7 | 6 | 7 | 5 | 7 | 5 | 6 | 5 |
It seems trait forward but Im doing something wrong. I get the result from Question 1 in all the bars:
