I am trying to show my task start and finish dates in weeks and I want it to calculate the weeks from the start of the project. Right now all I can get it to do is calculate from week 1 to week 52 of each year (example W51/5). The bar chart shows months and weeks from the start of the project, so my gantt chart says my task starts W51/5 and my bar chart shows my task starting in week 77. Any ideas on how to get the gantt chart and bar chart to calculate weeks the same way?? Preferably to have the gantt chart calculate the same as the bar chart.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Date Formats for Task Start and Finish Dates
- Thread starter heidierin
- Start date
P2003 answer (but I'm still curious about what you are calling a "bar chart" -- please let me know).
Step 1 -- calculate the weeks.
1. Insert the column "text1"
2. RightMousebutton on the column header and click on "Customize Fields"
3. Click on Rename and give the column the name "PDQBach"
4. Click on the button labelled "Formula..."
5. Paste the next line into the formula field:
ProjDateDiff(Start,Finish)/2400 & "wks"
2400 is the number of minutes in an hour (60) times the number of hours in a work day (8) times the number of days in a work week (5). Modify as appropriate to your case.
6. Click on OK to exit from the Formula entry.
7. Click on OK to exit from the Customize Fields.
Step 2 -- display it in the Gantt chart
1. Click on Format | Bar styles ...
2. Determine the bar type you want to modify (Task is probably the one you want). Click on it.
3. Click on the tab "Text" below.
4. Choose (left, right, top, bottom, inside) where you want the information to appear.
5. Click on the field and you'll get a drop down. Look for "PDQBach" and click on it.
6. Click on OK.
Step 1 -- calculate the weeks.
1. Insert the column "text1"
2. RightMousebutton on the column header and click on "Customize Fields"
3. Click on Rename and give the column the name "PDQBach"
4. Click on the button labelled "Formula..."
5. Paste the next line into the formula field:
ProjDateDiff(Start,Finish)/2400 & "wks"
2400 is the number of minutes in an hour (60) times the number of hours in a work day (8) times the number of days in a work week (5). Modify as appropriate to your case.
6. Click on OK to exit from the Formula entry.
7. Click on OK to exit from the Customize Fields.
Step 2 -- display it in the Gantt chart
1. Click on Format | Bar styles ...
2. Determine the bar type you want to modify (Task is probably the one you want). Click on it.
3. Click on the tab "Text" below.
4. Choose (left, right, top, bottom, inside) where you want the information to appear.
5. Click on the field and you'll get a drop down. Look for "PDQBach" and click on it.
6. Click on OK.
- Thread starter
- #4
1. I am using MSProject 2000.
2. By bar chart I was referring to the bar-graph portion of the Gantt Chart. It is my gantt table and gantt bar chart which are showing two different starting weeks. The table shows task starting W51/5 and the bar chart shows the task in Week 77.
Thanks for your tip. I will try it to see if it works.
2. By bar chart I was referring to the bar-graph portion of the Gantt Chart. It is my gantt table and gantt bar chart which are showing two different starting weeks. The table shows task starting W51/5 and the bar chart shows the task in Week 77.
Thanks for your tip. I will try it to see if it works.
- Status
Similar threads
