Background Property

Applies To

Font object.

Description

Returns or sets the text background type. Can be one of the following XlBackground constants: xlBackgroundAutomatic, xlBackgroundOpaque, or xlBackgroundTransparent. This property is used only for text on charts. Read/write Long.

Example

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

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