Results 1 to 12 of 12

Thread: Timeline (2000)

  1. #1
    3 Star Lounger
    Join Date
    Sep 2001
    Location
    Stuck at work..., Missouri, USA
    Posts
    248
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Timeline (2000)

    I'm looking to make a timeline that shows a list of people and then time they will be a program. The program runs for 12 months and they enter based on birthday.

    What I would need is something like the attached.

    Can I do this using a chart or something other than by hand?

    Also, participants can enter mid-month, so I'd like that indicated, if possible.

    Morgan
    <font face="Comic Sans MS">Morgan Erickson</font face=comic>
    morgan.erickson@sprint.com
    <img src=/S/flags/USA.gif border=0 alt=USA width=30 height=18>-From <img src=/S/flags/Colorado.gif border=0 alt=Colorado width=30 height=18> but living in <img src=/S/flags/Missouri.gif border=0 alt=Missouri width=30 height=18>...and working in Kansas.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Timeline (2000)

    It could be done in a chart.

    It could also be done using (for example) Data | Validation in worksheet cells, but it would probably be more work, and you'd need two cells per month if you want to allow participants to enter mid-month.

    Could you provide a bit more detail? E.g. do the participants enter on any birthday, or only on their 37th birthday, etc.?

  3. #3
    3 Star Lounger
    Join Date
    Sep 2001
    Location
    Stuck at work..., Missouri, USA
    Posts
    248
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Timeline (2000)

    They will enter on their 11th birthday.

    All I have is their name & their birthday to make the chart from.
    <font face="Comic Sans MS">Morgan Erickson</font face=comic>
    morgan.erickson@sprint.com
    <img src=/S/flags/USA.gif border=0 alt=USA width=30 height=18>-From <img src=/S/flags/Colorado.gif border=0 alt=Colorado width=30 height=18> but living in <img src=/S/flags/Missouri.gif border=0 alt=Missouri width=30 height=18>...and working in Kansas.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Timeline (2000)

    And when exactly would you like them to join? On the 1st or 15th nearest to their 11th birthday, or the 1st or 15th after their 11th birthday, or ...?

  5. #5
    3 Star Lounger
    Join Date
    Sep 2001
    Location
    Stuck at work..., Missouri, USA
    Posts
    248
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Timeline (2000)

    Technically, they join ON their 11th birthday, but for the sake of this, it would be easiest to do the 1st or 15th after their birthday.
    <font face="Comic Sans MS">Morgan Erickson</font face=comic>
    morgan.erickson@sprint.com
    <img src=/S/flags/USA.gif border=0 alt=USA width=30 height=18>-From <img src=/S/flags/Colorado.gif border=0 alt=Colorado width=30 height=18> but living in <img src=/S/flags/Missouri.gif border=0 alt=Missouri width=30 height=18>...and working in Kansas.

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Timeline (2000)

    See if the attached chart does what you want. It is a stacked bar chart with the join date as first series and the duration (1 year) as second series. The first series has been made transparent, so only the duration is colored.

  7. #7
    New Lounger
    Join Date
    Dec 2003
    Location
    Clinton Twp., Michigan, USA
    Posts
    12
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Timeline (2000)

    Thanks Hans but that is not what I need. I have attached a sample for your review. Appreciate the help.

  8. #8
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Timeline (2000)

    Do you want a stacked column?
    Right click and select chart type and select column - stacked column

    Then change the color of the series. You will also have to change the series order (dbl-click on one of them, chose series order tab) to put them in the order you want.

    Steve

  9. #9
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Timeline (2000)

    But this has absolutely nothing to do with your original question... <img src=/S/confused.gif border=0 alt=confused width=15 height=20>

  10. #10
    New Lounger
    Join Date
    Dec 2003
    Location
    Clinton Twp., Michigan, USA
    Posts
    12
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Timeline (2000)

    Sorry for the confusion. I thought a graphical description might help. I want the graph to a range in minutes on the X axis and specific times on the Y axis. The data to be graphed is the duration.

  11. #11
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Timeline (2000)

    I thought your reply was about the original question (sometimes Loungers use two different names, for example one at work and another at home). I now see that it was in fact a completely new question. Steve has already indicated what you should do; the attached workbook is the result. I have created a stacked column chart and a stacked percentage column chart.

  12. #12
    3 Star Lounger
    Join Date
    Sep 2001
    Location
    Stuck at work..., Missouri, USA
    Posts
    248
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Timeline (2000)

    Thanks, Hans. This worked perfectly for me.

    Looks like this thread has gone a bit off-course from my original question, but you sure helped me out of a jam.

    Thanks again!
    <font face="Comic Sans MS">Morgan Erickson</font face=comic>
    morgan.erickson@sprint.com
    <img src=/S/flags/USA.gif border=0 alt=USA width=30 height=18>-From <img src=/S/flags/Colorado.gif border=0 alt=Colorado width=30 height=18> but living in <img src=/S/flags/Missouri.gif border=0 alt=Missouri width=30 height=18>...and working in Kansas.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •