cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
JMP is taking Discovery online, April 16 and 18. Register today and join us for interactive sessions featuring popular presentation topics, networking, and discussions with the experts.
Choose Language Hide Translation Bar
natalie_
Level V

Plotting Multiple Data Series Using Graph Builder

Hi all,

I have a feel this isn't possible, but I thought I would ask anyway.  I would like to add different XY data sets to a graph.  The problem is that series aren't sharing the same x values.  What I am trying to do is plot swept data for many transistors and not all of the data has the same number of steps in the sweep.

If Column 1 and Column 2 are my first X and Y values, respectively, and Column 3 and 4 are my second set of X and Y values, respectively.  When I add them to the Graph Builder, instead of getting two plots, I get four.  Column 2 with Column 1, Column 2 with Column 3, Column 4 with Column 1 and Column 4 with Column 3.  I see I have I can remove those from the plot by changing the transparency.  However, I will be doing with with a lot of data and it wouldn't be practical at all to do it manually.  Is there a way to do this with JSL?

Thanks, Natalie

1 ACCEPTED SOLUTION

Accepted Solutions
Phil_Brown
Super User (Alumni)

Re: Plotting Multiple Data Series Using Graph Builder

Actually, as Jim mentioned, this is exactly the stack that's being performed.

 

 

Data Table( "Table" ) << Stack(
columns( :X1, :Y1, :X2, :Y2 ),
Source Label Column( "Label" ),
Stacked Data Column( "Data" ),
Number of Series( 2 )
);

 

 

12066_StackTableGBdt_v2.png

 

As for the Graph Builder, rearranging the parameters produces this:

 

 

Graph Builder(
Show Control Panel( 0 ),
Variables( X( :Data ), Y( :Data 2 ), Overlay( :Label 2 ) ),
Elements( Points( X, Y), Smoother( X, Y ) )
);

 

 

 

12067_StackTableGB_v2.png

 

 

Of course you would have to relabel the "Data" (X1&X2) and "Data2" (Y1&Y2) columns accordingly..

PDB

View solution in original post

5 REPLIES 5
Phil_Brown
Super User (Alumni)

Re: Plotting Multiple Data Series Using Graph Builder

If I'm understanding you correctly, I think if you can stack the data and introduce a grouping variable then you can use that variable as GROUP X in Graph Builder.

12039_StackTableGB.png

Does this look like what you'd want? I can provide more details on the stacking if this is the right direction.

PDB
natalie_
Level V

Re: Plotting Multiple Data Series Using Graph Builder

Hi Philip,

Thanks for getting back to me!  That isn't quite what I had in mind, though.  I took a screenshot of what I am looking for.  This is an example using two sets of data but actually there will be over 100.  Is there an easy way to do this for large sample sizes without manually changing the transparency of the curves?

12065_pastedImage_1.png

txnelson
Super User

Re: Plotting Multiple Data Series Using Graph Builder

Natalie,

I think the solution is to stack your data, as Philip suggested, but you need to do a 2 column stack, where you stack all of your Y columns and all of your X columns.  Then you can run the Graph Builder, and specify the "Label" column that is created in the stacking process, as the Overlay column in the Graph Builder.  It will give you a separate line/curve for each level of "Label"(pair of X and Ys).

Jim
Phil_Brown
Super User (Alumni)

Re: Plotting Multiple Data Series Using Graph Builder

Actually, as Jim mentioned, this is exactly the stack that's being performed.

 

 

Data Table( "Table" ) << Stack(
columns( :X1, :Y1, :X2, :Y2 ),
Source Label Column( "Label" ),
Stacked Data Column( "Data" ),
Number of Series( 2 )
);

 

 

12066_StackTableGBdt_v2.png

 

As for the Graph Builder, rearranging the parameters produces this:

 

 

Graph Builder(
Show Control Panel( 0 ),
Variables( X( :Data ), Y( :Data 2 ), Overlay( :Label 2 ) ),
Elements( Points( X, Y), Smoother( X, Y ) )
);

 

 

 

12067_StackTableGB_v2.png

 

 

Of course you would have to relabel the "Data" (X1&X2) and "Data2" (Y1&Y2) columns accordingly..

PDB
Phil_Brown
Super User (Alumni)

Re: Plotting Multiple Data Series Using Graph Builder

Here's a further example with more series.

In general, the stack becomes:

Data Table( "StackedTable" ) << Stack(
columns(
:age,           // X1
:ratio,       // Y1
:age 1,          // X2
:Predicted ratio,              // Y2
:age 2,                      // X3    
:Predicted ratio 2,            // Y3
:age 3,      // X4
:Predicted ratio 3,            // Y4
:age 4,      // X5
:Spline Predictor for ratio       // Y5
),
Source Label Column( "Label" ),
Stacked Data Column( "Data" ),
Number of Series( 2 )
 
)

 

12069_StackTableGB_v3.png

PDB