Chart Line Colors

I'm writing some code in Access 97 that produces charts in Excel 2002. I can get the marker colors OK

Please Login or Register  to view this content.

but I can't get the line colors.

My chart type is LineMarkers

Please Login or Register  to view this content.

Anyone know how to set the line colors?

I ran the macro recorder to try and answer your Q. The ColorIndex property seems the probable suspect

Please Login or Register  to view this content.

I tried the same thing. Really sorry I didn't mentioned it. The problem with the ColorIndex property is that I don't know how to get RGB converted to ColorIndex. So maybe I should go the other way and use the macro recording feature to get the ColorIndex value just right. I was hoping to set both the markers and the lines using the same value system.

Thanks

Here's what I did:

Please Login or Register  to view this content.

Thanks for the suggestion.