Connect line in graph builder on certain points only

[#1]

Hi all,

In attached you see in the first column 40 values. Working down by row you see the values are labelled as replicate 1 or replicate 2 (these are values from duplicate measurements).
My wish was to connect with a line each pair of duplicate values; this is seen in the graph "Connected". To do this I ran the script below to add rows and then choose the option "No connection" for missing values. (The fourth and fifth columns in the attached data table.)

Is there an easier way to do this? Graph builder can do so many things and may well offer a more direct/easier way to achieve what I was seeking to achieve.

Many thanks, Scott.

Names Default To Here(1);

dt = Current Data Table();
intCounter=2;

For(i=1,i<=19,i++,

	dt << Add Rows( 1, after( intCounter ) );
	intCounter = intCounter + 3;

);

[#2 · Accepted solution]

If you add a "Trial" column to your data table, then there are at least 2 ways to do this.

The Graph Builder can do it (it defaults to a separate color for each trial; I selected all, then broadcast a color change to black):

Jed_Campbell_0-1676568071737.png

The Variability Chart in the 'Quality and Process' menu has this functionality built in. 

Jed_Campbell_1-1676568140273.png

I attached an updated copy of your data table with scripts saved for each method.

[#3]

Many thanks, Jed.