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:
- It’s easy to check the progress of the project with a milestone chart.
- Easy for the user to understand the project schedule.
- 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 Similar Reads
How to Create a Thermometer Chart in Excel? The Thermometer chart in Excel can be used to depict specific data based on the actual value and the target value. It can be used in a wide range of scenarios such as representing the past performance of horses in horse racing or the global temperature and it's variation throughout decades etc. In t
2 min read
How to Create a Step Chart in Excel A step chart is used to represent data that changes irregularly between time intervals. Now, Excel doesn't have a feature to create a Step Chart like the one shown below but we can create one by making some changes in our data. What is a Step Chart in ExcelA Step chart is the same as a Line Chart. T
4 min read
How to Create a Rolling Chart in Excel? A chart range is a data range that automatically updates as the data source is changed. This dynamic range is then utilized in a graphic as the source data. As the data changes, the dynamic range updates instantaneously, causing the chart to refresh. A common necessity when developing reports in Exc
3 min read
How To Create Interactive Charts in Excel? In MS Excel, we can draw various charts, but among them today, we will see the interactive chart. By name, we can analyze that the chart, which is made up of interactive features, is known as an interactive chart. In general, this chart makes the representation in a better and more user-friendly way
9 min read
How to Create Slicers and Timelines in Excel? Slicers and Timelines in Excel are used to implement with the Excel tables and Pivot Tables to help in filtering out large amounts of data to get the high level of information from a collection of data. Finding Slicer and Timeline in Excel Navigate to the Insert menu ribbon, Select the Filters secti
3 min read