+ Reply to Thread
Results 1 to 3 of 3

Horizontal exis to only show every 12th label (excluding the 1st as well)

  1. #1
    Registered User
    Join Date
    02-21-2011
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    66

    Horizontal exis to only show every 12th label (excluding the 1st as well)

    Howdy all,

    I'm trying to only show every 12th label on the horizontal axis, so 12/24/36 (and ignoring 1).

    But when I update the "Specify Interval Unit" to 12, it shows the 1st then 13th then 25th then nothing (as the data ends at 36).

    If I change it to 11, it shows the 1st, then 12th (success) but then 23rd and then 34th.

    I've been playing around with this for too long and feel that I'm missing something super simple, does anyone have any ideas of how to change this in the Format Axis area (hmm or elsewhere maybe), as well as lose the 1 label too please?

    Screenshots attached for reference, the first being the current state and the second being the amendment to 12 Interval Unit that doesn't work but the desired outcome in green.

    Thanks,
    Mike
    Attached Images Attached Images

  2. #2
    Forum Expert
    Join Date
    10-10-2016
    Location
    Sheffield
    MS-Off Ver
    365 and rarely 2016
    Posts
    3,198

    Re: Horizontal exis to only show every 12th label (excluding the 1st as well)

    either add a zero for the axis, or create another row for your axis, where all other values are blanks. 11 blanks, 12, 11blanks,24 etc

    I do not think there is a formatting option to do what you want

  3. #3
    Registered User
    Join Date
    02-21-2011
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    66

    Re: Horizontal exis to only show every 12th label (excluding the 1st as well)

    Ah, ok, thanks for the guidance and update, was hoping for a quick & easy (well, easier) formatting option but that will work nicely, appreciated

+ 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. Sum every 12th cell works until 12th iteration ... why?
    By thepinkgeologist in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-26-2015, 05:45 AM
  2. Horizontal axis not showing label.
    By kbsacto in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 09-21-2015, 03:48 PM
  3. horizontal category axis label
    By ammartino44 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-11-2014, 01:25 PM
  4. Font glitch when copying chart exis label?
    By seanspotatobusiness in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 02-24-2014, 11:09 AM
  5. Changing the label on the Horizontal Axis
    By vkartikv in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 01-25-2013, 05:04 AM
  6. [SOLVED] how to set horizontal axis label
    By Orongo in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-05-2013, 03:38 PM
  7. Label horizontal axis
    By seo1 in forum Excel General
    Replies: 4
    Last Post: 12-22-2010, 01:04 PM

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