Please_Help_Me
New Member
- Joined
- Jul 27, 2016
- Messages
- 1
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?
It doesn't look like I'm able to attach my spreadsheet or a picture of it to this thread due to permissions. If there is any way I can post these, i'll do it. It would be hard to understand what I'm talking about without seeing the project.
Thank you for all your help and for taking the time to read this post
-Eric
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?
It doesn't look like I'm able to attach my spreadsheet or a picture of it to this thread due to permissions. If there is any way I can post these, i'll do it. It would be hard to understand what I'm talking about without seeing the project.
Thank you for all your help and for taking the time to read this post
-Eric