+ Reply to Thread
Results 1 to 2 of 2

Configure a Gantt Chart in excel to have dependent dates

  1. #1
    Registered User
    Join Date
    03-19-2012
    Location
    Vancouver, Canada
    MS-Off Ver
    Excel 2010
    Posts
    1

    Configure a Gantt Chart in excel to have dependent dates

    Hello,

    I'm trying to create a Gant chart on excel as a marketing tool for customers so I can input the 6 tasks they go through with my process and they can see visually how long it takes.

    All the things I've seen for Gant Charts make you set the "start date" for each task but I want to only set the start date for the "task 1" and then the start dates of the following tasks would be dependent on the duration of the task before it. Therefore, if task one is schedule to take 60 days, then the start of task 2 would automatically be set as 60 days after task 1.

    Therefore, all I have to plug in is: project start date, duration for each tasks (about 6) and everything else would then be determined automatically.

  2. #2
    Valued Forum Contributor
    Join Date
    03-14-2012
    Location
    Arizona USA
    MS-Off Ver
    Excel 2000/2007
    Posts
    408

    Re: Configure a Gantt Chart in excel to have dependent dates

    This should help.
    http://www.me.ua.edu/me489/Gantt-Excel.pdf

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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