yogi_Simulate A TimeLine Chart From A Table Of Dates and Events In A Spreadsheet

                                           Google Spreadsheet   Post  #860
              Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Nov 07, 2012
user doebtown said : (http://productforums.google.com/forum/?zx=xdgf04nj8c5p#!mydiscussions/docs/lhpYB3vx0Cs)
Create a simple timeline
Column A has dates. Column B has events that are associated with those dates.

All I want to do is place points along a line that represent the dates with labels for the events that took place on those dates. Obviously, though, I want the dates to be relative to each other.

Can this be done?

---

Here's a copy of the data I want to chart:

https://docs.google.com/spreadsheet/ccc?key=0AjsoIob8dJfodHo4ZklxcjZJamxwVDNhclVnZVhNaUE

I just want the timeline to be a vertical line with the points along the line in their relative positions. (The point here is to try to show the court the temporal relationship between the events: certain events must be related to other events because they all happened at the same time.)

Does that make sense?

---

 Here's a mock up of what this timeline would look like in an ideal world:

https://docs.google.com/drawings/d/1NyoTmr-dztAIGoxLHuXRL-8yUkPqazUd1EG-XCc5eEc/edit

(Obviously, I've only roughed in a few of the points and their relative position has not been calculated with precision.)

Note that it looking exactly like this is NOT essential. My hope is that using a spreadsheet will help precisely plot the points along the line, which is far more important than the exact mechanics of the visuals.

-------------------------------------------------------------------------

in the following I had a little play to create a simulated TimeLine Event Chart