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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top