Thread: Label Text not Wrapping in 2007

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