Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Project Timeline with multiple events

  1. #1
    Board Regular PivotMeThis's Avatar
    Join Date
    Jun 2002
    Location
    Iowa - USA
    Posts
    341
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Project Timeline with multiple events

    Upper management has requested a complicated timeline (to me) and I'm not sure where to start.

    The timeline will contain multiple projects. Each project will contain multiple events. Each event will have a scheduled start and finish date as well as an actual start and finish date. Some date fields will be blank. If one of the event finish dates is surpassed before the event is completed the "indicator" should change color - say from green to red. This line could be broken up into segments for each event.

    A project could be behind schedule at one point but then get back on schedule during the next event. The list of projects could be very long and the number of events could be extensive. Which events will be used has not yet been deterimined.

    Here is a small example. I have looked at several timelines but I have not seen anything that has multiple events. This single project would be shown on one line of the chart and there could be several lines of projects. I hope that makes sense. The Field AF date was intentionally left blank.

    SS = Scheduled Start Date
    AS = Actual Start Date
    SF = Scheduled Finish Date
    AF = Actual Finish Date

    Project ROW SS ROW AS ROW SF ROW AF DSN SS DSN AS DSN SF DSN AF Field SS Field AS Field SF Field AF
    STP-123 1/1/10 1/1/10 1/1/12 1/10/12 1/1/11 1/1/11 1/1/13 2/15/13 5/20/13 6/15/13 10/15/15

    Is it possible to create such a chart? It reminds me of a gantt chart but all on one line and kind of overlapped...
    Rhonda
    Using Excel 2016

  2. #2
    New Member scorp007's Avatar
    Join Date
    Sep 2014
    Location
    USA
    Posts
    9
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Project Timeline with multiple events

    I think I'm asking something similar, here: http://www.mrexcel.com/forum/excel-q...-schedule.html

    Multiple projects - 1 per row. with multiple events per row, based on date?

    Just thought I would let you know in case I get a reply.

  3. #3
    New Member scorp007's Avatar
    Join Date
    Sep 2014
    Location
    USA
    Posts
    9
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Project Timeline with multiple events

    found this. Hope it helps:

    How to Make a Gantt Chart for Repeated Tasks | Katherine S. Rowell

    produces this, and she provides the excel sheet in the example:


  4. #4
    Board Regular PivotMeThis's Avatar
    Join Date
    Jun 2002
    Location
    Iowa - USA
    Posts
    341
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Project Timeline with multiple events

    I will look into this, thanks for the tip!
    Rhonda
    Rhonda
    Using Excel 2016

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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