Format Marker Line Style with Excel VBA 2007

[kz9yyc]

Hello All,

I want Excel VBA 2007 to format scatter chart data point (marker) line styles.

For example, I have plotted circles in my scatter plot that represent solder bumps on a flip chip IC. These "marker" circles are comprised of two parts--an inner circle (which one may adjust with "marker fill") and the outer circle (which one may adjust with "marker line style").

I want to fill these markers with white color, and change the marker line style to "dashed". In turn, I hope the bumps will appear like hidden edges in an AutoCAD drawing.

To fill with white, I've tried the following:
ActiveChart.SeriesCollection(1).Points(Count).Format.Fill.ForeColor.RGB = RGB(0, 0, 0)

VBA does not fill the circles with white. Perhaps white<> RGB(0,0,0)? If I change RGB values, e.g., RGB(255,0,0), VBA fills the circles with red.

To make the outer circle dashed, I've tried the following:
ActiveChart.SeriesCollection(1).Points(Count).MarkerLineStyle = xlDash

VBA does not like this at all. I've tried alot of variations, but I'm just really guessing on syntax, and VBA didn't like any of them.

I appreciate your help. As a novice user, I hope that I don't offend anyone with descriptions of what may be obvious to the general forum.

It sure seems to me that Microsoft makes alot of changes just for the sake of making changes. As always, they always add a gimmick that is nice, but overall, I prefer 2003 over 2007. I very much miss being able to use the macro recorder to figure out problems like this.

Thanks, and have a good day.
John

 

[spicetrader]

Hello All,

...To fill with white, I've tried the following:
ActiveChart.SeriesCollection(1).Points(Count).Format.Fill.ForeColor.RGB = RGB(0, 0, 0)

VBA does not fill the circles with white. Perhaps white<> RGB(0,0,0)? If I change RGB values, e.g., RGB(255,0,0), VBA fills the circles with red.

white = RGB(255,255,255)


Sorry I can't help with your main question. I'm here for almost the same reason: How to set the weight of the marker line, that is, the line that forms the edge of the little marker or the x and the + of marker styles 4 and 9?

I'm not concerned at this time with the lines that connect the markers, and I don't want them to appear.