-
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?
-
I haven't seen your code, but since most VB functions and
references are 0 based, maybe you should try starting with 0?
-
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?