Guild of Project Controls: Compendium | Roles | Assessment | Certifications | Membership

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

Excel Timeline - with milestones

No replies
Lee Johnson
User offline. Last seen 1 year 19 weeks ago. Offline
Joined: 14 Jan 2014
Posts: 6
Groups: None

Hi All;

I'm struggling to work this out, what i need to produce in Excel, is a timeline for deliverables, in this case we have designs.

For each deliverable (1 row in excel) i have 4 dates (columns), Baseline Design Issue, Current Design Issue, Baseline Construction Start, Current Construction Start.

What i need excel to do is plot each of these 4 days on a timeline, as 4 milestones, but i have no idea where to start in terms of the formulae needed.

Any help on this would be appreciated. I tried to add a pic of what im after but cant get it working.