Format Chart Data Lablel based on Target Value/Goal

[Jeff1959]

Hi all, I'm trying to figure out how to format the data label font color using VBA on a stacking Bar Graph, The format is based on the data value to a predetermined goal. ie if the goal is 50 hours and the actuals are 60 hours the font color turns red else it's green. This is beyond my present capabilities to figure out. Thanks in advance

[Jeff1959]

I have part of it figured out but I'm having trouble figuring out hoe to loop through all the data labels of the stacking bar chart to compair against target/Goal

[VBA] With ActiveChart.SeriesCollection(1).Points(2)
.DataLabel.Font.ColorIndex = 5
End With[/VBA]