Downloaden a milestones template from the Microsoft Office website:
http://office.microsoft.com/en-001/templates/timeline-with-milestones-TC102930035.aspx
To my opinion it needed some improvement. This is what I created:
Compared to their version:
I used the same data as they did for their example, with the last column changed and one added:
http://office.microsoft.com/en-001/templates/timeline-with-milestones-TC102930035.aspx
To my opinion it needed some improvement. This is what I created:
Compared to their version:
I used the same data as they did for their example, with the last column changed and one added:
| DATE | MILESTONE | POSITION | BASELINE BELOW | BASELINE ABOVE |
| 23-jan | Project Start | 25 | 0 | #N/B |
| 14-feb | Milestone 1 | 10 | 0 | #N/B |
| 24-feb | Milestone 2 | -10 | #N/B | 0 |
| 1-mrt | Milestone 3 | 15 | 0 | #N/B |
| 15-mrt | Milestone 4 | -15 | #N/B | 0 |
| 15-mei | Milestone 5 | 15 | 0 | #N/B |
| 15-jun | Milestone 6 | -15 | #N/B | 0 |
| 30-jun | Milestone 7 | 15 | 0 | #N/B |
| 15-jul | Milestone 8 | -20 | #N/B | 0 |
| 30-jul | Milestone 9 | 20 | 0 | #N/B |
| 23-okt | Milestone 10 | -15 | #N/B | 0 |
| 31-dec | Project End | 15 | 0 | #N/B |
Instead of their error bars I simply used columns. All the rest is not too hard to find out.
You can download the file ExcelMilesonesChart.xlsx through
https://drive.google.com/folderview?id=0B7HgkOwFZtdZVmhRQUZFM28yc1U&usp=sharing
You can download the file ExcelMilesonesChart.xlsx through
https://drive.google.com/folderview?id=0B7HgkOwFZtdZVmhRQUZFM28yc1U&usp=sharing
Reacties