Results 1 to 5 of 5

Select x-axis label source for a large label range

Threaded View

  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.

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