Excel Productivity Guide
Useful Excel Tips | Keyboard Shortcuts | VBA Codes
Download this Free E-Book to take your excel skills to a whole next level using some smart Excel tactics.
Worth $20, Absolutely Free
Tracking all the steps of a project is an important task. It’s as important as the execution of the each step. In fact, tracking makes execution easy.
And, if you are searching for a perfect chart template in which you can track your project in the simplest way, Milestone Chart should be your first choice.
The basic idea in milestone chart is to track each step of your project on a timeline with its completion date and present it in a simple way.
According to Wikipedia:
Milestones are tools used in project management to mark specific points along a project timeline.
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.
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.
You can easily set up your data for this chart.
Make sure to arrange your data like below data table. To follow along you can download this data table from here.
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. So, 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 simple 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.
And, I hope you found this step by step method helpful.
Now tell me one thing. Have you ever tried this chart before? And how much it can help you in your project tracking? Share your views in the comment section, I would love to hear from you.
And, please don’t forget to share it with your friends.