Jump to content
Software FX Community

Show unwated line on graph


User (Legacy)
 Share

Recommended Posts

I have a recorset and would like to plot a graph but turned up t obe

unwanted graph. My recordset contain data from 1 Dec 2002 to 30 Dec 2002 and

from 3 Feb 2003 to 28 Feb 2003 exluding Jan 2003 data (please refer to

data.jpg). I used the OpenDataEx COD_VALUES and CloseData COD_XVALUES to

populate the data because sometimes the recordset contains NULL value.

For NULL value I set it to CHART_HIDDEN and all of that are working fine

except the graph show me a linear line from 31 Dec 2002 to 2 Feb 2003

(please refer to graph.jpg). In fact I want to get a good graph that

excluding Jan 2003 data as graph2.jpg.

For your information, Y Axis is double value and X Axis is Date format

Please help

Regards,

Chia

Link to comment
Share on other sites

I already answered this question before. I don't understand why the

duplicate post. Here is my old answer:

> 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.

Is there something here that you don't understand ?

--

FP

Software FX, Inc.

Link to comment
Share on other sites

Hi,

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

news:VD4siA3jDHA.3296@WEBSERVER1...

> I already answered this question before. I don't understand why the

> duplicate post. Here is my old answer:

Chia: In fact I try one of your method that posted previously but it doesn't

work and that is why I re-posted it again

> > 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.

Chia: How to SKIP the NULL value. For my case, In fact I already skip the

NULL value and if I didn't put back the NULL value at the end of the graph,

I will get Broken line graph and that is why I set all the NULL value as

HIDDEN.

> > 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.

Chia: Can you show some example for this? I not really can get your idea.

Thx

> Is there something here that you don't understand ?

>

> --

> 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...