Hi,
I was trying to add a chart control to display my data. I knewthe code using chartdata property . I was unable to understand that how could I link it with my Databse (Access) after declaring Variants/arrays?. It was not displaying my data.
Pls. let me know the complete coding and way to display the data with chart. The code I have used but not working is as follows:
Private Sub Form_Load()
Dim X(1 To 3, 1 To 8) As Variant
X(1, 2) = FBS(mg / dl)
X(1, 3) = RBS(mg / dl)
X(1, 4) = FBS(mmol / l)
X(1, 5) = RBS(mmol / l)
X(1, 6) = HbA1c
X(1, 7) = Weight
X(1, 8) = BP

X(2, 1) = "January"
X(2, 2) = 2
X(2, 3) = 3
X(2, 4) = 4
X(2, 5) = 5
X(2, 6) = 6
X(2, 7) = 7
X(2, 8) = 8

X(3, 1) = "February"
X(3, 2) = 4
X(3, 3) = 6
X(3, 4) = 8
X(3, 5) = 10
X(3, 6) = 12
X(3, 7) = 14
X(3, 8) = 16

MSChart1.ChartData = X


End Sub

thanks