Classe ChartSeriesGradientStopData (Excel VBA)

Set

Para usar uma variável de classe ChartSeriesGradientStopData, ela primeiro precisa ser instanciada por exemplo

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

Os procedimentos a seguir podem ser usados ​​para definir variáveis ​​do tipo ChartSeriesGradientStopData: Series.SeriesColorMaxGradientStop, Series.SeriesColorMidGradientStop e Series.SeriesColorMinGradientStop

Parent

StopColor

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

StopPositionType

Os valores possíveis são xlGradientStopPositionTypeExtremeValue, xlGradientStopPositionTypeNumber, xlGradientStopPositionTypePercent.
ActiveChart.FullSeriesCollection(1).SeriesColorMaxGradientStop.StopPositionType = xlGradientStopPositionTypeExtremeValue

StopValue

ActiveChart.FullSeriesCollection(1).SeriesColorMaxGradientStop.StopValue =