Hi,
I want to visually compare four categories of numerical data.
See dummy file attached.
The data is cognitive test results ranging theoretically from about 50 to 150.
There are four categories: verbal, nonverbal, speed, and attention.
I want to show these categories on the x-axis.
The y-axis will show numerical labels 50 to 150 with every 10 points indicated.
I want the data for verbal scores to be plotted individually above the verbal label.
I want the data for nonverbal scores to be plotted individually above the nonverbal label, and so on.
If two people have the same verbal score, I want it so they are plotted one on top of the other above the "verbal" label.
I want to visually compare the different groups.
Scatterplots in Excel appears to assume I want to correlate one value with another.
I *don't* want to correlate anything.
How do I do this?
Would appreciate any help.
Regards,
Dougal
Bookmarks