Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    May 2001
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Charts & X-axis labels

    I have a bar chart with positive and negative data. The x-axis labels show up just under the 0 line, about halfway up the chart. Is there a way to automatically move these labels to the bottom of the chart? In the past, I've ended up creating a text box to put the labels in their proper position.

  2. #2
    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

    Re: Charts & X-axis labels

    Hi,
    If you right-click on the x-axis, choose Format axis and then change Tick mark labels from 'Next to axis' to 'Low', the labels should appear at the bottom of the chart.
    Hope that helps.
    Regards,
    Rory

    Microsoft MVP - Excel

  3. #3
    New Lounger
    Join Date
    May 2001
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Charts & X-axis labels

    Thanks Rory! That's exactly what I needed. Why its on the "Patterns" tab instead of alignment, I guess we'll never know ....

Posting Permissions

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