MsoGradientStyle can be one of these MsoGradientStyle constants. |
msoGradientDiagonalDown |
msoGradientDiagonalUp |
msoGradientFromCenter |
msoGradientFromCorner |
msoGradientFromTitle |
msoGradientHorizontal |
msoGradientMixed |
msoGradientVertical
This property is read-only. Use the OneColorGradient or TwoColorGradient method to set the gradient style for the fill. |
expression.GradientStyle
expression Required. An expression that returns one of the objects in the Applies To list.
Example
This example sets the chart's fill format so that its gradient style is changed to msoGradientDiagonalUp if it was originally msoGradientDiagonalDown.
With myChart.ChartArea.Fill
If .Type = msoFillGradient Then
If .GradientColorType = msoGradientOneColor Then
If .GradientStyle = msoGradientDiagonalDown Then
.OneColorGradient msoGradientDiagonalUp, _
.GradientVariant, .GradientDegree
End If
End If
End If
End With