array problem

[azrina]

I have flexgrid which I want to use its data for column 6 to generate chart using ChartDirector.API.

Snippet code below gives an error which is,

"error converting argument 1 to type class double array"

why is like that?
Pls help.
Thank u in advance.

ReDim data(MSFlexGrid7.Rows - 1)
    ReDim labels(MSFlexGrid7.Rows - 1)
    Dim i
    For i = 0 To UBound(data)
        data(i) = MSFlexGrid7.TextMatrix(i, 6)
        labels(i) = MSFlexGrid7.TextMatrix(i, 0)
    Next
        
    Call layer.addDataSet(data, &HCF4040, "Jumlah Purata").setDataSymbol(cd.DiamondSymbol, 10)
     Call c.xAxis().setLabels(labels)

[Shaggy Hiker]

What line gives the error?

[azrina]

ReDim data(MSFlexGrid7.Rows - 1)
    ReDim labels(MSFlexGrid7.Rows - 1)
    Dim i
    For i = 0 To UBound(data)
        data(i) = MSFlexGrid7.TextMatrix(i, 6)
        labels(i) = MSFlexGrid7.TextMatrix(i, 0)
    Next
             'error at this line
            Call layer.addDataSet(data, &HCF4040, "Jumlah Purata").setDataSymbol(cd.DiamondSymbol, 10)
     Call c.xAxis().setLabels(labels)

[azrina]

someone told me that the error occured because the data(i) is not a number.

How come??

i enclose the screen shot of my Flexgrid.
pls help.