Syntax

expression.PresetGradient(Style, Variant, PresetGradientType)

expression An expression that returns a ChartFillFormat object.

Parametersis msoGradientFromCenter, the Variantargument can only be 1 or 2.

Name Required/Optional Data Type Description
Style Required MsoGradientStyle The gradient style.
Variant Required Integer The gradient variant. Can be a value from 1 through 4, corresponding to one of the four variants on the Gradient tab in the Fill Effects dialog box. If GradientStyle
PresetGradientType Required MsoPresetGradientType The preset gradient type.

Example
This example sets the fill format for chart two to the same style used for chart one. Visual Basic for Applications

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