ChartFillFormat Object

Microsoft Excel Visual Basic

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