This thread is long dead, but in case anyone finds this thread like I did, there is a workaround to the issue of setting chart properties on a report. Basically, you need to set the focus on the report before the OLE objects load. Like so:
Private Sub Report_Open(Cancel As Integer)
Dim ch As...