I have a report in Access 2010 that contains a graph. I need to change the color and gradient effects of a data sereies programmatically. I can change the color but when I try to change the gradient I get the error "object does not support this property or method". I am using the code below. What am I doing wrong?
Private Sub Report_Load()
Dim SummGraph As Chart
Dim pt As ChartGroup
Set SummGraph = Me.SummaryGraph.Object.Application.Chart 'initialize things to a normal look
.Interior.Color = RGB(255, 0, 0)
.OneColorGradient msoGradientHorizontal, Variant:=1, Degree:=0.3