Class SeriesGradientStopColorFormat (Excel VBA)

Item

To use a SeriesGradientStopColorFormat class variable it first needs to be instantiated, for example

Dim sgs as SeriesGradientStopColorFormat
Set sgs = ActiveChart.FullSeriesCollection(1).SeriesColorMaxGradientStop.StopColor

SeriesGradientStopColorFormat class variables can be set using the ChartSeriesGradientStopData.StopColor procedure.

ObjectThemeColor

ActiveChart.FullSeriesCollection(1).SeriesColorMaxGradientStop.StopColor.ObjectThemeColor =

RGB

ActiveChart.FullSeriesCollection(1).SeriesColorMaxGradientStop.StopColor.RGB =

TintAndShade

ActiveChart.FullSeriesCollection(1).SeriesColorMaxGradientStop.StopColor.TintAndShade =

Transparency

ActiveChart.FullSeriesCollection(1).SeriesColorMaxGradientStop.StopColor.Transparency =

Type

Dim mctType As Office.MsoColorType
mctType = ActiveChart.FullSeriesCollection(1).SeriesColorMaxGradientStop.StopColor.Type