I have a series of measurements where in order I have position A, B, C, then again A, B, C and so on.
Of interest is whether there is any tendency for values to be biggest/smallest at either A or C position. This is not the case - the fluctuations are just random.
Now I'm thinking of how to present the outcome in a suitable graph.
I would like to use a line break between each set when plotting the graph, meaning:
- Add line between points 1 and 2, and 2 and 3
- No line between points 3 and 4
- Add line between points 4 and 5, and 5 and 6
- No line between points 6 and 7
AND SO ON to the end of the data set
What I have done is attached, but it is rather cumbersome and is also just a subset of the total data. I have to drag each x-axis separately and then format each separately as well.
Is there a quicker way to this than I've described above and shown in attached? My method works but it doesn't seem very optimal with so many manual steps involved.
Hence, key question: If I plot the data in sequence order, what is the best way to get a graph where some of the points are connected with a line, and some of the points not connected? Adding lines in a selective manner makes the graph easier to read and more informative. Connecting all the points makes the graph much less useful.
This morning I also used Overlay to create the desired effect in terms of the "picture". The advantage is that there is just "one" x-axis to work with which makes things a bit easier.
Graph builder is a great tool!