Forum Discussion
CCRMack
Nov 29, 2021Copper Contributor
Charting X and Y variables
Excel for Mac 2019 Hi . I have a table of two independent variables X and Y which define points (X,Y), and I want to plot those points with a line between them on a chart. The X variable increases i...
HansVogelaar
Nov 29, 2021MVP
Make sure that you select the "Scatter with Straight Lines and Markers" (or "Scatter with Straight Lines") subtype of the XY Scatter Chart.
CCRMack
Nov 29, 2021Copper Contributor
Thankyou, Hans, I've got it. The icon's meaning isn't very obvious! CCRMack