View Single Post
Old 03-16-2011, 07:41 AM
judicial85 judicial85 is offline Windows 7 Office 2010 (Version 14.0)
Advanced Beginner
Join Date: Nov 2010
Posts: 64
judicial85 is on a distinguished road
Default Edit Marker Lines VBA 2010

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?


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.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...
Reply With Quote