PresetGradientType Property

Applies To

ChartFillFormat object, FillFormat object.

Description

Returns the preset gradient type for the specified fill. Read-only Long.

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
msoPresetGradientMixed

Use the PresetGradient method to set the preset gradient type for the fill.

Example

This example sets the fill format for chart two to the same style used for chart one.

Set c1f = Charts(1).ChartArea.Fill
If c1f.Type = msoFillGradient Then
    With Charts(2).ChartArea.Fill
        .Visible = True
        .PresetGradient c1f.GradientStyle, _
            c1f.GradientVariant, c1f.PresetGradientType
    End With
End If