#1
|
|||
|
|||
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? 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 |
Tags |
charts, formatting, vba |
|
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 |