1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

plot a timeline in Excel

Discussion in 'Business Applications' started by gordonlh, Oct 14, 2004.

Thread Status:
Not open for further replies.
Advertisement
  1. gordonlh

    gordonlh Thread Starter

    Joined:
    Oct 14, 2004
    Messages:
    2
    I want to plot times during a 24-hour day during which some activity occurs. I want "Day" (of month) on the y-axis and "Period of Time [of activity]" on the x-axis. I want x-axis bars extending from the time each activity period begins until the time it ends; there would be several such periods each day. There would be 30 days along the y axis

    Would Excel plot such a graph and, if so, what function(s) would I use? How would I get the multiple horizontal bars across the screen for each day?
     
  2. XL Guru

    XL Guru

    Joined:
    Aug 30, 2003
    Messages:
    2,702
    Caveat ; I never work with charts.

    There's a "Floating Bars" custom type, I thought it might have some scope but couldn't get anywhere with it. Here's what I did.

    Time intervals in A1, A2 ... of 00:00, 00:10, etc.

    In B1 etc, blanks or 1s, eg: blank, blank, 1, 1, 1, blank. In C1 etc, blanks or 2s, in D1 etc, blanks or 3s. Etc, etc.

    Plotted the whole thing as an xy scatter, attached ; just change the ext to xls.

    As far as the y-axis values go, pass. Here are some chart wiz links:

    http://www.geocities.com/jonpeltier/index.html

    http://www.tushar-mehta.com/

    Rgds,
    Andy
     

    Attached Files:

  3. gordonlh

    gordonlh Thread Starter

    Joined:
    Oct 14, 2004
    Messages:
    2
    Ingenuity: there's also no substitute for it, apparently. Thanks Andy, XL Guru. (Does this have anything to do with your Pacman expertise)?
     
  4. XL Guru

    XL Guru

    Joined:
    Aug 30, 2003
    Messages:
    2,702
    gr8 ; while reading your reply, I lost another life. :mad: ( ;) )

    Welcome to the board, enjoy.
     
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/284578