Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Feb 2001
    Location
    Middletown, New Jersey, USA
    Posts
    31
    Thanks
    0
    Thanked 0 Times in 0 Posts

    x-axis formating with label (97 SR2)

    I am plotting a bar chart with 32 categories. I would like to put a label on the x-axis for each category. What is happening is that Excel puts the label for one category out of two.
    I reoriented the text to be in a vertical fashion but this did not help.
    I though of "tricking" the program and inserting a blank line. This works for up to 18 blank lines then it breaks down.
    It seems that there is a limit on the number of categories that can be put as labels on the x-axis before Excel assumes that it does not have enough room for the text and then decides to jump one category.

    Is there a way to go around this limitation? Thanks

  2. #2
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Kortrijk, Belgium
    Posts
    571
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: x-axis formating with label (97 SR2)

    You can either:
    1) decrease the font size of the labels
    2) enlarge the graph and maintain the font size

  3. #3
    Lounger
    Join Date
    Feb 2001
    Location
    Middletown, New Jersey, USA
    Posts
    31
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: x-axis formating with label (97 SR2)

    Thanks. It worked

Posting Permissions

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