How to change x axis values by another column?

[Fred Zhang <ieaggie2009@gmail.com>]

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