Since I just use Rob Bovey's chart labeler add-in, I'm not very familiar with the code behind it, and this OP claims that he cannot use third party add-ins for the task. If he needs further help developing the procedure for this, can someone step in and help him?

http://www.excelforum.com/excel-prog...ta-labels.html