+ Reply to Thread
Results 1 to 5 of 5

How do I align text left the horizontal axis labels and wrap text them?

  1. #1
    Forum Contributor
    Join Date
    07-18-2014
    Location
    Missouri, USA
    MS-Off Ver
    2010
    Posts
    175

    How do I align text left the horizontal axis labels and wrap text them?

    This seems like a very easy thing to do yet I can't find how to do it. Of course, I am attaching an example but my real data has longer names that I need to left align and wrap the text so all of it can be seen.

    Thanks for your help.
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,613

    Re: How do I align text left the horizontal axis labels and wrap text them?

    Post a sample that reflects your actual data. This one does not.
    Ben Van Johnson

  3. #3
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,168

    Re: How do I align text left the horizontal axis labels and wrap text them?

    Hi,

    My best guess on helping is to have you watch this youtube video. Charting has changed a lot between versions of Excel. My 2013 version doesn't work like the 2010 version on this topic.
    https://www.youtube.com/watch?v=ALBqjXGIOh4
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  4. #4
    Forum Contributor
    Join Date
    07-18-2014
    Location
    Missouri, USA
    MS-Off Ver
    2010
    Posts
    175

    Re: How do I align text left the horizontal axis labels and wrap text them?

    My actual data has customer sensitive information that I don't want to post for public view. I want the y axis (Kim, Steve, Robert, Jane, Bob) to be left aligned and wrap texted. If that's not possible, that's fine.

  5. #5
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,436

    Re: How do I align text left the horizontal axis labels and wrap text them?

    The alignment of text is limited to vertical position.

    If you want fully formatting control over the labels you will need to replace the builtin labels with textboxes and use vba code to make formatting and positioning easier.
    http://www.andypope.info/vba/Axislabel_textboxes.htm
    Cheers
    Andy
    www.andypope.info

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Combobox Left Align Text that's too long to fit into cell
    By tigerlilly4321 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-08-2013, 12:08 AM
  2. Combobox Text Align left not working
    By Schwizer in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-16-2013, 01:31 PM
  3. [SOLVED] [SOLVED] Left align text labels in horizontal bar chart
    By avi in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 07-03-2006, 11:10 AM
  4. Align Right footer text to Left
    By Joel Mills in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-30-2005, 05:05 PM
  5. [SOLVED] Align text for labels in user forms
    By Tim Archer in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-25-2005, 09:06 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1