Merge pull request #1457 from JamieG-UK/patch-16

Update Excel.Point.MarkerBackgroundColor.md
MicrosoftDocs · Dec 30, 2021 · cb2809f · cb2809f
2 parents c9a1a14 + 7bbb8fa
commit cb2809f
Showing 1 changed file with 14 additions and 6 deletions.
diff --git a/api/Excel.Point.MarkerBackgroundColor.md b/api/Excel.Point.MarkerBackgroundColor.md
@@ -14,7 +14,7 @@ ms.localizationpriority: medium
 
 # Point.MarkerBackgroundColor property (Excel)
 
-Sets the marker background color as an RGB value or returns the corresponding color index value. Applies only to line, scatter, and radar charts. Read/write **Long**.
+Sets the marker background color as an RGB value or returns the corresponding color index value. The background color is displayed as the Fill color in the application. Applies only to line, scatter, and radar charts. Read/write **Long**.
 
 
 ## Syntax
@@ -26,16 +26,24 @@ _expression_ A variable that represents a **[Point](Excel.Point(object).md)** ob
 
 ## Example
 
-This example sets the marker background and foreground colors for the second point in series one on Chart1.
+This example sets the marker background (fill) and foreground (border) colors for the first point in series one on Chart1.
 
 ```vb
-With Charts("Chart1").SeriesCollection(1).Points(2) 
- .MarkerBackgroundColor = RGB(0,255,0) ' green 
- .MarkerForegroundColor = RGB(255,0,0) ' red 
+With Charts("Chart1").SeriesCollection(1).Points(1) 
+ .MarkerBackgroundColor = RGB(0,255,0) ' green fill
+ .MarkerForegroundColor = RGB(255,0,0) ' red border
 End With
 ```
 
+This example sets the marker colors to automatic for the second point in series one on Chart1.
+
+```vb
+With Charts("Chart1").SeriesCollection(1).Points(2) 
+ .MarkerBackgroundColor = -1 ' automatic fill
+ .MarkerForegroundColor = -1 ' automatic border
+End With
+```
 
 
 
-[!include[Support and feedback](~/includes/feedback-boilerplate.md)]
+[!include[Support and feedback](~/includes/feedback-boilerplate.md)]