Aligning a Text Box in a stack on a bar chart?

[QuantBurner]

Hi,
I have a series of bar charts I need to update each month. At the bottom of each stack in the bar chart, I have a text box with the total of all the elements in the stack (some elements are positive and some are negative so, the total gives a net which is not readily apparent with positive and negative elements). The number of stacks will vary from month to month, so the number of text boxes will vary also. I'm wanting to write a vba macro that will add the textboxes, format them, put the total value as text in the text box, and align the text box vertically along the y-axis and center the box within each stack. Hope that's clear. I'm pretty sure I can figure out how to do erverything except align the textboxes within the stacks. Any help would be appreciated!
Cheers

 

[Andrew Poulsom]

Maybe this will help you:

http://www.appspro.com/Utilities/ChartLabeler.htm

 

[QuantBurner]

Thanks. I'm really looking for some code so I can do this myself.
Cheers,

 

[Andrew Poulsom]

Can't you see the code in that Add-In?

 

[Andy Pope]

The is for a bar chart but you should get the idea from the code
http://www.andypope.info/vba/Axislabel_textboxes.htm