Hi guys,

I have a bar chart that has 3 bars in a chart. I am using a 2D
Clustered Column. I need for each bar to have a seperate color.

Name FSR QC CQA
Leola 2 8 0

The color for the three? Using Late Binding, as I can't use Early
Binding since others are using different versions of Excel (2002 and
2003).

Select Case .ActiveCell.Value
Case "QC"
.Sheets("Chart1").Select
.ActiveChart.SeriesCollection(x).Select
.Selection.Interior.ColorIndex = 19
Case "FSR"
.Sheets("Chart1").Select
.ActiveChart.SeriesCollection(x).Select
.Selection.Interior.ColorIndex = 18
Case "CQA"
.Sheets("Chart1").Select
.ActiveChart.SeriesCollection(x).Select
.Selection.Interior.ColorIndex = 17
Case Else
'Do nothing
End Select

Is this possible?