|
Set Rcd = SuperMap1.Selection.ToRecordset(False)
ReDim ChrtDt(1 To Rcd.RecordCount + 1, 1 To UBound(FldName) + 1)
Dim i As Integer
Dim j As Integer
Dim column As Integer
Dim row As Integer
For i = 2 To UBound(ChrtDt, 2)
ChrtDt(1, i) = FldName(i - 1)
Next
Rcd.MoveFirst
For i = 2 To UBound(ChrtDt, 1)
ChrtDt(i, 1) = Rcd.GetFieldValue(LblField)
Rcd.MoveNext
Next
Rcd.MoveFirst
For i = 2 To UBound(ChrtDt, 1)
For j = 2 To UBound(ChrtDt, 2)
ChrtDt(i, j) = Rcd.GetFieldValue(FldName(j - 1))
Next
Rcd.MoveNext
Next
MSChart1.ChartData = ChrtDt
MSChart1.Refresh |