ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Plot Polyline using XY coordinates (https://www.excelbanter.com/excel-programming/448561-plot-polyline-using-xy-coordinates.html)

Subodh

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.


All times are GMT +1. The time now is 05:32 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com