To verify this right click on the timescale and select Timescale, Figure 9. The trick is knowing that the Middle Tier Column, Figure 8, refers to the weeks. It would be helpful to mark each weekly time period with a red line and each day with a dotted orange line. To make the individual task Gantt chart bars easier to extrapolate to the associated task table data set the set the Gantt Rows to display a dotted line on every row, Figure 7. Note that the Status Date, displayed by a blue line, is set to the close of business on Thursday.
The Gantt chart now should look similar to Figure 6. Let’s now set a blue line for the Status Date, Figure 5. We now have marked the start date of the project and the current forecasted finish date. Figure 3ĭo the same for the Project Finish. Let’s begin by displaying a black line on the Project Start date, Figure 3. To access the gridline features right click on the Gantt chart and select Gridlines, Figure 2. Figure 1Īs you can see, gridlines would significantly help to make the Gantt chart easier to read. The project without gridline features is displayed in Figure 1. The schedule itself is not important, except to note that the project was updated through Thursday, March 19 th, 2015, close of business. We start with our demonstration schedule, which is a combination Air Cooled Chiller & Ice Storage System Installation. This article examines some of the numerous gridline features in Microsoft Project 2013 that make the Gantt chart and associated task table easy to read.
Further, if you ever attempted to scale down your schedule to fit it on an 11×17 sheet of paper then you may have wanted to adjust your Gantt chart gridlines. Gridlines become particularly important when you want to inspect tasks on the Gantt chart or when you want to print the schedule so other stakeholders can examine the schedule.
For instance they help you spot the day an activity commences or they help you match up a Gantt chart bar with the corresponding task in the activity table. Gridlines are supposed to make your Gantt chart easier to read. Set appProj = CreateObject("Msproject.Application")ĪppProj.fileopen "\\gbs2040\LocalDatabases$\TechnicalRequests\ExcelChart\GanttDept.mpp", readonly:=TrueĪProg.Resources("A Person"). you have had difficulty reading Microsoft Project’s Gantt chart, either because you had too little or too many gridlines, than you may want to become familiar with the numerous gridline features available to you. I want the exceptions added this way when the project file opens as I won’t be monitoring the holidays, holidays are added to the access database already. So it will get A Person, Start Finish and Name from either a table form or query, Iv tried !!
#MS PROJECT ADD HOLIDAYS CODE#
Im using the code below (Which is working fine) in access to open MS Project "GanttDept.mpp" file, the file has a resource list, Im trying to add non-working days to the resource calendars of the resources IE add holidays.Īs you can see from the code I can add resource exceptions if I hard code it, how can I change this line : aProg.Resources("A Person"). Type:=1, Start:="", Finish:="", Name:="Leave"