Control bar chart colors with VBA

[LScharf]

Hi,
I'd like to set the color of a specific bar in a bar chart in my report. The chart (MSGraph.Chart.8) is dynamic, so I can't edit the color in design view.

I've added this code:

Private Sub GroupFooter0_Format(Cancel As Integer,
FormatCount As Integer)

Me!Graph5.SeriesCollection(1).Points(1).Interior.Color = "yellow"

End Sub

...but it tells me 'run-time error 1004 - can't set the color property of the interior class'.

(Ultimately I'll replace the index (1) with a specific name.)
I'm using Access XP.

Thanks!