+ Reply to Thread
Results 1 to 4 of 4

Project timeline (2 duration period

  1. #1
    Registered User
    Join Date
    05-04-2015
    Location
    Lao
    MS-Off Ver
    2013
    Posts
    42

    Project timeline (2 duration period

    Hi All

    Help pls, am try to create gantt chart for my project time line but now am struck with 1 activity have 2 duration period e.g

    Phase 1 start date 1st Jan 2017 duration 58days so end date will 28 Feb 2017 and other strat date is 30 Aug 2017 duration date is 90 so end date will 30 Nov 2017.

    I should have 2 bar chart for phase 1 but I don't know how to do. so you help much appreciate

    Thanks in advance

    Addiaz

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,863

    Re: Project timeline (2 duration period

    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. If possible include not only a BEFORE sheet but also an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    in other words, include in data your special case, but show us how you prepare gantt for standard data

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
    Best Regards,

    Kaper

  3. #3
    Registered User
    Join Date
    05-04-2015
    Location
    Lao
    MS-Off Ver
    2013
    Posts
    42

    Post Re: Project timeline (2 duration period

    Thank you,

    I don't know wht happened I can't attached file to my post. >_<. I think something wrong with my program.

    Thx

    Addiaz
    Attached Files Attached Files

  4. #4
    Valued Forum Contributor
    Join Date
    10-14-2012
    Location
    Netherlands
    MS-Off Ver
    Excel 2019
    Posts
    353

    Re: Project timeline (2 duration period

    A bit late but I think I fixed it.
    Changed the process of input and calculated cells.
    Added 2 series to the stacked bars (gap + duration2)
    Attached Files Attached Files
    Kind regards,
    Piet Bom

+ 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. Multiple questions about Excel project timeline, % formulas, refresh timeline
    By Please Help in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-27-2016, 07:13 PM
  2. Change Start dates upon duration days change in Project timeline calculation.
    By skyping in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-10-2015, 10:28 AM
  3. Replies: 5
    Last Post: 08-06-2014, 01:10 PM
  4. Replies: 1
    Last Post: 05-02-2014, 03:05 PM
  5. Timeline Slicer custom fiscal period
    By pinebush in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 04-16-2014, 10:57 PM
  6. [SOLVED] Split Time duration in each day for a given period
    By joogibabu in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 04-25-2013, 08:38 AM
  7. Project timeline calculation
    By COGICPENNY in forum Excel General
    Replies: 5
    Last Post: 07-04-2012, 03:33 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