I have the attached file. File is used to generate project timelines. All project information is entered under the projects tab and once entered, user clicks on the Render Timeline Button and then can see the timeline generated under the Timeline tab. Timeline consists of multiple phases that are color coded on timeline.
A couple of issues:
1. I would like it so that borders (black gridlines) are automatically placed around all content (not the entire sheet, just the rows and columns that contain information).
2. Currently, after the first project is entered, a user must enter start and end dates for the planning and scope phase (columns F and G in the project tab). If they do not enter any dates, additional projects will not show up on the timeline. At times, projects may not need this phase (or other phases for that matter) and I would like to see them render on ther timeline if those dates (for planning and scope) were not entered.
3. At times project phases may overlap. Currently, if a phase ends on 9/27/2016 and the next phase begins on 9/25/2016, the original phase end date will not reflect the original phase end date color, but will reflect the new phase color instead. I want to be able to show the original phase color regardless of the overlap.
Thanks for the help.
Bookmarks