View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Subodh Subodh is offline
external usenet poster
 
Posts: 99
Default Plot Polyline using XY coordinates

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.