MS Graph in VBA setting gradient color of a bar

[ytapez]

I am trying to learn how to set the gradient color of a bar on the chart
using VBA Access 2003 with reference to "Microsoft Graph 11.0 Object Library"

I can easily do this with one color using the Interior property below:

objGraph.SeriesCollection(1).Interior.Color = RGB(255, 0, 0)

However, I would like to do the same thing but using a gradient color
Similar to the example below - but this example paints the whole page not the bar.

With myChart.ChartArea.Fill
If .Type = msoFillGradient Then
If .GradientColorType = msoGradientOneColor Then
.OneColorGradient Style:=msoGradientFromCorner, _
Variant:=1, Degree:=0.3
End If
End If
End With

Is it even possible to fill a bar a gradient color???

thanks