GradientStyle property (Excel Graph)

Returns the gradient style for the specified fill. Read-only MsoGradientStyle.

Syntax

expression.GradientStyle

expression Required. An expression that returns one of the objects in the Applies To list.

Remarks

This property is read-only. Use the OneColorGradient or TwoColorGradient method to set the gradient style for the fill.

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

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.