Hi,
You might try the free XL Chart Labeler. it allows you to reposition all
data labels at once.
http://www.appspro.com/Utilities/ChartLabeler.htm
If this helps, please click the Yes button.
Cheers,
Shane Devenshire
"Stealth" wrote:
Hello,
I have a 3-D Column graph made in Excel 2007.
I turn on the data labels and try to place them in the middle of the column
but the only way I can do this is manualy one data label at a time.
If Right-Click on a data label Format Data Labels Alignment and change
Vertical alignment nothing happens.
Text direction and Angle work fine just not Vertical Alignment.
How do I place all data labels to be in the middle of the columns without
having to drag each and every one to the middle of it's column?
Cheers,