cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Try the Materials Informatics Toolkit, which is designed to easily handle SMILES data. This and other helpful add-ins are available in the JMP® Marketplace
Choose Language Hide Translation Bar
tobben24
Level I

Use two columns to set a range(start and stop) where y-value is valid

Hi,

 

Title was maybe a bit badly explained, but below I added a simple csv example and a visio plot illustrating what I want. Not sure what to call this kind of plot, or how to use two columns to set a range(start and stop) where y-value is valid.

 
CSV:
Column Y;Column X0;Column X1
20;0;5
30;10;15
 
example.PNG
2 ACCEPTED SOLUTIONS

Accepted Solutions
thickey1
Level III

Re: Use two columns to set a range(start and stop) where y-value is valid

1. Add group column

2. Stack Table by X1,X2

3. Make Overlay Plot

4. Overlay Groups

5. Connect Through Missing

 

May not be the most elegant but kinda gets you what you described

 

overlay.png

View solution in original post

txnelson
Super User

Re: Use two columns to set a range(start and stop) where y-value is valid

Read in the data into JMP

Stack the data either interactively or with the script

Data Table( "Untitled 4" ) << Stack(
	columns( :Column X0, :Column X1 ),
	Source Label Column( "Label" ),
	Stacked Data Column( "Data" )
);

Then run graph builder interactively or by using the script below

Graph Builder(
	Variables( X( :Data ), Y( :Column Y ), Overlay( :Column Y ) ),
	Elements( Line( X, Y, Legend( 5 ) ) ),
	SendToReport(
		Dispatch(
			{},
			"400",
			ScaleBox,
			{Legend Model(
				5,
				Properties( 0, {Line Color( 20 )} ),
				Properties( 1, {Line Color( 20 )} )
			)}
		)
	)
);

Graph Builder.png

 

 

Jim

View solution in original post

4 REPLIES 4
thickey1
Level III

Re: Use two columns to set a range(start and stop) where y-value is valid

1. Add group column

2. Stack Table by X1,X2

3. Make Overlay Plot

4. Overlay Groups

5. Connect Through Missing

 

May not be the most elegant but kinda gets you what you described

 

overlay.png

tobben24
Level I

Re: Use two columns to set a range(start and stop) where y-value is valid

Thanks for your reply, I have now managed to do what I wanted:)
txnelson
Super User

Re: Use two columns to set a range(start and stop) where y-value is valid

Read in the data into JMP

Stack the data either interactively or with the script

Data Table( "Untitled 4" ) << Stack(
	columns( :Column X0, :Column X1 ),
	Source Label Column( "Label" ),
	Stacked Data Column( "Data" )
);

Then run graph builder interactively or by using the script below

Graph Builder(
	Variables( X( :Data ), Y( :Column Y ), Overlay( :Column Y ) ),
	Elements( Line( X, Y, Legend( 5 ) ) ),
	SendToReport(
		Dispatch(
			{},
			"400",
			ScaleBox,
			{Legend Model(
				5,
				Properties( 0, {Line Color( 20 )} ),
				Properties( 1, {Line Color( 20 )} )
			)}
		)
	)
);

Graph Builder.png

 

 

Jim
tobben24
Level I

Re: Use two columns to set a range(start and stop) where y-value is valid

Thanks for your reply as well, as written above I have now managed to do what I wanted:)