+ 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 Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

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

    Same answer as for your first post...

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

    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
    O365
    Posts
    20,419

    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)

Similar Threads

  1. my data range is 350 to 2500 but I want to start my axis label at 500
    By tharsis in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 03-08-2019, 04:21 PM
  2. Axis Label Range
    By ionelz in forum Excel Charting & Pivots
    Replies: 8
    Last Post: 02-26-2019, 01:42 PM
  3. [SOLVED] how to change the axis label range of chart in excel vba
    By ImranBhatti in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-07-2017, 10:17 AM
  4. With a move label macro, prevent label from moving onto another label
    By SocratesJC in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 12-09-2014, 12:34 AM
  5. vba code to update axis label range
    By CobraLAD in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-24-2014, 05:22 AM
  6. Changing X axis label range automatically and Create line for today
    By aaslezak in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-26-2013, 01:01 PM
  7. Trying to get VBA to use my Chart Axis Label name range
    By jacob@thepenpoint in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-18-2012, 09:04 AM

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