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