PDA

View Full Version : Format Chart Data Lablel based on Target Value/Goal



Jeff1959
04-01-2009, 09:54 AM
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 :banghead:

Jeff1959
04-01-2009, 11:03 AM
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

With ActiveChart.SeriesCollection(1).Points(2)
.DataLabel.Font.ColorIndex = 5
End With