TwoColorGradient Method [Excel 2003 VBA Language Reference]
TwoColorGradient method as it applies to the FillFormat object.
Sets the specified fill to a two-color gradient.
expression.TwoColorGradient(Style, Variant)
expression Required. An expression that returns one of the above objects.
MsoGradientStyle
| MsoGradientStyle can be one of these MsoGradientStyle constants. |
| msoGradientDiagonalDown |
| msoGradientDiagonalUp |
| msoGradientFromCenter |
| msoGradientFromCorner |
| msoGradientFromTitle |
| msoGradientHorizontal |
| msoGradientMixed |
| msoGradientVertical |
Variant Required Integer. The gradient variant. Can be a value from 1 through 4, corresponding to one of the four variants on the Gradient tab in the Fill Effects dialog box. If Style is msoGradientFromCenter, the Variant argument can only be 1 or 2.
TwoColorGradient method as it applies to the ChartFillFormat object.
Sets the specified fill to a two-color gradient.
expression.TwoColorGradient(Style, Variant)
expression Required. An expression that returns one of the above objects.
MsoGradientStyle
| MsoGradientStyle can be one of these MsoGradientStyle constants. |
| msoGradientDiagonalDown |
| msoGradientDiagonalUp |
| msoGradientFromCenter |
| msoGradientFromCorner |
| msoGradientFromTitle |
| msoGradientHorizontal |
| msoGradientMixed |
| msoGradientVertical |
Variant Required Long. The gradient variant. Can be a value from 1 through 4, corresponding to one of the four variants on the Gradient tab in the Fill Effects dialog box. If Style is msoGradientFromCenter, the Variant argument can only be 1 or 2.
Example
This 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 msoGradientHorizontal, 1
End With
Applies to | ChartFillFormat Object | FillFormat Object