|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Multiple questions about Excel project timeline, % formulas, refresh timeline
Hello, I am working on an Excel project that lists the timeline for certain tasks. I have most of the design created but need help with the advanced formulas that will make it dynamic and work correctly. I would greatly appreciate it and thank you for your time in helping me. I will list my questions below: 1. At the top of my worksheet there is a place where I can enter the start date and end date of a project. Once I enter those dates, how do I get my bar chart to re-adjust to those specific dates? The start of the chart needs to be the "Start Date" and the end of the chart needs to be the "End Date". I can manually adjust this time frame by going into the "Format Axis" options and entering the minimum and maximum bounds but I can't figure out how do this automatically or with a macro/VB button. 2. Currently the data filling the chart is based on the "Start", "End" and "Days" columns. Is there a way to dynamically allocate the "days" column based on a percentage? Maybe the "Start" date could be entered in the column and instead of an "End" column, it could be a column listing the percentage of time that is based on the project final End Date listed at the top of the spreadsheet? 3. Is there a way to add more features in the list, under the "Task Name" column and have the chart and "Days" column dynamically change based on a percentage of the End Date listed at the top of the spreadsheet? So if the Start Date was today (July 27, 2016) and the End Date was August 27, 2016, there would be 31 days in the project. If I add a feature, is there a way to get all the other features days to auto adjust based on the time frame? I may need to add another column in the information table called "% of project" or something then assign a certain percentage to each task, would that work or is there an easier way? I will attach my spreadsheet so you can see and work with what I have. I'll also attach a screenshot in case you would rather just look at the project. Thank you for all your help and for taking the time to read this post -Eric |
Tags |
dynamic content, percentage, timeline |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Excel 2013 Project Timeline - colour coding data labels | MicrosoftNovice2015 | Excel | 1 | 09-15-2015 02:16 PM |
Linking Excel Data t oa Visio Timeline | Glen3den | Visio | 0 | 06-18-2015 06:11 AM |
Project Timeline? | DavidHarris | Project | 3 | 05-24-2014 12:03 PM |
MS Project 2010 timeline pan and zoom bar missing | cossie2k | Project | 1 | 05-22-2013 06:40 AM |
[Office]How to create project timeline similar to this? | Coderedpl | Project | 0 | 09-11-2009 01:23 PM |