Jump to content
Software FX Community

Correctly Charting date based data on a Scatter

User (Legacy)

Recommended Posts

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


What should I be using? A Line Chart is not what I want. It must be scatter

to honour the chronological ordering AND Spacing.



Link to comment
Share on other sites

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


"SoftwareFX Support" <support@softwarefx.com> wrote in message


> 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

  • 2 weeks later...
  • 2 weeks later...

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


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


Please help and thank in advance



"Paul Fell" <paul@max-geoservices.com.au> wrote in message


> 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

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


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




Software FX, Inc.

Link to comment
Share on other sites


This topic is now archived and is closed to further replies.

  • Create New...