+ Reply to Thread
Results 1 to 3 of 3

Graph X axis (multi-level category labels) not showing all the text

  1. #1
    Registered User
    Join Date
    06-04-2013
    Location
    Australia
    MS-Off Ver
    Excel 2007
    Posts
    3

    Graph X axis (multi-level category labels) not showing all the text

    I have created a graph with multi-level category labels by weeks, months and years, however some months is not appearing on the graph x-axis. I have adjusted all the font size but still with missing months (ie Jul, Aug & Sep appears in the graph but Oct, Nov & Dec are missing). Greatly appreciate receiving assistance on how to fix this.

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

    Re: Graph X axis (multi-level category labels) not showing all the text

    Ensure you set Interval between labels to 1.

    I believe there is a bug with 100+ category items.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    06-04-2013
    Location
    Australia
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Graph X axis (multi-level category labels) not showing all the text

    Thanks Andy for your reply. I set to 1 the Interval between labels but still not working. I agree this is excel bug. It works fine if I have to hide (or limit the axis the reference) some of the column data reference.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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