Excel 2016 Mac: How to Create Timeline for Your Project Including Labels and Sorted by Date

Channel:

Hmran UK (Hmran)

Subscribers:

22,100

Published on July 1, 2017 11:24:02 PM ● Video Link: https://www.youtube.com/watch?v=pyiegAiZGT4

Duration: 13:09

6,378 views

0

This video was recorded on Mac with macOS Sierra. Many are complaining that Excel 2016 does not have many properties as it does in the Windows version, and one of these is the custom label property in Charts. In this video I have demonstrated how to include custom label to charts without the use of VBA, macro, or any third party add ins. As well as, I have explained how to create timeline easily without the need to go through complicated templates and you can do it yourself in just 10 minutes. The timeline created has a feature of sorting data automatically based on the dates. The formulas used in this example are listed below:

Rank
=RANK(A2,$A$2:$A$20,1)+COUNTIF($A$2:$A2,A2)-1

Date
=INDEX($A$2:$A$20,MATCH(I2,$H$2:$H$20,0))

Stage (Apologies I just noticed in the video that the error of labels is shown in the chart. Thus, I fixed the formula for the labels as the following)
=IFERROR(INDEX($B$2:$B$20,MATCH(I2,$H$2:$H$20,0)),"")

Timeline
=INDEX($C$2:$C$20,MATCH(I2,$H$2:$H$20,0))

Hope you enjoy the video :)