Wednesday, November 7, 2012

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    Nov 07, 2012
user doebtown said : (!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:

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:

(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