+ Reply to Thread
Results 1 to 5 of 5

Select x-axis label source for a large label range

  1. #1
    Registered User
    Join Date
    03-16-2017
    Location
    sOUTH aFRICA
    MS-Off Ver
    2008
    Posts
    3

    Select x-axis label source for a large label range

    When I need to select the next date in the Axis label range (tick box) for the horizontal axis the complete range is not displayed. There are only 3 dots below the last available label.

    Is there a way of displaying the whole available range for axis labels?

    Currently I am using very laborious way of changing the range, tick the required label, and changing the range back.

    I've added dummy data with a chart and jpeg illustrating what I mean with the 3 dots at the end of the X-axis label selection list.


    Thanks for any assistance.
    Attached Images Attached Images
    Attached Files Attached Files
    Last edited by Ernst100; 12-03-2019 at 01:28 AM.

  2. #2
    Forum Moderator Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    8,606

    Re: Select x-axis label source for a large label range

    Same answer as for your first post...
    You really don't have to give me rep points for moderating. It's part of the job. Keep rep points for those who find solutions

  3. #3
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    2003, 2007, 2010 & 2013
    Posts
    18,690

    Re: Select x-axis label source for a large label range

    Looks like that is a hard cut off at 50 points.

    You could use the Filter pop out if you want to see all the values.
    Cheers
    Andy
    www.andypope.info

  4. #4
    Registered User
    Join Date
    03-16-2017
    Location
    sOUTH aFRICA
    MS-Off Ver
    2008
    Posts
    3

    Re: Select x-axis label source for a large label range

    Thank Andy. Wonder if there is a way of increasing the number at which it cut off?

  5. #5
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    2003, 2007, 2010 & 2013
    Posts
    18,690

    Re: Select x-axis label source for a large label range

    I doubt it as it would be something hard coded into Excel application.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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