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

[Fred Zhang <ieaggie2009@gmail.com>]

Gunter

 

I tried the label way (your second option), however, the labe was plotted nearby each data point in the plot, which is kind confusing

for clear reading when data is too many.

 

I tried to your first way, and could  not change the X axis values.

 

Fyi, below is the actual data set I am struggling to play with:

Col_1   Col_2   Col_3
2002Q1  1    $10,321,748.00
2002Q2  2   $19,915,230.00
2002Q3  3 $20,987,276.00
2002Q4  4 $20,125,680.00
2003Q1  5 $14,597,380.00
2003Q2  6 $55,674,214.00
2003Q3  7 $45,984,240.00
2003Q4  8 $27,089,594.00
2004Q1  9 $29,736,450.00
2004Q2  10 $27,643,088.00
2004Q3  11 $40,563,884.00
2004Q4  12 $7,075,460.00
2005Q1  13 $30,936,556.00
2005Q2  14 $45,526,980.00
2005Q3  15 $22,478,234.00
2005Q4  16 $12,827,448.00
2006Q1  17 $17,117,044.00
2006Q2  18 $33,171,076.00
2006Q3  19 $25,583,560.00
2006Q4  20 $19,264,096.00
2007Q1  21 $10,176,806.00
2007Q2  22 $7,473,890.00
2007Q3  23 $33,131,164.00
2007Q4  24 $8,752,966.00
2008Q1  25 $5,125,902.00
2008Q2  26 $2,590,852.00
2008Q3  27 $2,224,410.00
2008Q4  28 $247,862.00

On Wed, Feb 18, 2009 at 4:54 PM, <Gunter.Hartel@csl.com.au> wrote:

there is a workaround that might be close enough to what you want:  make Col_1 a label column and then select all the rows and select label and then when you plot col_2 vs Col_3 each point is labnelled with Col_1. 

 

:Col_1 << Label( 1 );
For Each Row( Labeled( Row State() ) = 1 );
Bivariate( Y( :Name( "   Col_3" ) ), X( :Col_2 ), Fit Line() );

Cheers

Gunter

---

From: jmp-l-owner@lists.biostat.wustl.edu [mailto:jmp-l-owner@lists.biostat.wustl.edu] On Behalf Of Fred Zhang
Sent: Thursday, 19 February 2009 8:24 AM

To: jmp-l@lists.biostat.wustl.edu
Subject: Re: [jmp-l] How to change x axis values by another column?

Mark

 

Sorry not to get your point.

Given this example, which column property to add?

How to do this in JSL?

 

Thanks,

Feng

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

Did you try adding the Value Labels column property? This way you associate the desired label with each numeric value.

Mark

On Feb 18, 2009, at 2:17 PM, Fred Zhang <ieaggie2009@gmail.com> wrote:

Hi, I have the following 3 columns:

Col_1          Col_2            Col_3
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
...                ....                 ...
08Qtr4        28                   2.48
I have tried Fit Y(Col_3) by X(Col_2), because both are numeric data type, for linear regression.
In the picture box or plot, I want to repley X axis values {1, 2, 3, 4, ....} by
the values of Col_1, i.e. {00Qtr1, 00Qtr2, 00Qtr3, ...}

So how to revise the following JSL code to do that?

Thanks,
Fred
-----------------------------------------------------------------------------------------------
 biv Bivariate(
 Y( : Col_3 ),
 X( : Col_2 ),
 Fit Line( {Line Color( "Red" )} ),
 SendToReport(
 Dispatch(
  {},
  "1",
  ScaleBox,
  {Scale( Linear ), Format( "Best" ), Min( 1 ), Max( 28 ),
  Inc( 4 )}
 ),
 Dispatch(
  {},
  "2",
  ScaleBox,
  {Scale( Linear ), Format( "Numeric" ), Min( 0 ),
  Max( 2.5 ), Inc( .5 )}
 ),
 Dispatch( {}, "Bivar Plot", FrameBox, Marker Size( 2 ) )
 )
);

 

***************************************************************************************************************

 

This email and any attachments are confidential and may be subject to legal or other professional privilege. Any confidentiality or privilege is not waived or lost because this email has been sent to you by mistake. You should not read, copy, adapt, use or disclose them or their contents without authorisation. Any personal information in this email must be handled in accordance with the Privacy Act 1988 (Cth).

If you are not an intended recipient, please contact us at once by return email and then delete both messages.

 

 

CSL Limited A.C.N. 051 588 348

45 Poplar Road Parkville Victoria 3052 Australia

Phone: +61 3 9389 1911 Fax: +61 3 9389 1434

***************************************************************************************************************