Help with creating a particular type of chart

MrRockliffe · 9 May 2020 at 18:11

Hi all

Currently doing some analysis on some questionnaires.

One of the questions involved participants to rank particular skills from most to least important.

I used MS forms to send this out, which provides a very nice way of representing data: https://prnt.sc/sds06x

My question is: how do I do this on Excel?

Thanks in advance

Salsa · 9 May 2020 at 18:17

Looks like a 100% stacked bar chart. Pretty simple with chart wizard in Excel

/Salsa

MrRockliffe · 9 May 2020 at 19:32

Salsa said:
Looks like a 100% stacked bar chart. Pretty simple with chart wizard in Excel

/Salsa

Problem I have is that I'm dealing with the order of words representing my data rather than numbers. I presume that I have to convert to numbers so do it, but hoped there would be a quick way

Salsa · 9 May 2020 at 21:05

You could perhaps use a pivot table/chart to count the number of times each word was ranked for each number.

Hard to say for sure without seeing how the data is structured.

/Salsa

MrRockliffe · 9 May 2020 at 22:53

Managed to do it:

https://prnt.sc/sdw9ih