none
MS CHART Line graph problem - a line is drawn from last data point to first data point - can not see a reason why

    Question

  • I am plotting a line graph using MS Chart. Data is sourced from a MS Access table via a select statement, then I retrieve the data using Chart.Datasource, then bind the data using Chart.DataBind. This all seems to work fine other than on the display a straight line is drawn from the last data point to the first data point and I can not see why. I also have one data point that does not have a line drawn to it, so it looks like a break but the data retreived shows valus for all data points.
    I have checked the SQL by running it in MS Access and it returns the exact number of results.
    Can anyone shed any light on this problem.

    The following SQL returns 13 results:
    SELECT Wi5minReadings.WiReadingTaken, Wi5minReadings.WiReadingAve, Wi5minReadings.WiReadingMax, Wi5minReadings.WiReadingMin FROM(Wi5minReadings)WHERE ((CDate([Wi5minReadings]![WiReadingTaken]) Between '05/02/2010 07:13:38' And '05/02/2010 08:13:38'));
    <tfoot></tfoot>
    Query2
    WiReadingTakenWiReadingAveWiReadingMaxWiReadingMin
    05/02/2010 07:53:38 1.22866666666667 1.36 1.1
    05/02/2010 07:58:38 1.11933333333333 1.2 1.03
    05/02/2010 08:03:38 1.2292 1.26 1.17
    05/02/2010 08:08:38 1.26746666666667 1.32 1.22
    05/02/2010 08:13:38 1.14666666666667 1.24 1.06
    05/02/2010 07:13:38 1.70453333333333 3.14 0
    05/02/2010 07:18:38 1.03413333333333 1.06 1.01
    05/02/2010 07:23:38 1.2332 1.41 0.93
    05/02/2010 07:28:38 1.34066666666667 1.4 1.27
    05/02/2010 07:33:38 2.36133333333333 3.04 1.26
    05/02/2010 07:38:38 1.93066666666667 3 1.26
    05/02/2010 07:43:38 2.56773333333333 3.3 1.16
    05/02/2010 07:48:38 2.1112 3.4 1.09

    Friday, February 05, 2010 10:06 AM

Answers

All replies

  • Line chart draws data points in the order you specified them. Make sure that the data is sorted by date and time.

    Alex.


    http://blogs.msdn.com/alexgor
    Wednesday, February 17, 2010 6:09 PM
    Owner
  • What about RangeColumn chart? When I've only 1 data point (X, Y,Y2), itsn't drawn.
    Monday, January 23, 2012 5:51 PM
  • Hi, I have the same issue.

    I just created a simple chart with 2 line series.
    Points are sorted by date, and added with AddXY function.
    I always have a straight line between first and last point of my serie.

    Is there any way to fix this issue ?

    Wednesday, July 04, 2012 9:20 AM
  • I got the same issue.

    points are sorted by date, and still have the line between first and last point.
    I found a workaround disabling "IsMarginVisible" on X axis

    Wednesday, July 04, 2012 9:23 AM
  • Hi, I have the same issue.

    I just created a simple chart with 2 line series.
    Points are sorted by date, and added with AddXY function.
    I always have a straight line between first and last point of my serie.

    Is there any way to fix this issue ?

    I had the same problem.  I fixed it by performing an InsertXY with an index of zero instead of AddXY.  Since the points are drawn on the graph in order, it's important to put the data in the correct place in the series.  Since my original query was "[dbtimestamp] desc", it put the newest records at the beginning of the series.  Since the data is read periodically from the hardware, the most current reading must be placed at the beginning of the series in order to not cause a line to be drawn all the way across the chart (kind of like a carriage return, if you think about it).

    Anyway, try replacing your Series.AddXY(x, y) with Series.InsertXY(0, x, y) and you may see your mysterious line disappear.

    Monday, April 22, 2013 9:18 PM