donderdag 19 juni 2014

Excel: Milestones Chart

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:

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
Een reactie plaatsen