Forum Discussion
Excel Axis problems with each renewal of the Excel
Ok, I have questions and I have "Fully agree" (5 in raw data), "Agree" (4 in raw data), "Don't have opinion" (3 in raw data), "Disagree" (2 in raw data), "Fully agree" (1 in raw data) as answers. I want scatterplot or plot with lines as a visual of the answers. And I want questions on the Y axis as texts and answers on X axis as text as well. The guides online are either for old versions, which I also knew how to do it, or the "Switch rows/columns" which doesn't work in my case, as the points are mean and median, and if I switch it, then X axis becomes mean and median, questions becomes legend and Y axis becomes the answers.
I need:
Y axis: questions in the form of text
X axis: answer options in the form of text
points: mean and median from the questionnaire answers
This is what I have, and I don't want to have a vastly wide table. I want vastly long one.
and this is what happens with "switch the rows/columns":
Can someone help me do this with this new **bleep** excel? Thank You in advance.
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
How would you rate the overall facilities that were used in the training? How would you rate the overall facilities that were used in the training: Classroom At the river At the warehouse Were the facilities appropriate for the content of the training: Classroom At the river At the warehouse Were the facilities comfortable: Classroom At the river At the warehouse 1.96 2.52 1.92 1.91 2.08 1.96 1.83 2.64 1.88 2.08 1 2 1 1 2 1 1 3 1 1
