Sets the specified fill to a preset gradient.

expression.PresetGradient(Style, Variant, PresetGradientType)expressionRequired. An expression that returns one of the objects in the Applies To list.Style Required . The gradient style for the specified fill.

MsoGradientStyle can be one of these MsoGradientStyle constants.
msoGradientDiagonalDown
msoGradientDiagonalUp
msoGradientFromCenter
msoGradientFromCorner
msoGradientFromTitle
msoGradientHorizontal
msoGradientMixed
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 Gradienttab in the Fill Effectsdialog box. If Styleis msoGradientFromCenter, the Variantargument can only be 1 or 2.PresetGradientType Required . The gradient type for the specified fill.
MsoPresetGradientType can be one of these MsoPresetGradientType constants.
msoGradientBrass
msoGradientChrome
msoGradientDaybreak
msoGradientEarlySunset
msoGradientFog
msoGradientGoldII
msoGradientLateSunset
msoGradientMoss
msoGradientOcean
msoGradientPeacock
msoGradientRainbowII
msoGradientSilver
msoGradientWheat
msoPresetGradientMixed
msoGradientCalmWater
msoGradientChromeII
msoGradientDesert
msoGradientFire
msoGradientGold
msoGradientHorizon
msoGradientMahogany
msoGradientNightfall
msoGradientParchment
msoGradientRainbow
msoGradientSapphire

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