+ Reply to Thread
Results 1 to 3 of 3

How to show X-axis labels with intervals, but always show the latest label?

  1. #1
    Registered User
    Join Date
    03-09-2015
    Location
    US
    MS-Off Ver
    2010
    Posts
    26

    How to show X-axis labels with intervals, but always show the latest label?

    I have several line charts with data by day that gets updated daily. This means there are a lot of data points and I can set intervals manually or let Excel do it automatically. I'd like to have Excel do it automatically while always showing the most recent date regardless of where it falls in the interval. The only way I can think of doing it right now is changing the interval manually everytime to make sure the current date shows up on the axis labels or manually keeping the interval at 1 (which is the best solution currently as it requires no daily adjustments).

    I've attached an example that is missing the latest 4/28 date on the axis.

    Is this possible?
    Attached Files Attached Files

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

    Re: How to show X-axis labels with intervals, but always show the latest label?

    Simplest way is to include another series with only the last data point having a value of zero.

    In the attached I have set last point to display.
    You can then extend the data to include 3 extra data points. Then move the zero value to the end point.

    There is also a column showing where category labels appear if you alter the frequency. this can help you determine what is an appropriate interval if you prefer that approach.
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    03-09-2015
    Location
    US
    MS-Off Ver
    2010
    Posts
    26

    Re: How to show X-axis labels with intervals, but always show the latest label?

    Thank you. This works and if the normal labels cover the recent data I can leave that column blank.

+ 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. Can't get axis labels to show up on my chart
    By dianaCatz in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 05-05-2019, 11:28 AM
  2. show last x-axis label
    By NickyC in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 11-27-2016, 11:16 PM
  3. [SOLVED] Need graph to show alphanumeric values as Y axis labels with Date as Z axis labels
    By Ochimus in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 06-24-2015, 08:40 PM
  4. Not to show axis label if value is zero
    By akhileshgs in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 06-10-2013, 08:36 AM
  5. Replies: 1
    Last Post: 09-15-2011, 05:23 AM
  6. How to show all X-axis labels on excel graph
    By harryhu in forum Excel General
    Replies: 1
    Last Post: 04-14-2009, 05:12 AM
  7. data labels to show value, label & percent
    By nihad in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-16-2006, 04:45 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