Share via

ChartFillFormat.PresetGradient Method

  • Article
Excel Developer Reference

Sets the specified fill to a preset gradient.

Syntax

expression.PresetGradient(Style, Variant, PresetGradientType)

expression   A variable that represents a ChartFillFormat object.

Parameters

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 is msoGradientFromCenter, the Variant argument can only be 1 or 2.
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 
  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