I am using a CMD button with this code:
Adodc2.RecordSource = "select DTIME, NETSALES from data where opendate = '" & OPENDATE.Caption & "'"
This produces a result similar to:
and so on, in DataGrid2. Now my question is how can I chart this DataGrid2 data in an MSChart?
DTIME should be X axis and NETSALES be the Y axis
The data table is located in an Access DB.
Looking forward to your replies :)