+ Reply to Thread
Results 1 to 8 of 8

Gantt chart showing Start and Finish Date

  1. #1
    Registered User
    Join Date
    02-20-2014
    Location
    North Carolina
    MS-Off Ver
    Excel 2010
    Posts
    4

    Gantt chart showing Start and Finish Date

    Hi there!
    My first ever question here as i am a new guy here, and have very limited excel experience. I was asked to build a gantt chart in excel that will show the start of an activity, add the duration to that date, and show the finish date at the end of the bar. A coworker was trying to help me with this, but could not figure out how to show the end date at the end of the visual bar on the chart. I have attached what i have. Is there a tutorial somewhere that will show me how to do this. I searched for quite awhile and didn't see any posts that i thought met my requirements.
    Any help would be greatly appreciated.
    Thank you
    Scottie Bell

    Capture.PNG

  2. #2
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.84 (24041420))
    Posts
    8,751

    Re: Gantt chart showing Start and Finish Date

    would you attach a sample spreadsheet rather than an image please
    Wayne
    if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here

    If you have a solution to your thread - Please mark your thread solved do the following: >
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  3. #3
    Registered User
    Join Date
    02-20-2014
    Location
    North Carolina
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Gantt chart showing Start and Finish Date

    As his spreadsheet did not show the finish dates, he deleted it after sending me the capture of the original. I have attached a sample of the info i have for the gantt chart.
    Attached Files Attached Files

  4. #4
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.84 (24041420))
    Posts
    8,751

    Re: Gantt chart showing Start and Finish Date

    this using conditional formatting to produce the gantt chart

    =AND(F$1>=$B2,F$1<=$E2)

    see attached
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    02-20-2014
    Location
    North Carolina
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Gantt chart showing Start and Finish Date

    This is great, and looks like something that would be very useful to me in the future. Maybe it isn't a gannt chart that i need, as this isn't what i'm looking for. I need a chart using the info that i have, that shows the start date shown on the bar chart to the left of the bar, the bar, and the finish date shown on the bar chart to the right of the bar. The sample picture of my co-workers chart is what i am trying to accomplish but i also need it to show the finish date on the right side of the bar. Being so new to this, i'm not sure if i am explaining this correctly, i apologize for being so unclear.

    Capture.PNG

  6. #6
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.84 (24041420))
    Posts
    8,751

    Re: Gantt chart showing Start and Finish Date

    sorry, i'm dont know how to get that chart in excel
    The sample picture of my co-workers chart is what i am trying to accomplish
    can your co-worker explain how its been setup at all ?

  7. #7
    Registered User
    Join Date
    02-20-2014
    Location
    North Carolina
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Gantt chart showing Start and Finish Date

    He retrieved the file when he got back to the office and sent it to me. This is the original chart he had created with the info i sent to you. I don't know how to even begin disecting these things to try and figure out how to do what i want.
    Attached Files Attached Files

  8. #8
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.84 (24041420))
    Posts
    8,751

    Re: Gantt chart showing Start and Finish Date

    sorry, not sure how to recreate that chart

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Make date ranges for graph (choose start and finish date)
    By zeko90 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-23-2013, 09:13 AM
  2. Timeline (Gantt) chart showing both hour and date
    By S K ROY in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 11-30-2011, 06:33 PM
  3. Replies: 2
    Last Post: 04-01-2010, 07:31 PM
  4. Start and Finish Date
    By Hippychic in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 02-02-2007, 11:36 AM
  5. [SOLVED] How do I chart date ranges with varying start and finish dates?
    By projectplanner in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 05-01-2005, 07:06 PM

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