Cannot change color of line in chart with VBA

I am creating a chart and it is a combination of columns and lines with markers. I would like to change the color of the lines but can't seem to do so. I can change the color of the columns.

For the line I am using:
ActiveChart.SeriesCollection("name").Format.Line.ForeColor.RGB = RGB(112, 48, 160)

For the column I am using:
ActiveChart.SeriesCollection("name").Format.Fill.ForeColor.RGB = RGB(112, 48, 160)

I have tried using Fill for the line but all it does is change the color of the markers, not the line. I have also tried to change the type from xlLineMarkers to xlLine and then change color - this does not work. I was able to change the line to a column, and then change the color but when I change it back to a line the color returns to the automatic one.

I am using Excel 2007.

Try the following:

Please Login or Register  to view this content.

Lewis