Returns the preset gradient type for the specified fill. Read-only MsoPresetGradientType.
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.
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