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 |
expression.PresetGradientType
expression Required. An expression that returns one of the objects in the Applies To list.
This property is read-only. Use the PresetGradient method to set the preset gradient type for the fill.
Example
This example changes the chart's preset gradient fill format from silver to gold.
With myChart.ChartArea.Fill
If .Type = msoFillGradient Then
If .GradientColorType = msoGradientPresetColors Then
If .PresetGradientType = msoGradientSilver Then
.PresetGradient .GradientStyle, _
.GradientVariant, msoGradientGold
End If
End If
End If
End With