362056_en-US

liliconcom

How can add another column of text to a graph?

For example, use "Big Class.jmp".
A text column has been added as follows.
And make a graph, the need to graph the new column text in the graph display.

dt = Open( "$SAMPLE_DATA/Big Class.jmp" );

dt << New Column( "row", formula( Row() ) );
dt << run formulas;
Column( "row" ) << deleteFormula;
dt << Add Multiple Columns( "A", 2, Character, "Nominal" );
Column( dt, N Col( dt ) - 1 ) << set name( "max" );
Column( dt, N Col( dt ) ) << set name( "min" );
Column( "max" ) << Formula(
 If( height == Max( height[Index( Row() - 5, Row() + 5 )] ),
  name
 )
);
dt << run formulas;
Column( "max" ) << deleteFormula;
Column( "min" ) << Formula(
 If( height == Min( height[Index( Row() - 5, Row() + 5 )] ),
  name
 )
);
dt << run formulas;Column( "min" ) << deleteFormula;

c1 = Graph Builder(
 Size( 528, 456 ),
 Show Control Panel( 0 ),
 Variables( X( :row ), Y( :height ) ),
 Elements( Line( X, Y, Legend( 5 ) ) )
);

Thanks Experts!

Mass CustomizationRe: How can add another column of text to a graph?

How can I modify the interval markers to use different colors?

Big Class.jmp uses this script to plot, "B" lists the height values of different ages by the number of rows to start and end.

The "B" column data that needs to be marked with the value of this B column as the interval, but requires the number of rows at the end of the age, is marked in red.

Thank Jim!

dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
dt << Sort( By( age ), Order( Ascending ), replace table );
ca = "B";
r = N Row( dt );
New Column( ca );
Column( ca ) << Formula( If( Row() == r | Row() == 1 | age != Lag( age, 1 ) | age != Lag( age, -1 ), height ) );
dt << run formulas;
Column( ca ) << deleteFormula;

p1 = dt << Graph Builder(
 Variables( X( :weight ), Y( :height ), Group X( :age ), Color( :sex ), Interval( :B ) ),
 Elements( Bar( X, Y, Legend( 7 ), Response Axis( "X" ) ) )
);

 

Re: How can add another column of text to a graph?

By default, in JMP 17, the error bars take on the color specified by the "Color" variable.  In previous versions, the color was only determined by the color setting in the Customize Graph window.  However, only one color can be used.  Therefore, if you set the Error Bar color to Red, both the error bars for M and F would be red.

Re: How can add another column of text to a graph?

OK、Thank Jim!