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     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:


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