+ Reply to Thread
Results 1 to 3 of 3

How to refine my x-axis dates units to show the actual x-axis dates from the series?

  1. #1
    Registered User
    Join Date
    02-23-2015
    Location
    texas
    MS-Off Ver
    MAC OSX
    Posts
    30

    How to refine my x-axis dates units to show the actual x-axis dates from the series?

    Hi there, I'm still researching the archives, but in the meantime:

    I have a chart (it works as both a line AND a scatter) with this column of dates shown as the x-axis:

    5/6
    5/13
    5/20
    5/21
    5/27
    6/3
    6/4
    6/10
    6/17
    6/24
    6/25



    1. these are formatted cells as dates
    2. the chart format (x axis) shows them as dates also)
    3. The major (i believe that is the term) units showing on the x-axis are:

    4/27 5/7 5/17 5/27 6/6 6/16 6/26 7/6

    I realize some of my dates are not evenly spaced. These are weekend events (saturday) with an occasional Sunday here and there: (see, 5/21, 6/4, 6/25).

    Without going increments of "1" which is really overkill, can I get the dates that are at least evenly spaced (7 days) to show on the axis?

    Does this involve creating a new source of data for the x-axis and then putting my chart x / y values onto that?

    Or, since all the data points over 10 series fall on the exact same dates, is there a way to perhaps get a vertical line pass through the data points and essentially "point" at the location on the x-axis?

    Thank you.
    Last edited by Jocamo; 06-22-2017 at 05:59 PM.

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    12,320

    Re: How to refine my x-axis dates units to show the actual x-axis dates from the series?

    Without going increments of "1" which is really overkill, can I get the dates that are at least evenly spaced (7 days) to show on the axis?
    I'm sure you can, but it will likely depend on whether you have a line chart (with a date axis) or a scatter chart (with a value axis). If I follow your description, it looks like the current major unit is 10 days. Can you simply change that to be 7 days in the format axis dialog?
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Registered User
    Join Date
    02-23-2015
    Location
    texas
    MS-Off Ver
    MAC OSX
    Posts
    30

    Re: How to refine my x-axis dates units to show the actual x-axis dates from the series?

    Thanks for the reply.

    It actually works better on the x axis (i can set 7 days) and just deal with those two extra "sundays" if I leave it as a line chart and not a scatter. But it seems to work well as both. I didn't think that was possible.

    My y-axis data is in the format: mm:ss.00, time values.

+ 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. Replies: 0
    Last Post: 06-20-2017, 10:48 AM
  2. Replies: 9
    Last Post: 09-22-2015, 02:43 AM
  3. Plotting two data series on same axis with different start dates (years)
    By dbjones1988 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 03-27-2014, 04:13 AM
  4. [SOLVED] Plot two series ordered by different dates in the same graph, on the same x-axis.
    By droppe in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 05-14-2013, 07:14 AM
  5. Replies: 1
    Last Post: 03-22-2012, 07:54 PM
  6. X-axis and label with dates of actual samples
    By sonora in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 08-08-2011, 02:12 PM
  7. How to show discrete dates on X-axis
    By ranjana in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 07-07-2010, 03:32 AM

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