Scatter XY Diagram problems getting it to show as required
Posted on 2014-01-26
I am having problems getting my data to display as I need it,
if for example I have 8 users which should be shown on the horizontal line, and the vertical is time anything from say 0 to 20 seconds. Each user has upto 125 samples of times, the times should then be shown in a tower above each of the users.
However, when I select my data as below, the scatter diagrem spreads the times accross all of the users for each sample.
1 2.97 3.2 4.1 >>> etc upto 125 samples
2 <<< same as above for each user upto 125 samples
Basically I need it so that when I select the data from above and then choose scatter graph, it shows users 1 - 8 accross bottom, then time on the vertical line, then towers of the individuals 125 samples above there user number.