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

[Fred Zhang <ieaggie2009@gmail.com>]

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 ) )
 )
);