Classe ChartSeriesGradientStopData (Excel VBA)

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

StopColor


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

StopPositionType

Os valores de retorno possíveis são xlGradientStopPositionTypeExtremeValue, xlGradientStopPositionTypeNumber, xlGradientStopPositionTypePercent.


ActiveChart.FullSeriesCollection(1).SeriesColorMaxGradientStop.StopPositionType = xlGradientStopPositionTypeExtremeValue

StopValue


ActiveChart.FullSeriesCollection(1).SeriesColorMaxGradientStop.StopValue =