Thanks to people's answers I have managed to create a basic correlation
scattergram. I only have 18 participants, each with two values to correlate.
However if two participants have the same results only one point is shown.
Therefore my scattergram only shows eight points when there are 18 values.
Does that make sense? If I was doing it manually I would simply put two marks
where two participants fall, pretty simple, but can't find how to do this in
excel.
Any help would be great.