FillFormat.PresetGradientType Property (Excel)
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.
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