I am trying to change the formatting of a single data label in a bar chart in Excel 2010. I have a very short procedure for this using VBA, however it seems to be causing an odd problem. After executing the code, it's as if the link between the label and the data has been broken, because even if the source data changes, the label does not. The bar itself still seems to be linked, because it changes to reflect the new data, but the label does not. Furthermore, the actual format I'm trying to apply does not do what it's supposed to either.
The only way to return to the correct value in the label is to delete labels for that data series and then apply them again. I'm attaching an example if you'd like to check it out. I reset the data labels in this version, so that you can run the applicable procedure and see if you're getting the same problem. I appreciate your help.