Weird problem

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   Hi there,

I made a chartcontrol with 3 series: 2009, 2010, 2011 each with max 12 points (Jan, Feb, Mar, etc.). When a value is empty I don't want to add a point. The problem is that the points now not always are shown in the right order. Of course it should be Jul, Aug, Sep, Oct and not like in the picture below (Jul, Sep, Aug, Oct) but whatever I try. This is the code I use:

Series1.Points.Add "Jul", 4550

Series1.Points.Add "Sep", 9170

Series1.Points.Add "Oct", 1608

Series2.Points.Add "Jul", 6034

Series2.Points.Add "Aug", 386

Series2.Points.Add "Oct", 1608

Series3.Points.Add "Jul", 3810

Series3.Points.Add "Oct", 2552

Any suggestions?

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
ceesverburg Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 27 March 2011 Location: Vietnam Status: Offline Points: 13	Post Options Post Reply Quote ceesverburg Report Post Thanks(0) Quote Reply Topic: Weird problem Posted: 27 March 2011 at 5:08am
	Hi there, I made a chartcontrol with 3 series: 2009, 2010, 2011 each with max 12 points (Jan, Feb, Mar, etc.). When a value is empty I don't want to add a point. The problem is that the points now not always are shown in the right order. Of course it should be Jul, Aug, Sep, Oct and not like in the picture below (Jul, Sep, Aug, Oct) but whatever I try. This is the code I use: Series1.Points.Add "Jul", 4550 Series1.Points.Add "Sep", 9170 Series1.Points.Add "Oct", 1608 Series2.Points.Add "Jul", 6034 Series2.Points.Add "Aug", 386 Series2.Points.Add "Oct", 1608 Series3.Points.Add "Jul", 3810 Series3.Points.Add "Oct", 2552 Any suggestions?

jpbro Members Profile Send Private Message Find Members Posts Add to Buddy List Senior Member Joined: 12 January 2007 Status: Offline Points: 1355	Post Options Post Reply Quote jpbro Report Post Thanks(0) Quote Reply Posted: 27 March 2011 at 8:39am
	Can you post the rest of the code that generates that chart - I would like to help, but I don't have time to do the rest of the code to generate the chart and play around with it to see if I can meet your requirements.
	Product: Xtreme SuitePro (ActiveX) version 16.2.6 Platform: Windows XP - SP3 Language: Visual Basic 6.0 SP6

Fabian Members Profile Send Private Message Find Members Posts Add to Buddy List Senior Member Joined: 22 November 2004 Location: Switzerland Status: Offline Points: 336	Post Options Post Reply Quote Fabian Report Post Thanks(0) Quote Reply Posted: 27 March 2011 at 9:55am
	Hi That is a problem since the first release of ChartPro. It seems not possible to set 'missing' points like Set Point = Series.Points.Add ... Point.IsMissing = True For this point nothing should be drawn but the space must be reserved. That holds true for charts like: Lines, Splines, HiLo, Bar, Point, Area and all stacked variants
	Product: Xtreme SuitePro (ActiveX) version 16.2.3 Platform: Windows 7 (32bit) Language: Visual Basic 6.0 / SP6