Category Axis Area in Bar Chart Cuts Words Apart on Wordwrap

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Viper - 26 Sep 2003 21:48 GMT

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

Reply to this Message

Debra Dalgleish - 28 Sep 2003 02:31 GMT

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.

> 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
[quoted text clipped - 9 lines]
>
> Viper

Signature

Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Reply to this Message