Excel Timeline Chart

Found a solution to draw timeline chart by using XY scatter.

Idea from :-

http://www.vertex42.com/ExcelArticles/create-a-timeline.html

Extend the time line to be able to dynamically pan and zoom.

Can try the attachment.