Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel X Axis Word Wrap

Status
Not open for further replies.
ProgEval

ProgEval

MIS
Sep 21, 2006
59
US
I have charts in Excel 2007 and on the x axis I have text. Due to space I would like the text to word wrap to make it look cleaner, save space and keep everything legible. Any thoughts? Thanks in advance.
 
Sort by date Sort by votes



Enter the values in the sheet, as a formula, using CHAR(10), at the appropriate location, to force a line feed

Skip,
[sub]
[glasses]Just traded in my old subtlety...
for a NUANCE![tongue][/sub]
 
Upvote 0 Downvote
Can you type out an example? I think I just tried your suggestion and it did not work. I want to make sure I have it right. When the text is rotated to 90 or 270 degrees the label will still not word wrap. Thanks for your help.
 
Upvote 0 Downvote


="Word"&CHAR(10)&"Wrap"

Skip,
[sub]
[glasses]Just traded in my old subtlety...
for a NUANCE![tongue][/sub]
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Bijugate
  • Locked
  • Question
Excel update question
Replies
0
Views
317
Bijugate
Bijugate
Pirouette
  • Locked
  • Question
Excel workbook
Replies
1
Views
316
combo
combo
shytott
  • Locked
  • Question
Excel - Toggle Button Code 1
Replies
10
Views
921
shytott
shytott
renigar
  • Locked
  • Question
Excel Power Query refresh error
Replies
3
Views
745
SoftwareRT
SoftwareRT
arvarr
  • Locked
  • Question
Excel Formula Help 1
Replies
7
Views
324
SkipVought
S

Part and Inventory Search

Sponsor

Back
Top