Change marker line width for all series

[Marco_Polo]

I am trying to create a macro that will amend all the markers within my chart to be exactly the same style, shape, size etc. also removing connecting lines.

I have gotten most of the way to what I am trying to achieve with the code below:

Sub fixchart()
Dim i As Long, j As Long
i = ActiveChart.SeriesCollection.Count
For j = 1 To i    
With ActiveChart.SeriesCollection(j)        
.MarkerStyle = 2        
.MarkerSize = 6        
.MarkerForegroundColor = RGB (0, 0, 0)        
.MarkerBackgroundColor = RGB(255, 255, 255)        
.Border.LineStyle = xlNone   
End With
Next j
End Sub

However, I cannot figure out a way to amend the marker line width. Every piece of code I have found so far just appears to change the connecting line width rather than marker line width. I am a VBA novice and so far have just pieced together other bits of code I have found through forums, so any assistance would be greatly appreciated.

 

[oldbrewer]

what is a marker line ? a line joins markers - do you mean the line in the legend ?

 

[pbornemeier]

Way late to answer, but this came up when I was doing a search, so ....
ActiveChart.FullSeriesCollection(3).Format.Line.Weight = 4 'Sets the width of the chart line
Now change some aspect of the marker
ActiveChart.FullSeriesCollection(3).Format.Fill.ForeColor.RGB = RGB(255, 0, 0)
Same command as before now sets the width of the marker line (border)
ActiveChart.FullSeriesCollection(3).Format.Line.Weight = 4 'Sets the width of the marker line