I have data from a regular customer satisfaction question, "How satisfied are you?" ranked from 1 to 7, where 7 is very satisfied and 1 is the opposite. I have 82 responses for "7", 28 responses for "6", 15 responses for "5", 9 responses for "4", 5 responses for "3", 1 response for "2", and no responses for "1" in terms of the level of satisfaction. The total number of respondents is 140. If I want to display the satisfaction score 1-7 on the vertical axis, how do I make the horizontal axis bars appear as proportionally sized to the total number of respondents, and proportional relative to each other in Excel? |
<tbody>
</tbody>