Marker Borders "Marker Line" removing in VBA

[crocodilesareforwimps]

I am trying to set the fill on different data series in a scatterplot and I don't want there to be any coloured border. I recorded a macro to get rid of it, but it doesn't do anything

the macro gives me this:
ActiveChart.SeriesCollection(1).Select
Selection.Format.Line.Visible = msoFalse


I think that doesn't work because it gets confused with the line of the series i.e. the line that connects dots. So is there any way to specifically select the marker line?

I tried Selection.Format.Border.LineStyle or Selection.Border.Weight etc. still doesn't work... for some reason that still only changes the line not the marker line.

Also tried Selection.Border.LineStyle = xlLineStyleNone but that doesn't work.

I figured out that if I make the selection an individual point instead of the series, it would work to say Format.Line, but that doesn't modify the legend.


I have tried to do this so many times, and I don't understand how this could possibly be so complicated. I have looked all over the internet to find how to do this and nothing works.

 

[crocodilesareforwimps]

setting Selection.MarkerForegroundColor = -4142
looks like it sets the border to white or something, which is a reasonable alternative since you can't usually see it except when points overlap

 

[vientolero]

setting Selection.MarkerForegroundColor = -4142
looks like it sets the border to white or something, which is a reasonable alternative since you can't usually see it except when points overlap

Hello, I had the same problem, and the command line you suggested almost worked for me, but it gave my markers a blurry look. But I kept looking and found this, for excel 2010, that removes the marker line:

Selection.MarkerForegroundColorIndex = -4142

where the number -4142 is the value of the constant xlColorIndexNone.