+ Reply to Thread
Results 1 to 8 of 8

Add Time Increments to Plot

  1. #1
    Registered User
    Join Date
    07-14-2011
    Location
    Wilmington, NC, USA
    MS-Off Ver
    Excel 2010
    Posts
    3

    Add Time Increments to Plot

    Hey all,

    Is there any way to add say, 60 second increments, to a plot?

    I've got a plot of about 10 minutes long with timestamps on the x-axis, and I was wondering if there was any way to illustrate 1 minute intervals or something along those lines.

    Thanks a lot!

  2. #2
    Spammer
    Join Date
    01-26-2010
    Location
    Worcester MA
    MS-Off Ver
    Excel 2003
    Posts
    184

    Re: Add Time Increments to Plot

    Do you mean you want to adjust the tick spacing so it's one tick every 60 seconds?

    In Excel 2003 and earlier you can enter your axis scale parameters in time format, so for something that goes from 0:00:00 to 0:10:00, you could enter 0 as minimum and 0:10 (or 0:10:00) as max, and then 0:1 (or 0:01:00) for one minute intervals.

    Excel 2007 broke this functionality, and in 2010 it's still broken. But you can convert time to fraction in the worksheet. Enter 0:10:00 (for max) in a cell and 0:01:00 (for spacing) in another. Then change the cells' number format to General, so 10 minutes becomes 0.00694444 and 1 minute becomes 0.000694444. Enter these into the axis scale parameter boxes.

    You can format the axis tick labels as times as well.
    Jon Peltier
    http://PeltierTech.com/

  3. #3
    Registered User
    Join Date
    07-14-2011
    Location
    Wilmington, NC, USA
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Add Time Increments to Plot

    I don't mean changing the tick intervals to 60 seconds, I want to place markers on the graph that indicate 60 second gaps without any relation to the data. More so for demonstration purposes rather than modifying the data itself..

    Any ideas?

  4. #4
    Spammer
    Join Date
    01-26-2010
    Location
    Worcester MA
    MS-Off Ver
    Excel 2003
    Posts
    184

    Re: Add Time Increments to Plot

    Sure, add another series to the chart, with markers at the X values you want (every ten seconds) and a reasonable Y value. I suggest you use different markers than the real data uses, to avoid confusion.

  5. #5
    Registered User
    Join Date
    07-14-2011
    Location
    Wilmington, NC, USA
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Add Time Increments to Plot

    Awesome, that works. Thanks!

  6. #6
    Registered User
    Join Date
    09-19-2012
    Location
    USA, Maryland
    MS-Off Ver
    Excel 2010
    Posts
    7

    Re: Add Time line 12am to 12pm to Plot

    I am looking to have my chart have actual times on the bottom ie. 12am thru 12pm with 1/2 hour increments
    I've tried the below and I am just not getting it right, so any help would be much appreciated. I have dates going vertical and I need to plot the time that files arrived on those dates ie 10:36am using military time is not an issue. I just need to have the time going across the bottom

  7. #7
    Spammer
    Join Date
    01-26-2010
    Location
    Worcester MA
    MS-Off Ver
    Excel 2003
    Posts
    184

    Re: Add Time Increments to Plot

    You need to make an XY chart (not line chart) with times as X and dates as Y. In some versions of Excel you can enter your scale parameters as times (like 6:00 or 9/19/2012) and in some versions (notably 2007) you need to convert to numbers. Time is fraction of a day, so 6:00 AM = 0.25; date is number of days since a reference date, so 9/19/2012 = 41171 (enter the date into a cell, and change the format to General).

  8. #8
    Forum Expert Cutter's Avatar
    Join Date
    05-24-2004
    Location
    Ontario,Canada
    MS-Off Ver
    Excel 2010
    Posts
    6,451

    Re: Add Time Increments to Plot

    Hello blori, and welcome to the forum.

    Unfortunately you have inadvertently broken one of the forum rules. Please read the following and make the necessary change. Thanks.

    Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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