Jump to content
Software FX Community

Correctly Charting date based data on a Scatter


User (Legacy)
 Share

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

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

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

  • 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

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

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

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

 Share

×
×
  • Create New...