Muokkaa

Jaa


FillFormat.GradientDegree property (Excel)

Returns the gradient degree of the specified one-color shaded fill as a floating-point value from 0.0 (dark) through 1.0 (light). Read-only Single.

Syntax

expression.GradientDegree

expression A variable that represents a FillFormat object.

Remarks

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

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

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.