![]() ![]() The great news about it is that since it is a built-in template, you can always open another one and review how things are so you can put something back if you broke it. ![]() Therefore, the solid orange indicates completion for the duration of the project that exceeds the plan. Solid purple indicates project completion, but you wouldn't want to overwrite the orange sections where you've exceeded your planned schedule. Orange is used to indicate that actual schedule if it differs from the planned schedule. On the default template purple is used to indicate the planned schedule. % Complete (beyond plan) is just a different formatting to indicate completion when the project duration exceeds the planned duration. It would help with planning to see how this project impacts Project 2 that was supposed to start on 6-May, but cannot because Project 1 is not yet finished. If you've changed the whole thing over to dates and you scheduled Project 1 to start on 1-May and last 5 days, but in reality it started on 3-May and lasted 6 days, you can show all of that on the chart. Of course to make this truly useful, you would need the dates of the chart to adjust automatically with each passing day.Īctual start is used to show when the work actually began. Current File(s):, Sample 5-Year Project Management Gantt Chart The preceding document link is an Excel version. While this would be great if you were making a presentation for sometime in the future, I find this would be more valuable if it always highlighted today's date. Is there a way I can set a color code for each team then code the horizontal bars to. I have three teams that have pieces of the project. Im actually using it more for visual representation, not so much for project tracking. Period highlight just allows a certain Period (or Date) on the chart to be highlighted. I am using the Gantt Project Planner template in Excel 2013. Period Highlighting to reflect a named range (I created) covering the dates (formerly periods) formatting of the Periods, Plan Start and Actual Start to be dates I have to say I was fairly impressed that all of this was done with conditional formatting. I've found it to be fairly editable in the 5-10 minutes I've spent playing with it. ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |