Show unwated line on graph

[User (Legacy)]

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

[Software FX]

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.

[User (Legacy)]

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.

>

>