Forum Discussion
AkshA77
Dec 24, 2022Copper Contributor
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.
- PeterBartholomew1Silver Contributor
- AkshA77Copper ContributorThank you, Peter, worked perfectly!