Dont know how to use my data in my graphs

yes thank you that works now, but I still dont see how I can achieve what I want with whisker/box charts? im not very experience with them.

I Have three groups that I want to compare and all these threee groups have chosen different answers ranging from 1-4 in this example, now I want to show the differences in answers of these groups while also showing average and standar deviation of the induvidial groups. And these average/stdav lines I want are the average/stdav of the choices 1-4

So if group 1 answers mostly 4 the average moves towards 4 etc, my xslx file in the original post might help, I dont see how the whisker chart will achieve this?

tldr: What im saying is, how could I convert my original method shown in the original picture to whisker/box chart? Or just implement the avg/stdav in the original pictures method somehow?