Tracking all the steps of a project is an important task.
It’s as important as the execution of each step.
In fact, tracking makes execution easy.
The basic idea in milestone chart in Excel is to track each step of your project on a timeline with its completion date and present it in a simple way.
In Excel, there no default option to create a milestone chart but we can create it by using a line chart + small customization.
So today in this post, I’d like to share with you a 3 step process to create a milestone chart in Excel. All these steps are in detail and easy to follow.
...so let's get started.
Before we get into it, let me tell you some core benefits of using a milestone chart.
I have split the entire process into three steps to make it easy for you to understand.
In this data table, we have three columns.
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.
At this point, we have a chart which looks like a timeline. But we need a small touch of formatting to make it a perfect milestone chart.
A small touch of formatting.
Just follow these simple steps.
Now, the last and important thing you have to do, add the activity name for each step.
Download this sample file from here to learn more.
As I said, milestone chart is easy to understand for the end user and you can track your project scheduling in a simple way.
It looks a bit tricky when you are making it for the first time but, if you are an emerging project manager then it’s must for you to give it a try.
I hope you found this step by step method helpful but now tell me one thing.
Have you ever tried this chart before?
Share your views in the comment section, I'd love to hear from you and please don’t forget to share it with your friends.