cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Choose Language Hide Translation Bar
scottahindle
Level IV

Connect line in graph builder on certain points only

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;

);

 

1 ACCEPTED SOLUTION

Accepted Solutions

Re: Connect line in graph builder on certain points only

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.

View solution in original post

2 REPLIES 2

Re: Connect line in graph builder on certain points only

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.

scottahindle
Level IV

Re: Connect line in graph builder on certain points only

Many thanks, Jed.