automate 2dline with marker chart generation - Excel 2007

[kdilly]

In generating line charts with markers, I can change the color of the
markers, but not the marker lines and series lines. The VBA code for the
markers is:

.SeriesCollection(1).Select
With Selection
.MarkerStyle = xlDiamond
.MarkerSize = 9
End With
.SeriesCollection(1).Format.Fill.ForeColor.RGB = RGB(255, 200, 25)

What are the references for the marker lines and the lines between the
series points?

 

[Herbert Seidenberg]

Excel 2007 Chart
Format markers and point line segments.
http://c0444202.cdn.cloudfiles.rackspacecloud.com/10_31_09a.xlsm

 

[kdilly]

the

Excel 2007 Chart
Format markers and point line segments.
http://c0444202.cdn.cloudfiles.rackspacecloud.com/10_31_09a.xlsm
.
Thanks for the colors. The problem isn't the color, but how to apply a color. For the points, the statement ".SeriesCollection(1).Format.Fill.ForeColor.RGB = RGB(255, 200, 25)" colors them, but does not change the color of the marker lines or point line segments.

thanks,
kdilly