+ Reply to Thread
Results 1 to 4 of 4

Formula to display Gantt Chart

  1. #1
    Registered User
    Join Date
    06-21-2010
    Location
    Toronto, Ontario, Canada
    MS-Off Ver
    Excel 2010
    Posts
    47

    Formula to display Gantt Chart

    I am trying to build a calendar whihc functions similarly to a Gantt Chart. In the attached examply, I have a line which has a Start Date, and End Date and a duration. The chart to the right captures when the activities occur. I have created a formula which captures the Start Date in the chart, but not sure how to be able to cature the Start, End and Duration in the chart. In this example, the Start Date is July 7th and the End Date is July 30t. The chart wich shows the week of July 2nd is populated, but I need the follow weeks up to July 30th needs to be populated.

    Thank you for your help

    Stephen

    Attachment 151321

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    52,108

    Re: Formula to display Gantt Chart

    do you have the chart created yet? because in the file you uploaded, i cant find any charts?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    06-21-2010
    Location
    Toronto, Ontario, Canada
    MS-Off Ver
    Excel 2010
    Posts
    47

    Re: Formula to display Gantt Chart

    I only included 2 lines......

    I think I figired it out......someone in the office gave me some suggestions as well.

    Thank you for replying!!

    Stephen

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    52,108

    Re: Formula to display Gantt Chart

    ok great, if you have your answer, please mark this as solved

+ 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