Skip to content
Related Articles

Related Articles

Improve Article

How to Create a Timeline or Milestone Chart in Excel?

  • Last Updated : 31 May, 2021

A timeline is a type of chart that visually shows a series of events in chronological order over a linear timescale. The power of a timeline is that it is graphical, which makes it easy to understand critical milestones, such as the progress of a project schedule.

Benefits of using Timeline / Milestone Chart:

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

Steps to Create a Timeline / Milestone Chart

Follow the below steps to create a Timeline or Milestone chart:

Step 1: Prepare your Data.

Data

 In the above table:



  • The first column is for completion dates of the project stages.
  • The second column is for the activity name.
  • The third column is just for the placement of the activities into the timeline (up and down).

Step 2: Select “Date” and “Placement” column and then from: 

insert-> chart-> select 2d chart

The following chart will appear:

Step 3: From the chart element select data labels then select more options.

chart elements->data labels->more options

Step 4: Now in Format data labels deselect the “value” option and select the “value from cells” option.

   

Step 5: Then select the “activity” column and then click on ok.



Step 6: Now select bars and on the format tab on the chart tools select no fill-in shape fills.

No fill bars

Step 7: Now for the Error bars, from the chart element select error bars then select more options.

Step 8: Now in “Format Error Bars”  change everything as per the image shown below:

Step 9: Now remove the vertical axis by unchecking the primary vertical option from

 chart element->axes

 And also deselect gridlines option.

Vertical axis Removed

Step 10: To customize the bars, select Horizontal axis and then in format select shape outline color weight and arrow design.

Step 11: Now select the arrow bars and change their color too. 

Both Horizontal axis and arrow bars in the same color

Step 12: The final step is to change the Chat Title. The following would be the result:

Final Chart

Attention reader! Don’t stop learning now. If you are an Excel beginner (or an intermediate) and want to learn Excel, Geeksforgeeks brings the perfect course for you to start, Diving Into Excel

My Personal Notes arrow_drop_up
Recommended Articles
Page :