Sets the specified fill to a preset gradient.

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
120 acp acp120 ofv ofv120 olv olv120 pbv pbv120 pjv pjv120 ppv ppv120 sdv sdv120 vov vov120 wdv wdv120 xlv xlv120