Plot Polyline using XY coordinates

S

Subodh

Hi All,
I want to plot a polyline in excel using the XY Coordinates.
I tried using the following

Sub plinee()

For i= 1 to 10


myshape(i, 1) = Cells(i, 1).Value
myshape(i, 2) = Cells(i, 2).Value

Next
myDocument.Shapes.AddPolyline myshape
end sub
But the results are not as desired. The program seems always
start from (0,0) coordinates.
Any help will be appreciated.
Thanks in advance.
 
Top