Поделиться через

FillFormat.PresetGradientType Property

Excel Developer Reference

Returns the preset gradient type for the specified fill. Read-only MsoPresetGradientType.

Syntax

expression.PresetGradientType

expression   A variable that represents a FillFormat object.

Remarks

Use the PresetGradient method to set the preset gradient type for the fill.

Example

This example sets the fill format for chart two to the same style used for chart one.

Visual Basic for Applications 
  Set c1f = Charts(1).ChartArea.Fill
If c1f.Type = msoFillGradient Then
    With Charts(2).ChartArea.Fill
        .Visible = True
        .PresetGradient c1f.GradientStyle, _
            c1f.GradientVariant, c1f.PresetGradientType
    End With
End If

See Also