Series.MarkerForegroundColorIndex (Word)

Returns or sets the marker foreground color as an index into the current color palette, or as one of the following XlColorIndex constants: xlColorIndexAutomatic or xlColorIndexNone. Possible return values are xlColorIndexAutomatic - Automatic color, xlColorIndexNone - No color.

This property applies only to line, scatter, and radar charts.


ActiveDocument.Background.Chart.FullSeriesCollection(1).MarkerForegroundColorIndex = xlColorIndexAutomatic