Project milestones can be shown in a simple time line chart in excel. In this installment and the part 5 and 6 of this series, we will learn some excel based visualizations / charts that can help you to communicate about the project status and progress to your team and stake holders. While there is little that project management software can do when it comes to first point, the second point can be addressed by using right tools and visualizations.

The communication and collaboration is really good.

They had exceptional individuals who are also exceptional team players.

There are 2 key elements in all the successful projects I have been part of. Part 3: Project Status Reporting – Create a Timeline to display milestonesīonus Post: Using Burn Down Charts to Understand Project Progress Why Create Project Timeline Chart? Team To Do Lists – Project Tracking Tools Preparing & tracking a project plan using Gantt Charts

If the height is -ve the event shows below the X-axis.This is the third installment of project management using excel series. If the height is +ve the event shows above the X-axis.

You can set any height values you want, but it’s a good idea to stick to small numbers near to zero. Height – The height value is important because it determines how high or low the event is displayed in the timeline chart.A task that lasts 10 days and is 50% complete will have completion of 5 days (= 10 days x 50%). Completion (days) – This is the duration of the event x %Complete.You will need to apply your own rules to assess the Phase % complete. Phase % complete is an estimate and not calculated with reference to task completion. 0% means the task has not started, and 100% means the task is fully complete.

% Complete – Shows the % complete for each task and phase.Duration (days) – This is the duration of the event measured in days.Event name – This is the name of the event that shows up in the chart data series labels.Start Date – This is the event’s start date.The rows labelled “Today” are used in step (9) “The Today Line” when we add a vertical line to show where we are today. This shows the type of event, whether it is a project phase or a task. This show which phase of the project the event falls under. Phase – Phase 1, Phase 2, Phase 3, Phase 4 or “Today”.

Ms project timeline bar height