Change color of bar on report chart

[DianeG63]

Hello everyone, I have not been a programmer in over 7 years but have been given an assignment to create an access routine to create a report with a chart. The chart will serve as somewhat of a dashboard. I need the bars of the chart to change color depending on how well or poorly the department is doing. I tried: me.fillcolor(1) = vbred
but I get the error: 'Can't assign to read-only property'. I think I need to find the actual names of the bars to reference them, but cannot figure out how to do so. Can someone please help an old dog trying to learn new tricks? thanks in advance, Diane

 

[DianeG63]

Hello Everyone, I have had small successes in getting this to work using the .SeriesCollection; however, it changes all the colors within the series to the color I am specifying. I need to just change one category. I have tried these different options listed below:
.SeriesCollection(1).SeriesCategory("HB").Interior.Color = vbRed
and
.SeriesCategory("HB").Interior.Color = vbRed

both give me the runtime error 438: 'Object doesn't support this property or method'

Any help would be greatly appreciated. Thanks, Diane