topic Re: No line break between some of the points in a time series plot in Discussions

No line break between some of the points in a time series plot

scottahindle — Mon, 03 Dec 2018 22:26:41 GMT

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.

Thanks, Scott.

Re: No line break between some of the points in a time series plot

Phil_Kay — Tue, 04 Dec 2018 08:34:22 GMT

Use Sample ID in the Group X role. (see attached)

Re: No line break between some of the points in a time series plot

scottahindle — Tue, 04 Dec 2018 12:42:31 GMT

Thanks, Phil.

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!

Re: No line break between some of the points in a time series plot

Phil_Kay — Tue, 04 Dec 2018 12:46:54 GMT

No problem. Yes, my general advice with Graph Builder is to learn by playing. Try putting variables in different roles and see what happens. You can't break anything.

"Graph builder is a great tool!" - Isn't it just!