I'm writing some code in Access 97 that produces charts in Excel 2002. I can get the marker colors OK
objExcel.ActiveChart.SeriesCollection(1).MarkerForegroundColor = RGB(r, g, b)
but I can't get the line colors.

My chart type is LineMarkers
objExcel.ActiveChart.ChartType = xlLineMarkers
Anyone know how to set the line colors?