Category Axis Area in Bar Chart Cuts Words Apart on Wordwrap

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

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