Results 1 to 10 of 10
  1. #1
    Lounger
    Join Date
    Mar 2010
    Location
    South Wales
    Posts
    27
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Excel 2002 doesn't right justifty Y axis labels, it seems to centre justify as default. Any ideas as to how to overcome this please?

  2. #2
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I think you cannot do this in the usual way. All I could come up with was by adding textboxes on top of the chart, which is hardly very user friendly.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  3. #3
    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
    The Axis label is moveable manually. Just move the box to the top of the axis. You may have to adjust it if the text changes, but this is still just a drag/drop...

    Steve

  4. #4
    Lounger
    Join Date
    Mar 2010
    Location
    South Wales
    Posts
    27
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by sdckapr View Post
    The Axis label is moveable manually. Just move the box to the top of the axis. You may have to adjust it if the text changes, but this is still just a drag/drop...

    Steve
    Hi Steve

    I tried this but nothing moves when I try to drag and drop. Am I missing something?

    Tony

  5. #5
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    Are you talking about tick mark labels or the axis label (only one per axis)?
    Regards,
    Rory

    Microsoft MVP - Excel

  6. #6
    Lounger
    Join Date
    Mar 2010
    Location
    South Wales
    Posts
    27
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Tick mark labels. Some of the categories we have to use are quite wordy and the text wrap won't right justify.

  7. #7
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Tick mark labels cannot be aligned other than centered unfortunately.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  8. #8
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    If you are talking about the category axis, you could clear the tick labels from the axis altogether, add datalabels to a series using the category names, right align them and then drag them to the relevant location?
    Regards,
    Rory

    Microsoft MVP - Excel

  9. #9
    Lounger
    Join Date
    Mar 2010
    Location
    South Wales
    Posts
    27
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by rory View Post
    If you are talking about the category axis, you could clear the tick labels from the axis altogether, add datalabels to a series using the category names, right align them and then drag them to the relevant location?
    Are we talking texboxes here? That's the fix we use currently and want to avoid it as Excel is notoriously not WYSIWYG and the 'finished' product is nowhere near ready for our publication.

  10. #10
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Tony,

    I see you're wrestling with trying to create charts in Excel that require "publication" quality.
    Whilst Excel is very versatile, creating publication quality charts isn't one of it's strong points (though Excel 2007 is slightly better).

    Wouldn't you benefit in trying a dedicated charting package? Sigmaplot comes to mind here.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

Posting Permissions

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