MsoGradientColorType can be one of these MsoGradientColorType constants. |
msoGradientColorMixed |
msoGradientOneColor |
msoGradientPresetColors |
msoGradientTwoColors |
expression.GradientColorType
expression Required. An expression that returns one of the objects in the Applies To list.
Example
This example sets the fill format for chart two to the same style used for chart one.
Set c1f = Charts(1).ChartArea.Fill
If c1f.Type = msoFillGradient And _
c1f.GradientColorType = msoGradientOneColor Then
With Charts(2).ChartArea.Fill
.Visible = True
.OneColorGradient c1f.GradientStyle, _
c1f.GradientVariant, c1f.GradientDegree
End With
End If