Results 1 to 3 of 3

Thread: Chart is being wacky

  1. #1

    Thread Starter
    Addicted Member P.S.W.'s Avatar
    Join Date
    Aug 2000
    Posts
    146
    After repeated experiments with using the MSChart to display the contents of an ADO recordset, I've noticed something unusual. The graph won't plot the first datapoint in a recordset -- for example, if the recordset has 7 records, the chart will only display the last 6. I know from reversing the order of the recordset that it's the first value that gets omitted.

    Is this a bug, the way it's supposed to work, or am I doing something wrong? Whassup?


  2. #2
    Hyperactive Member dsy5's Avatar
    Join Date
    Jul 2000
    Location
    Lockport, NY
    Posts
    362
    I haven't seen your code, but since most VB functions and
    references are 0 based, maybe you should try starting with 0?
    Donald Sy - VB (ab)user

  3. #3

    Thread Starter
    Addicted Member P.S.W.'s Avatar
    Join Date
    Aug 2000
    Posts
    146
    This is the code causing the problem:

    Set MSChart1.DataSource = dbRecordset

    I've since developed a looping routine which populates the Chart purely from code - and it works properly. But why does setting the DataSource to the recordset directly chop off the beginning record?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width