Marker Line Style

[jheddings]

I am trying to change the line style of a marker, but I am unable to find any documentation on any property that might allow this. Additionally, when I record a macro to change the style, nothing is added to the VB code.

Can anyone point me in the right direction?

 

[Derek Brown]

Hello and welcome to The Board.
I do not understand what you mean by "Marker" so perhaps you could explain this a bit more please.
When you record a macro, the dialog box ask where you want it stored- I guess that this is not set to "This workbook" on your system - you may find that it is being stored in your Personal workbook?

 

[Andy Pope]

I can not see anything in the OM that would suggest the properties are available via code.

Marker Line colour is all you can alter using the MarkerForegroundColorIndex property.

 

[Derek Brown]

Have a look at:
http://msdn.microsoft.com/en-us/library/aa175717(office.11).aspx
http://msdn.microsoft.com/en-us/library/aa175716(office.11).aspx
and also 175714, 14, 13 and 12

 

[jheddings]

Sorry, I should have been more clear. I'm looking to modify the line style of the markers in a data series on a chart. Specifically, using the double-line style with no fill makes a nice "circle-in-circle" look that we are hoping to achieve.

I'd seen those properties for modifying the marker color, style, and size. I guess I was hoping there was something I missed.

Thanks for the replies... I think I'll have to take another direction to get the appearance we are shooting for. I'm looking into using a second series with the same data to get the circle-in-circle look.

 

[Andy Pope]

Another way may be to use a custom marker. Create a shape and format as required, then copy to the clipboard. Now for the series use the Picture fill > Clipboard for the marker.