View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.charting
Shane Devenshire[_2_] Shane Devenshire[_2_] is offline
external usenet poster
 
Posts: 3,346
Default Excel 07 3D Column data label alignment

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,