Help to Create Clustered Bar Chart

[AlexiosStihl]

Hi there,
it's been years since I had to use Excel in any serious capacity and I've never had much to do with charts/diagrams so please consider me completely devoid of any knowledge of how to do this properly and excuse my absolute ignorance.

I have the results of a short survey:

• ~50 participants
• 5 target groups (designated MA, CNS, SNR, MGR, PTR)
• 9 questions
• 5 response options (numbers from 1-5)

Now I want to create some charts (as few as possible) to show the results to everyone.

For that I would like to use a simple bar chart showing how many people within each target group answered with each of the five response options.
So, basically, I imagine 5 clusters of 5 bars (each cluster encompassing response option 1-5, the bars representing the target groups, the bar height showing the number of people who chose that response option). Yes, that would mean one diagram for each question - no idea how to put that dimension in there as well without screwing up readability.
I've played around for a while, watched a few videos and read a few tutorials but nothing has really helped me create that specific result.

Are there any lovely people around here that could help me out with that?


Thanks in advance
Alex

[AliGW]

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however the thread title does not really convey what your request is about. Tell us what you are trying to do, not how you think it should be done.

Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

(Note: this change is not optional. As you are new here, I have done it for you today)