Change series line colour to match marker colours

Hello All,

I am struggling to complete a macro that generates a standardised XY scatter chart.


I would like to add a line (or change the already present line) to the data series that is the same color as the automatically formatted points.

I have tried various combinations of markerforegroundcolor, points(x).colorindex and seriescollection().format.line.color, but to no avail.

Any help gratefully received.