You can format the data labels for one series in a single step. After
creating the data labels, double-click any of the labels. Use the Font tab
to adjust the font and the Alignment tab to adjust the position (for your
specific case, set the 'Label Position' to 'Center').

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
Hi

I'm using Excel 2002.

I have a created Horizontal Bar Chart with data labels displayed.

I want to center the data label text within the center of each bar and
adjust the font size.

So far I have only been able to do this on each individual bar - when there
are a lot of bars this is tedious!

Is there a way I can set the format of the data labels for the whole chart
in one go?

Thanks for your time.

Ian