Creating a Genealogy Timeline

Hi Everyone,

I hope I'm posting this in the right area. I also hope I can get some help with this.

I've been working on creating a timeline that shows genealogy as well. So far the only thing I can seem to do is gather the info and try to draw this thing out by hand. That's honestly not feasible at all, because this is a HUGE project (Spanning 70 generations and thousands of people).

Excel is the only program that I can seem to find or think of that MIGHT be able to do what I need to do. This is what I need:

I need to have a timeline at the very top (just a line representing the time in years). Then beneath that I need the genealogy part, showing who fathered whom and so forth. Their lives would be represented by lines/bars that are accurate to the timeline as well (showing how long they lived, etc.).

An attempt at an illustration follows:

Please Login or Register  to view this content.

And the vertical lines for each person, stem off the parent, while the horizontal line/shaded bar represents their lifespan . . . all accurate to the top timeline dates. It would also take into consideration multiple children of course, but I'd suppose if I can do one child then two or more shouldn't be much harder.

My main question is . . . is this possible? Please tell me it is, because the only other choice I'd have is doing this by hand, measuring with a ruler, and getting tons of eyesore and headaches!

I'm also new to excel. I've tried to learn enough to figure it out myself but honestly it is way overwhelming to me to figure it out. So I'm hoping some experienced users may know if it's possible, and may show me how it can be done?

Thank you so much, in advance! I appreciate any and all help with this!

I would take a look at using one of special softwares that are specifically designed for genealogy.
Genealogy Software

Thanks for the links

Though sadly I've searched and searched different genealogy programs and seem to hit dead ends thus far in reaching the layout that I'm looking for. Legacy Deluxe 7 has a screenshot (Screenshot) of close to what I'm looking for (except I'm wanting the connections from parents to children to be seen).

GenoPro has a ton of good features, thanks for the link also, oldchippy. I asked if what I'm wanting is possible on their forums too but no reply yet.

One other thing I'm running into with genealogy programs is (of course beside the timeline-layout), the years setting. The timeline needs to go from a starting point of 0, and upward instead of BC and AD, because the years are currently unsure and must be relative to a starting point until I find the BC years.

Thanks SO much for the help, I really appreciate it. Still going through genealogy software I still cannot find one that does what I'm needing. So I'm so hoping that excel can do it!

martin, yeah the orientation is off with the example provided

Andy, that's kinda what I'm thinking, some sort of graphing feature would hopefully do it. But again I'm not knowledgeable at all with excel!

Some really loose example data would be something like:

John was born in the year 1476 and lived 96 years
John had Mark when he was 34 years old
John had Adam when he was 36 years old
Mark had Bob at age 25 and lived to be 80
Adam had no sons, and only lived 40 years
Bob had Paul when he was 23.

And so on and so on. I can manage to calculate the time each one was born and died myself, because a lot of the info relies heavily on other info and can be as odd or random as "this person was born 23 years after this person died." So my main thing is getting the dates represented the way I was showing, both for my sake (it'll help me along having something visual to work with), and also when I need to present the complete thing!

Everything thus far is in text form. Nothing in excel or anything, just a lot of text in One Note 2007.

I really have to put the info into whatever form I would need to, into excel. Basically starting from scratch

Wow, Any! That looks pretty much exactly how I'm wanting it! A little Tweaking and it'd be perfect!

I really REALLY appreciate that, and know you have limited time, so I appreciate it even more!

Is there any quick tutorial or something so I can know how this was done, so that I can edit and use it? Again, I don't know excel so I'm at a loss. Any pointers in the right direction to help me or anything?