Re: How to change x axis values by another column?

[Fred Zhang <ieaggie2009@gmail.com>]

Hi, Mark

 

Thank you very much for the sample code.

I tried your script and ran the following one, but cannot get the lable shown in the X-axis as expected.

 

Anything I missed in the code? Should I add more operations in the Bivariate command?

 

Best,

Feng

 

------------------------------------------------------

dt

= Current Data Table();

labels

= Column(1) << Get Values;

values

= Column(2) << Get Values;

Eval

(Substitute(Expr(Column(2) << Value Labels(vvv,lll);),

Expr

( vvv ),As List( values ),

Expr

( lll ),labels

)

)

;

Bivariate(Y(

:column(3) ),X( :column(2)),Fit Line);

 

------------------------------------------------------ 

ID	X	Y
00Qtr1	1	1.4
00Qtr2	2	1.5
00Qtr3	3	1.46
00Qtr4	4	1.6
01Qtr1	5	1.54
01Qtr2	6	1.58
01Qtr3	7	1.69
01Qtr4	8	1.6
02Qtr1	9	1.62

On Wed, Feb 18, 2009 at 4:59 PM, Mark Bailey <mark4flies@aol.com> wrote:

You want to use the values in column 2 but show the labels in column 1. Here is the script to do it:

dt = Current Data Table();

labels = Column(1) << Get Values;

values = Column(2) << Get Values;

Eval(

Substitute(

Expr(

Column(2) << Value Labels(

vvv,

lll

);

),

Expr( vvv ),

As List( values ),

Expr( lll ),

labels

)

);

Note: not all JMP axes will respect this column property, but I don't know any other way.

On Feb 18, 2009, at 4:24 PM, Fred Zhang wrote:

Sorry not to get your point.

Given this example, which column property to add?

How to do this in JSL?

Mark

They hate you if you're clever, and they despise a fool ("Working Class Hero" - John Lennon)

=