User (Legacy) Posted October 10, 2003 Report Share Posted October 10, 2003 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 Quote Link to comment Share on other sites More sharing options...
Software FX Posted October 10, 2003 Report Share Posted October 10, 2003 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. Quote Link to comment Share on other sites More sharing options...
User (Legacy) Posted October 13, 2003 Author Report Share Posted October 13, 2003 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. > > Quote Link to comment Share on other sites More sharing options...
Recommended Posts
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.