Wrapping of Text in X-Axis 2007 Charts
 

Hi,

I have developed a macro in 2003 that automatically creates charts. The text
labels underneath the chart wrap perfectly and the chart is auto sized.

I am now using that macro on 2007 and when charts are created the text
underneath the chart no longer wraps. Looking at the options in 2007 there is
an Alignment tab for formatting the axis but none of the available options
seem to be able to set label wrapping. The auto-fit option is greyed out.

Any help would be appreciated