Class ChartSeriesGradientStopData (Excel VBA)

Item

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

Dim csg as ChartSeriesGradientStopData
Set csg = ActiveChart.FullSeriesCollection(1).SeriesColorMaxGradientStop

The following procedures can be used to set variables of type ChartSeriesGradientStopData: Series.SeriesColorMaxGradientStop, Series.SeriesColorMidGradientStop and Series.SeriesColorMinGradientStop.

StopColor

Dim sgsStopColor As SeriesGradientStopColorFormat
Set sgsStopColor = ActiveChart.FullSeriesCollection(1).SeriesColorMaxGradientStop.StopColor

StopPositionType

xlGradientStopPositionTypeExtremeValue, xlGradientStopPositionTypeNumber, xlGradientStopPositionTypePercent.
ActiveChart.FullSeriesCollection(1).SeriesColorMaxGradientStop.StopPositionType = xlGradientStopPositionTypeExtremeValue

StopValue

ActiveChart.FullSeriesCollection(1).SeriesColorMaxGradientStop.StopValue =