Forum Discussion

AkshA77's avatar
AkshA77
Copper Contributor
Dec 24, 2022
Solved

Draw lines using coordinates data

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.

Resources