PresetGradient Method

Applies To

ChartFillFormat object.

Description

Sets the specified fill to a preset gradient.

Syntax

expression.PresetGradient(Style, Variant, PresetGradientType)

expression Required. An expression that returns a ChartFillFormat object.

Style Required Long. The gradient style for the specified fill. Can be one of the following MsoGradientStyle constants: msoGradientDiagonalDown, msoGradientDiagonalUp, msoGradientFromCenter, msoGradientFromCorner, msoGradientHorizontal, or msoGradientVertical.

Variant Required Long. The gradient variant for the specified fill. Can be a value from 1 through 4, corresponding to the four variants listed on the Gradient tab in the Fill Effects dialog box. If Style is msoGradientFromCenter, the Variant argument can only be 1 or 2.

PresetGradientType Required Long. The gradient type for the specified fill. Can be one of the following MsoPresetGradientType constants: msoGradientBrass, msoGradientCalmWater, msoGradientChrome, msoGradientChromeII, msoGradientDaybreak, msoGradientDesert, msoGradientEarlySunset, msoGradientFire, msoGradientFog, msoGradientGold, msoGradientGoldII, msoGradientHorizon, msoGradientLateSunset, msoGradientMahogany, msoGradientMoss, msoGradientNightfall, msoGradientOcean, msoGradientParchment, msoGradientPeacock, msoGradientRainbow, msoGradientRainbowII, msoGradientSapphire, msoGradientSilver, msoGradientWheat, or msoPresetGradientMixed.

Example

This example sets the chart's fill format to the preset brass color.

With myChart.ChartArea.Fill
    .Visible = True
    .PresetGradient msoGradientDiagonalDown, 3, msoGradientBrass
End With