CfxIE2000 Multiple graphs/min/max values

[User (Legacy)]

Hello all, 

I'm testing the CfxIE2000 Trial version and need to find out the following: 

PROBLEM 1 

1) I want to dislay to graphs (lines) 

SQL = "SELECT date,Price1,Price2 FROM tblPricing" 

Set chart = Server.CreateObject("ChartFX.WebServer") 

Set rs = Server.CreateObject("ADODB.Recordset") 

rs.Open SQL, conn 

chart.Chart3D = False 

chart.Gallery = LINES 

chart.MarkerShape = MK_NONE 

chart.DateFormat = "DMMM-yy" 

chart.Axis(AXIS_Y).Format = AF_CURRENCY 

chart.Axis(AXIS_Y2).Format = AF_CURRENCY 

2) Now I want to set Min and Max values for Y and Y2 

Chart.Axis(AXIS_Y).min = 7 

Chart.Axis(AXIS_Y).max = 30 

Chart.Axis(AXIS_Y2).min = 3 

Chart.Axis(AXIS_Y2).max = 9 

(I calculate my min/max values on the fly, above values entered for this 

code demo) 

This will produce the min/max values but the graphs (one of them) are 

getting clipped at the top even though I'm giving extra space - my max value 

in the recordset is only 28.9 

3) if I don't use any min/max settings all is fine but I have bit of wasted 

space at the bottom, plus I need to get the two graphs closer together for 

comparison 

PROBLEM 2 

I want to force generation of a picture and that is working fine. I also 

want to get the name of the picture and check if it has been generated 

before and decide if it needs to be re-generated. How are the names 

generated and can I modify the way names for pictures are generated. 

Any help would be greatly appreciated, thanks in advance.

[User (Legacy)]

Hello all, 

I'm testing the CfxIE2000 Trial version and need to find out the following: 

PROBLEM 1 

1) I want to dislay to graphs (lines) 

SQL = "SELECT date,Price1,Price2 FROM tblPricing" 

Set chart = Server.CreateObject("ChartFX.WebServer") 

Set rs = Server.CreateObject("ADODB.Recordset") 

rs.Open SQL, conn 

chart.Chart3D = False 

chart.Gallery = LINES 

chart.MarkerShape = MK_NONE 

chart.DateFormat = "DMMM-yy" 

chart.Axis(AXIS_Y).Format = AF_CURRENCY 

chart.Axis(AXIS_Y2).Format = AF_CURRENCY 

2) Now I want to set Min and Max values for Y and Y2 

Chart.Axis(AXIS_Y).min = 7 

Chart.Axis(AXIS_Y).max = 30 

Chart.Axis(AXIS_Y2).min = 3 

Chart.Axis(AXIS_Y2).max = 9 

(I calculate my min/max values on the fly, above values entered for this 

code demo) 

This will produce the min/max values but the graphs (one of them) are 

getting clipped at the top even though I'm giving extra space - my max value 

in the recordset is only 28.9 

3) if I don't use any min/max settings all is fine but I have bit of wasted 

space at the bottom, plus I need to get the two graphs closer together for 

comparison 

PROBLEM 2 

I want to force generation of a picture and that is working fine. I also 

want to get the name of the picture and check if it has been generated 

before and decide if it needs to be re-generated. How are the names 

generated and can I modify the way names for pictures are generated. 

Any help would be greatly appreciated, thanks in advance.