Graph1.SeriesCollection works in form and fails in report

[baba]

Runtime error '438':
Object doesn't support this property or method

Graph1.SeriesCollection(1).Points(j).Interior.Colo r = RGB(128, 100, 162)

However,it works in form but causing error in report in Private Sub Report_Load() .

Could you please help !

[June7]

Try it in the Format event of whatever section the chart is in.

[baba]

I have placed my barchart in report header and when i run the report,it goes directly into
Sub Report_Load() and is not entering the code that I have placed inside Sub ReportHeader_Format .Please advise.

Actually it works when i run it through vba code by a button click. It works as expected. Thanks for the help !!!

[mbschops]

Try using the on paint event of the header section, it worked for my charts in the detail section!