|
|
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