Vba - change column graph color gradients with macro

Hi there.

I have a simple column chart in a 2007 excel doc, and the bars have "2-stop" color gradient on them. Color stop 1 is bright orange, and color stop 2 is black.

I want to create a macro that changes the bright orange color to bright red using VBA.
___

I found this website, but I cant make sense of it - http://code.msdn.microsoft.com/offic...-with-ae123477

___

Ideally I want something of that looks roughly like:

ActiveChart.SeriesCollection(1).Interior.Fill.Gradient.ColorStop1 = RGB (255, 0, 0)

___

Any help is appreciated.