Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Nov 2009
    Location
    Richland, WA, USA
    Posts
    8
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Is it possible to wrap text in an Excel chart axis (2007)?

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    I can't test in XL2007 but in earlier versions, you can select the axis title and put in a [Enter] to place a carriage return in the title

    If you mean the values you will have to add it to the categories label or use a custom number format with the added linefeeds...

    If you can elaborate I can describe it in more detail

    Steve

  3. #3
    New Lounger
    Join Date
    Nov 2009
    Location
    Richland, WA, USA
    Posts
    8
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thanks Steve. Frankly, I keep thinking that I am losing my 'marbles', because I am an experience user of previous versions of Excel. Transitioned over to 2007, and some things just don't work the same. I have some axis titles that are quite long that I wan't to wrap into two lines. What is happening is that the single lines (without text wrapping) push the axis out to take up 3/4 of my landscaped page, leaving the chart to display on only 1/4 of the page.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •