Point.MarkerBackgroundColorIndex (Word)

Returns or sets the marker background 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.

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


With ActiveDocument.InlineShapes(1) 
 If .HasChart Then 
 With .Chart.SeriesCollection(1).Points(2) 
 ' Set the background color to green. 
 .MarkerBackgroundColorIndex = 4 
 
 ' Set the foreground color to red. 
 .MarkerForegroundColorIndex = 3 
 End With 
 End If 
End With