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

Kimberly · #2 03-18-2011, 07:26 AM

Why not use the macro recorder?

Kimberly · #3 03-18-2011, 07:29 AM

I'm not seeing that you can change the outline of markers without changing it of the line, macro or not.

judicial85 · #4 03-18-2011, 08:48 AM

Macro recorder doesn't pick up any chart formatting changes and "border" and "line" commands seem to talk to different pieces of the chart, but line always seems to trump border...

Just in case, I'd want to clarify... in the "Format Data Series" pop-up, I'm looking to change "Line Style" --> "Width" without (programatically) changing "Marker Line Style" --> "Width" simultaneously.

If it's truly broken, is it possible to alternatively remove "Marker Line Style" "Width" and just display a line? (One can always make the marker sizes large to compensate)

Kimberly · #5 03-18-2011, 09:30 AM

Have you considered using the button on the Design tab to save your chart as a template?

judicial85 · #6 03-18-2011, 01:09 PM

Briefly, but sometimes the lines are charted in different orders (depends on when data arrives) which means the colors will probably be assigned to the wrong line; the legend should determine the color as opposed to the order they are plotted.

Bryan

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

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