If I create a chart in my code and I do not specifically set the
MarkerBackgroundColorIndex for the series it is set to xlAutomatic by default.

How can I extract the actual colorindex that excel chooses?

Debug.Print ActiveChart.SeriesCollection(I).MarkerBackgroundCo lorIndex

just gives me the code for xlAutomatic (-4105 I believe).

Thanks
The Doctor