Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-27-2016, 09:49 AM
Please Help Please Help is offline Multiple questions about Excel project timeline, % formulas, refresh timeline Windows 7 64bit Multiple questions about Excel project timeline, % formulas, refresh timeline Office 2013
Novice
Multiple questions about Excel project timeline, % formulas, refresh timeline
 
Join Date: Jul 2016
Posts: 1
Please Help is on a distinguished road
Default 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
Attached Images
File Type: jpg Project Timeline Project.jpg (286.6 KB, 9 views)
Attached Files
File Type: xlsx Project Timeline 2.xlsx (32.5 KB, 7 views)
Reply With Quote
Reply

Tags
dynamic content, percentage, timeline

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Multiple questions about Excel project timeline, % formulas, refresh timeline 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
Multiple questions about Excel project timeline, % formulas, refresh timeline 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

Other Forums: Access Forums

All times are GMT -7. The time now is 12:37 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft