Background Property

Applies To

Font Object.

Description

Returns or sets the text background type (can be one of xlAutomatic, xlOpaque, or xlTransparent). This property is only used for text on charts. Read-write.

Example

This example adds a chart title to embedded chart one on Sheet1 and then sets the font size and background type of the title.

With Worksheets("Sheet1").ChartObjects(1).Chart
    .HasTitle = True
    .ChartTitle.Text = "1995 Rainfall Totals by Month"
    With .ChartTitle.Font
        .Size = 10
        .Background = xlTransparent
    End With
End With