Marker Line Style vs Line Style

[emorris1000]

This is driving me nuts, and the main reason is that I had a working solution at some point but then I went and deleted it :banghead:

Here's the problem. I have 2 markers I need to format on a chart. The first needs to be a filled black square, no line. No biggie:

With MyNewSrs
.Name = "Avg"
.Values = Template.Cells(1, I * 5 + 3)
.XValues = Template.Cells(1, I * 5 + 5)
.MarkerStyle = 1
.MarkerSize = 10
.MarkerBackgroundColor = RGB(0, 0, 0)
.MarkerForegroundColor = RGB(0, 0, 0)
.Format.Line.Visible = msoFalse
End With


This works fine.


The other needs to be an empty black square. It's generated initially with the original code above, and then modified as below:

ActiveChart.SeriesCollection(16).Format.Fill.Visible = msoFalse

With ActiveChart.SeriesCollection(16).Format.Line
.Visible = msoTrue
.ForeColor.ObjectThemeColor = msoThemeColorText1
.ForeColor.TintAndShade = 0
.ForeColor.Brightness = 0
.Weight = 1.5end with

Now, this works, sort of. The problem is that the ".format.line" affects not only the marker line style, but also the line style itself. So now I have a marker and a line for this item.

That's the ultimate problem I have here:

Series.format.Line describes both the Line for the series and the Marker Line.

This seems too stupid to be true. Has anyone figured a way around this, or am I doing something stupid myself that is confusing me?