Font.Background property (Excel)

Returns or sets the type of background for text used in charts. Read/write Variant, which is set to one of the constants of XlBackground.

Syntax

expression.Background

expression A variable that represents a Font object.

Remarks

XlBackground can be one of the following constants.

Constant	Description of text background
xlBackgroundAutomatic	Font.Background will automatically change the background area around the text to a color that best displays the chart text on the color applied to elements under the text.
xlBackgroundOpaque	Font.Background will set the font background to black if the text color and fill color underneath the text are very close or the same color, such that the text would not appear.
xlBackgroundTransparent	Font.Background is set to transparent so that the text background does not change if the text color is close to the color underneath the text.

Example

This example adds a chart title to embedded chart one on the first worksheet, and then sets the font size and background type for the title. This example assumes that a chart exists on the first worksheet.

Sub UseBackground() 
 
 With Worksheets(1).ChartObjects(1).Chart 
 .HasTitle = True 
 .ChartTitle.Text = "Rainfall Totals by Month" 
 With .ChartTitle.Font 
 .Size = 10 
 .Background = xlBackgroundTransparent 
 End With 
 End With 
 
End Sub

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.