Hi all!
I have gathered data through a survey which has the following layout:
NameA | Value 1 | Value 2
NameB | Value 1 | Value 2
NameC | Value 1 | Value 2
NameD | Value 1 | Value 2
...
..
.
All values are between 1 and 5. I would now like to visualize the results using a scatter plot, X axis values 1-5 and Y axis values 1-5.
E.g.: NameA scored 3 in value 1 and 5 in value 2, so there is one datapoint on the scatterplot on 3/5.
For some reason I couldn't figure out how to do that in Excel. Excel keeps auto-summarizing my data on the X axis, but all I want is both scales to be 1-5. I appreciate every input!
Thanks,
David
Bookmarks