SOLVED

Draw lines using coordinates data

New Contributor

I have certain data which shows nodes of a structure through x and y coordinates. I am able to plot them as nodes using an excel chart (Scatter chart) and name each node with Data Labels. But what I want to achieve is draw one line each for members 1 to 10 using (x1, y1) coordinates as beginning of the member and (x2, y2) coordinates as end point. How can this be done in Excel charts? VBA based solution is also acceptable.Screenshot 2022-12-23 221226.jpg

3 Replies
best response confirmed by AkshA77 (New Contributor)
Solution

@AkshA77 

The data needs to be organised in a somewhat awkward manner.

image.png

@AkshA77 

For what it's worth...

Thank you, Peter, worked perfectly!