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.