Create Classic Timeline

[wiredwrx]

Hello All,

I have a worksheet with approximately 100 rows, in 3 columns.

Column A is a date
Column B is a description
Column C is a name

I want to create a "Classic" timeline, with the dates on the line, and the description appearing above and below the line, with lines from the descriptions to the line. Basically, I want the information to appear like a timeline should.

I found a tutorial, but it requires me to enter the "description"s manually, each and every one, and also, since the dates span 3 years, it did not list each individual date, just several dates spaced months apart.

I DO NOT CARE HOW WIDE THE TIMELINE IS, I just need it to include all the information.

If anyone can help, I would really appreciate it.

Thanks in advance,
Michael

 

[MickG]

Hi, I know nothing about "time lines", but here's a start
http://www.teach-nology.com/
Mick

 

[Jon Peltier]

The following is a page that shows one way to make a timeline which seems to mach the requested description:

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

 

[wiredwrx]

The following is a page that shows one way to make a timeline which seems to mach the requested description:

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

That is the tutorial I found. The problem is it requires the manually adding each "description" for the point on the timeline. I have a 100 "descriptions" It is too time consuming.

Thank for the help though.

Michael

 

[Jon Peltier]

I've seen one example which took labels from the worksheet. Maybe you can use one of these label utilities to get the labels into the chart:

Rob Bovey's Chart Labeler, http://appspro.com
John Walkenbach's Chart Tools, http://j-walk.com