How to Create a Milestone Chart in Excel

 


Tracking all the steps of a project is an important task.

You know this, right?

It’s as important as the execution of each step. In fact, tracking makes execution easy.

In Excel, one of the simplest yet power charts which you can use to track your projects is a MILESTONE CHART.

They also call it “Timeline Chart”.

It’s one of the favorite project management tools of Experts.

It visually shows a timeline where you can specify key milestones, deliverable, and other checkpoints.

how to create a milestone chart in excel

According to Wikipedia: Milestones are tools used in project management to mark specific points along a project timeline.

The basic idea in a milestone chart is to track each step of your project on a timeline with its completion date and present it in a simple way.

And today…

In this post…

I would like to share with you a simple 3 steps process to create a milestone chart in Excel.

...so let's get started.

Benefits of Using a Milestone Chart

Before we get into it, let me tell you some core benefits of using a milestone chart.

  • It’s easy to check the progress of the project with a milestone chart.
  • Easy for the user to understand the project scheduling.
  • You have all the important information in a single chart.

Steps to Create a Milestone Chart in Excel

I have split the entire process into three steps to make it easy for you to understand.

#1. Set Up Data

data to create a milestone chart in excel

In this data table, we have three columns.

  1. The first column is for completion dates of the project stages. And, make sure the format of this column should be text format.
  2. The second column is for activity name.
  3. The third column is just for placement of the activities into the timeline (up and down).

#2. Insert a Chart

Now here's the game starts.

Creating a milestone chart is a bit lengthy process but it’s worth for this amazing chart. 

...here are the steps.

  • Select any of the cells from the data.
  • Go to Insert Tab ➜ Charts ➜ Line With Markers.
insert a line chart with markers to create a milestone chart in excel
  • We’ll get a chart like this. But, this is not what we want, we have to re-create it.
raw chart to create a milestone chart in excel
  • So now, right click on the chart and then go to “Select Data”.
select data to create a milestone chart in excel
  • In select data window, just remove series from legend entries.
remove series to create a milestone chart in excel
  • Now, our chart is totally blank. So, we have to re-assign series and axis labels.
  • Click on “Add” from legend entries.
click add to create a milestone chart in excel
  • In edit series window, enter “Date” in the series name and select activity column for the series values.
select series to create a milestone chart in excel
  • After that, click on edit in “Horizontal Axis Labels” and refer to the date column and click OK.
edit axis label to create a milestone chart in excel steps
  • Next, we have to insert an another series. Click on “Add” in legend entries and name it “Placement” and refer series values to placement column.
add new series to create a milestone chart in excel