In the projects I have worked so far, Milestone Charts (also known as timeline charts) are often one of the most discussed parts. A commitment to delivering is as important as the project itself. A milestone chart is an effective tool to depict project scope and timelines. In this post, I will show you a simple technique to quickly generate a Milestone chart in Excel. Something as shown below:

Steps to Create Milestone Chart in Excel

That’s it!! Your Milestone Chart is ready. Garnish it and serve it hot 🙂 Try it Yourself.. Download the file from here

Creating a Gantt Chart in Excel. Creating a Histogram in Excel. Excel Timesheet Calculator Template. How to Make a Pareto Chart in Excel. Employee Leave Tracker Template. Free Excel Templates Download. Creating a Bell Curve in Excel. Creating a Combination Chart in Excel. Creating an Area Chart in Excel. Advanced Excel Charts Examples.

  1. Add the additional data to your table. 2. Click on one of the long thin lines on the graph which points to the ‘Activity’. 3. You should see that on the table, the data is highlighted in little coloured boxes. Simply drag this down to incorporate the additional data. Click anywhere on the sheet besides the table or graph when the new data has been highlighted to deselect them. 4. Right click the chart and choose: ‘Select Data…’ 5. Select ‘Date’ in the left column (Legend Entries) 6. Select ‘Edit’ in the right column (Horizontal Axis Labels) and select all dates, including the new dates. 7. Select ‘Activity’ in the left column and repeat step 6, ensuring all activities are highlighted, including the new activities. 8. Press OK to exit the Data Selection window. That should be it! Just adjust the new labels to be in the correct position and you should be good to go. Lew