ChartFillFormat Object

Microsoft Excel Visual Basic

previous page next page

ChartFillFormat Object

Multiple objects

ChartFillFormat

ChartColorFormat

Used only with charts. Represents fill formatting for chart elements.

Using the ChartFillFormat Object

Use the Fill property to return a ChartFillFormat object. The following example sets the foreground color, background color, and gradient for the chart area fill on chart one.

With Charts(1).ChartArea.Fill
    .Visible = True
    .ForeColor.SchemeColor = 15
    .BackColor.SchemeColor = 17
    .TwoColorGradient Style:=msoGradientHorizontal, Variant:=1
End With

previous page start next page