I have tried for a while now to edit the lines of my chart series in VBA. I am looking for some simple changes to SeriesCollection(1).Select
With Selection
"series line is 2.25 width"
"MARKER line is the default 0.75"
End With
The problem is when I do code as below, the weight command of one of those overwrites the weight command of the other. How do I distinguish between the two kinds of "lines" in VBA so I don't get bloated markers?
Best,
Bryan
Code:
With Selection
.Format.Line.Visible = msoTrue
.Border.Color = RGB(0, 0, 0)
.Format.Line.Weight = 2.25
.Format.Line.ForeColor.RGB = RGB(0, 255, 0)
.Format.Line.ForeColor.TintAndShade = 0
.Format.Line.Transparency = 0
.Format.Fill.Solid
.Format.Fill.ForeColor.RGB = RGB(0, 0, 0)
.Border.Weight = 0.75
End With
PS - The order is somewhat random now as I have tried moving commands around to see what the effects were...