Get instant access to this free e-book fully loaded with Useful Excel Tips, 80+ Keyboard Shortcuts, and VBA Codes.
It’s as important as the execution of the each step. In fact, tracking makes execution easy.
And, a milestone chart is a perfect way to track a project in a simple way.
The basic idea in milestone chart is to track each step of your project on a timeline and present it in a simple way. It will help you to track completion date of each stage of your project.
But in excel, we don’t have a milestone chart by default, but you can create it by using some simple steps.
So today, I will show you how to create a milestone chart in excel to track your projects. In this post, I have mentioned each and every step in detail for you.
But 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 parts 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, the next step is to insert a line chart with markers.
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, you have a chart which looks like a timeline. But you 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.
Perfect, you made it. Your milestone chart is ready to rock.
As I said, milestone chart is simple, effective, and easy to create. And, if you are an emerging project manager then it’s must for you to give it a try.
You can track your project scheduling in a simple way. The best thing which I like about milestone chart, it’s to understand by others.
I hope you found it useful.
And, if you like it, tell me what’s the best part about it that you like. Share your views with me in the comment box.
Try this Gantt Chart Template.