User (Legacy) Posted September 15, 2003 Report Share Posted September 15, 2003 ChartFX ClientServer 5.2 VB 6 SP5 I have a set of data which is date based. The Y value is double and X is a Date (no time) All I want to do is chart the data as a scatter so that it honours the Date but ChartFX is charting the data in equal increments along the X Axis. For example. I have one data point on Jan 21 2003, one on Apr 28 2003 and one on Aug 15 2003. ChartFX charts the data consecutively, instead of honouring the chronological positions and spacing. I'm sure its to do with the methods/properties I'm using. In my code I'm using : .Gallery = Scatter .Series(n).YValue(n) for Numerical Y value .Series(n).XValue(n) for date value (eg 'dd-mmm-yyyy') (australian format) What should I be using? A Line Chart is not what I want. It must be scatter to honour the chronological ordering AND Spacing. Thanks Paul Link to comment Share on other sites More sharing options...
Software FX Posted September 16, 2003 Report Share Posted September 16, 2003 1) Are you doing the appropriate OpenData - CloseData calls ? 2) XValue is a double, your dates need to be OLE Automation Dates, not strings (Date type in VB will do this). 3) Check the programmer's guide on XY Charts. -- FP Software FX, Inc. Link to comment Share on other sites More sharing options...
User (Legacy) Posted September 16, 2003 Author Report Share Posted September 16, 2003 Yes, I'm using opendata/closedata. Your point 2 fixed it and data is displaying correctly. How do I replace the numeric date serial numbers displayed on the X Axis labels, with the actual date? I've had a look in the Programmers Guide but cannot see any reference to using dates as labels Thanks for your help Paul "SoftwareFX Support" <support@softwarefx.com> wrote in message news:X08aDNIfDHA.1484@WEBSERVER1... > 1) Are you doing the appropriate OpenData - CloseData calls ? > > 2) XValue is a double, your dates need to be OLE Automation Dates, not > strings (Date type in VB will do this). > > 3) Check the programmer's guide on XY Charts. > -- > FP > Software FX, Inc. > > Link to comment Share on other sites More sharing options...
Software FX Posted September 17, 2003 Report Share Posted September 17, 2003 Simply change the format of the X-Axis to AF_DATE or a custom format for Dates as follows: ChartFX1.Axis(AXIS_X).Format = AF_DATE -- FP Software FX, Inc. Link to comment Share on other sites More sharing options...
User (Legacy) Posted September 26, 2003 Author Report Share Posted September 26, 2003 Thanks "SoftwareFX Support" <support@softwarefx.com> wrote in message news:r4l17VSfDHA.3600@WEBSERVER1... > Simply change the format of the X-Axis to AF_DATE or a custom format for > Dates as follows: > > ChartFX1.Axis(AXIS_X).Format = AF_DATE > > -- > FP > Software FX, Inc. > > Link to comment Share on other sites More sharing options...
User (Legacy) Posted October 8, 2003 Author Report Share Posted October 8, 2003 Hi All, I also have similar problem like Paul. I cannot bind the recordset to ChartFX because my recordset have some records are NULL. So I used OpenDataEx COD_VALUES and CloseData COD_VALUES method to populate my recordset's data. I set the NULL value as CHART_HIDDEN and all are working fine. But the problem come if I want to populate the ChartFX with non-continuous data as data.jpg file which have the value from Dec 2002 and Feb 2003, excluding Jan 2003 data, the undesire graph will be displayed as graph.jpg . The X-axis is date format and Y-Axis is double value. In fact I want to get a graph like graph2.jpg which EXCLUDING January's data Please help and thank in advance Regards, Chia "Paul Fell" <paul@max-geoservices.com.au> wrote in message news:B$I$9q$gDHA.3296@WEBSERVER1... > Thanks > > "SoftwareFX Support" <support@softwarefx.com> wrote in message > news:r4l17VSfDHA.3600@WEBSERVER1... > > Simply change the format of the X-Axis to AF_DATE or a custom format for > > Dates as follows: > > > > ChartFX1.Axis(AXIS_X).Format = AF_DATE > > > > -- > > FP > > Software FX, Inc. > > > > > > Link to comment Share on other sites More sharing options...
Software FX Posted October 8, 2003 Report Share Posted October 8, 2003 The only way to achieve this is that to SKIP the null values instead of setting it to the chart and use the date field as labels instead of X-Values. If you use the dates as X-Values, the distance between Dec and Feb WILL BE greater than the distance between Feb and Mar. If you use labels instead, the intrinsic value of the date is lost so the position is not affected by it. -- FP Software FX, Inc. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.