If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Category Axis Area in Bar Chart Cuts Words Apart on Wordwrap
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 |
Thread Tools | |
Display Modes | |
|
|