Hello, yes ive tried to create a plot like this and it doesn really work well with my groups when I try it. I dont see how Its possible to see the answer choices 1-4 for each group in a whisker chart.

Some have said that I could try and add columns to my original chart and use them as the lines I showed in the picture, is that possible? how could I do that? If anyone can create a small example for me in excel using my xslx linked file or your own to show me I would really appreciate it cause I cant figure this out, either my design or a whisker/boxplot.