setting the gradientstops of a point in a macro

[el_doctor74]

Hello!
I want to format each point of a serie in a chart. Each point has 3
gradientstops: 0, 50 and 100%. there's no problem in setting them from the
excel interface, but I need creating them by means of a macro. I tried
something like:

Activechart.seriescollection(1).fill.gradientstops.insert rgb(0,255,0), 0.50

to insert the middle gradientstop, but this does not work.
Someone knows how can I solve this problem?

Thanks a lot!

 

[ArbynTX]

Add the Point reference:
ActiveChart.SeriesCollection(1).Points(1).Format.Fill.GradientStops.Insert RGB(0, 255, 0), 0.50