+ Reply to Thread
Results 1 to 3 of 3

Project Timeline with Dynamic Date Range Based on User Input

  1. #1
    Registered User
    Join Date
    10-24-2012
    Location
    NC, US
    MS-Off Ver
    Excel 2010
    Posts
    3

    Project Timeline with Dynamic Date Range Based on User Input

    Hello, I am looking for help in creating a spreadsheet that will display the subject mentioned. I need a chart that displays project deliverables as labels along a year long date range. I want to be able to change the date range to any period of time by entering a start date and an end date and having the chart automatically update to that date range and display the project deliverables due during that range. Does anyone know of a way to accomplish this? I have used the following links and have been able to accomplish each of them individually, but have not been able to combine the labels of the project timeline link with the dynamic date range described in the second link.

    http://chandoo.org/wp/2009/07/09/pro...comment-278501

    http://pubs.logicalexpressions.com/p...cle.asp?ID=246

    Can anyone help me achieve the spreadsheet I described using the two ideas presented in the link? Thanks!
    Last edited by Rollinstone12; 10-28-2012 at 10:08 AM.

  2. #2
    Forum Expert
    Join Date
    09-20-2011
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    2,278

    Re: Project Timeline with Dynamic Date Range Based on User Input

    Hello
    Take a look at the attached example file. Is this the kind of chart you're trying to create based on the chandoo.org example?

    Hope this helps.
    DBY
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    10-24-2012
    Location
    NC, US
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Project Timeline with Dynamic Date Range Based on User Input

    Hello
    Take a look at the attached example file. Is this the kind of chart you're trying to create based on the chandoo.org example?

    Hope this helps.
    DBY
    Hello DBY,
    That is close to what I was looking for. I actually need it to be able to be broken down by a daily basis, and not just monthly. I believe I have solved my own problem though using the two sites. Attached below is my solution, if anyone has a use for it.
    ChangeLabelFix.xlsx

+ 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