topic Re: Connect line in graph builder on certain points only in Discussions

Connect line in graph builder on certain points only

scottahindle — Thu, 08 Jun 2023 16:35:16 GMT

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;

);

Re: Connect line in graph builder on certain points only

Jed_Campbell — Thu, 16 Feb 2023 17:24:38 GMT

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):

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

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

Re: Connect line in graph builder on certain points only

scottahindle — Thu, 16 Feb 2023 20:38:43 GMT

Many thanks, Jed.