Sets the specified fill to a preset gradient.
expression. PresetGradient( Style, Variant, PresetGradientType)
expression Required. An expression that returns one of the objects in the Applies To list.
StyleRequired MsoGradientStyle . The gradient style for the specified fill.
|MsoGradientStyle can be one of these MsoGradientStyle constants.| | msoGradientDiagonalDown| | msoGradientDiagonalUp| | msoGradientFromCenter| | msoGradientFromCorner| | msoGradientFromTitle| | msoGradientHorizontal| | msoGradientMixed| | msoGradientVertical| VariantRequired 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. PresetGradientTypeRequired MsoPresetGradientType . 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|
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