Format marker - dash style, border width, etc.

Hi,
In 2003 we have limited options when it comes to formating markers. In 2007 we have much greater number of options. One can change marker border width, dash style, etc using excel interface. However I'm not able to find respective properties to change this using VBA (except marker style, size, foreground color and background color) . Can anyone help me in this respect? Any help will be highly appreciated. Thanks.

Originally Posted by jmadsen

Hi,

Try using the Macro Recorder.

Create the Chart, and then start the Macro Recorder, and start modifying the Chart/Graph.
When You are done, Stop the Recorder.

Check out all the VBA code generated.

Regards,

Thanks for this advise, but obviously you never used Macro Recorder with 2007 when it comes to charts. It is not like 2003 where you can see what is going on (properties methods, etc.). In 2007 you see only Select statements and not the formatting itself :-)

Buran

Not all of the ui elements are available via the object model but this should point you in the right direction.

Please Login or Register  to view this content.

Create a single series line chart with markers on a worksheet in order to step through the code and see the affects.

Hi
Thanks once again for your replys

@ Andy:
I think this part

Originally Posted by Andy Pope

Not all of the ui elements are available via the object model

is what I need to know, because I don't have problem with the format of the line, but with the new options for separate formatting of the marker line, available in 2007, but not in 2003.

From my experiments in the last day or two, I found that if I change the series line format it changes also the marker line format.

@jmadsen:
Yes, I know you can get these with macro recorder, but it is not possible to get the formatting. try to change format of a series or what I'm looking for - just the format of a marker and you will see what the result with the recorder will be. :-) Anyway, thanks.