Colour wheel pie chart

[Chameleon64]

Hi

I'm trying to create a gradual colour wheel in a pie chart style which starts from dark red at 12 o'clock, gradually changes clockwise to yellow and then to green to complete the wheel.

I've tried an autoshape but this doesn't generate the gradual colours in the way I'm looking for. I've also tried creating a pie chart and using VBA to change the RGB value but it's getting too complicated.

Any ideas??

 

[Chameleon64]

I figured it out in the end by creating a pie chart with 512 points and using the following VBA to colour-fill:

Sub ColourWheel()

For i = 1 To 512
With ActiveSheet.ChartObjects(1).Chart
        .SeriesCollection(1).Points(i).Interior.Color = RGB(512 - i, i, 0)
    End With
Next i


End Sub