28621_en-US

liliconcom

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

 

Re: Use two columns to set a range(start and stop) where y-value is validThanks for your reply as well, as written above I have now managed to do what I wanted:)Re: Use two columns to set a range(start and stop) where y-value is validThanks for your reply, I have now managed to do what I wanted:)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 )} )
   )}
  )
 )
);

 

 

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