{"id":6111,"date":"2021-03-07T22:55:02","date_gmt":"2021-03-07T21:55:02","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=6111"},"modified":"2024-02-06T16:05:02","modified_gmt":"2024-02-06T15:05:02","slug":"project-milestone-chart-using-excel","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/project-milestone-chart-using-excel\/","title":{"rendered":"Project Milestone Chart Using Excel"},"content":{"rendered":"

Project Management<\/strong> is no easy feat! \u00a0There are lots of moving parts, long hours, and constant reporting.<\/p>\n

It requires you to keep everybody on the same page and focused on the goals and timelines.<\/p>\n

One of the key reporting tools needed is the project timeline or milestone chart<\/strong>. \u00a0Luckily you can create a project milestone chart in Excel in just a few steps…well, 11 to be exact!<\/p>\n

\"Project<\/a><\/p>\n

A milestone chart is used to keep track of your project with completion dates for various key checkpoints. It allows you to understand the scheduling of your project and all other information in a single chart!<\/p>\n

Now, without any further delay let’s learn how to create a Milestone Chart in Excel!<\/p>\n

Below is the data source<\/strong> that we are going to use to create our timeline of milestones in Excel:<\/p>\n

\"Project<\/a><\/p>\n

We have Dates<\/strong> and Milestones<\/strong>. \u00a0The Height<\/strong> specifies how high we want the milestone to show up in the chart, whilst the\u00a0Helper Column<\/strong> is used to create the timeline.<\/p>\n

In this example, I show you how easy it is to insert a Milestone Chart <\/strong>Excel.<\/h3>\n

NB:<\/strong> This tutorial was made for Excel 2013 and Excel 2016 versions.<\/em><\/p>\n