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
0
0
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
  • Question
Excel update question
Replies
0
Views
106
Bijugate
Bijugate
Pirouette
  • Locked
  • Question
Excel workbook
Replies
1
Views
133
combo
combo
arvarr
  • Locked
  • Question
Excel Formula Help 1
Replies
7
Views
153
SkipVought
S
M
  • Locked
  • Question
Excel Power Query
Replies
4
Views
136
combo
combo
Cpreston
  • Locked
  • Question
Excel Networking days
Replies
4
Views
131
SkipVought
S

Part and Inventory Search

Sponsor

Back
Top