• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 549
  • Last Modified:

MS Chart Control line interpolation failure?

Hi Experts!

I have an ASP 4.0 app with some chart controls showing data from a SQL server.
There are all XY graphs with charttype = line (or fastline). For some, to me, unknown reason the lines fail to connect some of the data points and overlap (see attached picture).

I suspect that there is something wrong with the internal interpolation routine in the Chart Control object, maybe I'm wrong?
Does anyone here know of a solution to get rid of this I would be more than happy?

BR,
Peer
line-fail.JPG
0
peer754
Asked:
peer754
  • 2
  • 2
1 Solution
 
AndyAinscowFreelance programmer / ConsultantCommented:
Are the datapoints sorted correctly ?  (This looks like the jumps could be between datapoints in the order they are in the dataset)
0
 
peer754Author Commented:
Hi,
All datapoints are inserted into the DB in real-time, i.e. they should be sorted w.r.t. time.
I will make sure however if that's the case.
Thanks!
0
 
AndyAinscowFreelance programmer / ConsultantCommented:
Just because they are sorted in the table doesn't mean they will be sorted in the dataset (they could be but...)
0
 
peer754Author Commented:
You were right, the data was not sorted (WHY?). The data is added at real-time in a time interval to a table with id so I assumed (wrongly) that the data should be sorted as it it's been added.

Thanks!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Certified Penetration Testing

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now