Edit Marker Lines VBA 2010

judicial85 · #1 03-16-2011, 07:41 AM

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...

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
MS Word 2010 / Grid Lines	Word4Dick	Word	2	10-24-2012 12:23 PM
Unable to edit a received message w/Outlook 2010	Mona123	Outlook	5	02-22-2012 10:25 AM
MarkAsFinal - 'Edit Anyway' edit popup issue	GovindRS	PowerPoint	1	06-20-2011 06:43 AM
'Last edit date'	markg2	Word	3	12-26-2010 04:27 PM
One specific paragraph marker problem	bubble	Word	2	11-06-2009 08:59 AM