To help control where the labels break, you can add line breaks in the
label cells on the worksheet.
For example, in the cell that contains "Professional", type a hyphen
after the first 's', then type Alt+Enter, to add a line break.
Viper wrote:
I have a bar chart in Excel 2000, and I need to fit a lot
of Data into a small chart area. Currently, the data is
being displayed properly, but the Category Axis Labels
are being wordwrapped and when this happens, it just cuts
a word in half. For instance, one label is 'Professional'
and it gets displayed as the following:
'Professio'
'nal'
Any suggestions at how to control this so that it doesn't
happen would be much appreciated. Thanks.
Viper
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html