+ Reply to Thread
Results 1 to 6 of 6

How to make Chart Tick Labels Alignment to Left?

  1. #1
    Forum Contributor HerryMarkowitz's Avatar
    Join Date
    09-10-2012
    Location
    Istanbul / Turkey
    MS-Off Ver
    2013 - Win10 - 64bit
    Posts
    1,007

    How to make Chart Tick Labels Alignment to Left?

    Hi experts,
    As you can see following picture, Chart Tick Labels Alignment to Right;
    http://i.cubeupload.com/o46wxK.png
    Question: How to make Chart Tick Labels Alignment to Left?
    Sub DontForgetThese()
         If Your thread includes any code Then Please use code tags...
         If Your thread has been solved Then Please mark as solved...
         If Anybody has helped to you Then Please add reputation...
    End Sub

  2. #2
    Forum Expert
    Join Date
    10-09-2014
    Location
    Newcastle, England
    MS-Off Ver
    2003 & 2013
    Posts
    1,986

    Re: How to make Chart Tick Labels Alignment to Left?

    Right mouse over your chart > Format data labels > label Position > Inside Base
    If someone has helped you then please add to their Reputation

  3. #3
    Forum Contributor HerryMarkowitz's Avatar
    Join Date
    09-10-2012
    Location
    Istanbul / Turkey
    MS-Off Ver
    2013 - Win10 - 64bit
    Posts
    1,007

    Re: How to make Chart Tick Labels Alignment to Left?

    Hi pjwhitfield,
    Your advice is regarding "Series.Collection Labels".
    My question is regarding "Tick Labels".
    So, your answer is not regarding my question.
    But thanks anyway...

  4. #4
    Forum Contributor HerryMarkowitz's Avatar
    Join Date
    09-10-2012
    Location
    Istanbul / Turkey
    MS-Off Ver
    2013 - Win10 - 64bit
    Posts
    1,007

    Re: How to make Chart Tick Labels Alignment to Left?

    I have just added a sample workbook regarding this issue...
    Last edited by HerryMarkowitz; 08-28-2015 at 02:25 AM.

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

    Re: How to make Chart Tick Labels Alignment to Left?

    only way is to fake the axis labels with textboxes
    http://www.andypope.info/vba/Axislabel_textboxes.htm
    Cheers
    Andy
    www.andypope.info

  6. #6
    Forum Contributor HerryMarkowitz's Avatar
    Join Date
    09-10-2012
    Location
    Istanbul / Turkey
    MS-Off Ver
    2013 - Win10 - 64bit
    Posts
    1,007

    Re: How to make Chart Tick Labels Alignment to Left?

    Hi Andy,
    Thanks for your solution.
    It seems that your solution is not very efficent for my needs.
    But thank you as usual

+ 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. Format Chart Data Labels Alignment
    By MissaLissa in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-24-2013, 04:11 AM
  2. [SOLVED] move y-axis labels on column chart from left to right side
    By Kaye in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 05-25-2013, 11:57 PM
  3. Make 1 a tick in a tickbox and 0 no tick
    By ExcelFailure in forum Excel General
    Replies: 2
    Last Post: 04-02-2013, 07:28 AM
  4. Chart Labels alignment
    By divyavb80 in forum Excel General
    Replies: 3
    Last Post: 03-28-2012, 04:37 PM
  5. [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
  6. [SOLVED] How do I make chart labels or legends wordwrap?
    By LC673 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 02-23-2006, 04:45 PM
  7. How do I justify/align tick mark labels on a horizontal bar chart?
    By blinko in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 11-16-2005, 11:10 PM

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