Draw lines using coordinates data

[AkshA77]

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.

[#2 · Accepted solution]

@AkshA77 

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

[#3]

@AkshA77 

For what it's worth...

[#4]

Thank you, Peter, worked perfectly!