I'm not sure exactly how your macro is plotting the points. If the macro is grouping associated points into appropriate data series, then it should be as easy as formatting each data series to have a line connecting the points (on my old version of excel, this is done if the format data series dialog).

If the macro is plotting each data point as its own data series or plotting all of the points into one data series, I would suggest modifying the macro so it plots associated data points into data series.