[sqr-users] line chart in SQR with dates

[Amy Emge <emgeac@muohio.edu>]

SQR 6.1.3.  No new graphics.

I'm doing a line chart and my x-axis (horizontal) values are dates.  I have 
two problems.

One, I want the dates to appear on the x-axis of the chart as '1/02' 
instead of '01-JAN-2002' to save space.  Right now, oddly enough, they're 
printing as 2, 4, 6 8, 10, 12, 14, 16 (I have a 16 month span of dates in 
the array).

Two, I only want January, May and September to print.  The 
x-axis-major-increment only accepts numbers and if I put in a value of 4, I 
get 4, 8, 12 and 16 on the x axis, the values for April, August, December 
and January.

The array is defined like this:

     create-array
     name = chart
     size = 100
     field=date:date
     field=goal:number
     field=giving:number

I've also tried declaring the date field as char since the SQR book implies 
the first field in the array is the x axis and must be char.  This helps 
solve my first problem (they'll print as '1/02'), but not my second.  The 
x-axis-major-increment works, but I can't get the x axis to start at 
January then go to May then to September - it wants to start at May.  The 
x-axis-min-value only accepts numbers too (which is odd considering the x 
axis must be a char) and I've tried a variety of values in this parameter 
to try to get the x axis to start at January then increment to May then to 
September.  No luck yet.

I've been playing around with charts a bit in the past month, but never one 
that had dates.  Any help you can give would be appreciated.

Amy Emge
Applications Analyst
Miami University

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users