Sunday afternoon Genealogy Fun

Sunday Afternoon Genealogy Fun – Your 7 in 1 Generations Chart

Each week on Randy Seaver’s Genea-musings blog he has a post for Saturday night Genealogy fun. Because of the time difference, I have called my series Sunday Afternoon Genealogy Fun. This week’s mission was:

1. DNAsleuth (Ann Raymont) created a 7-in-1 chart showing 7 generations of ancestors on one page several weeks ago – see her blog post at  In her post, there is a link to her Word document if you wish to use it.

2.  Linda Stufflebean’s husband, Dave, took the concept a step further, and created an Excel template of the 7-in-1 chart.  You can download Dave’s file from my Google Drive at  Linda’s chart is in (I opened it to “Editor” so you can download it and work with it).

Here is an image of the blank 7-in-1 chart:

As you can see, the left column is the Generation number, and the other columns are for ancestors of Gen. 1 listed in columns for each grandparent.  So the chart covers Ancestors #1 through 127 in an ahnentafel list or a large pedigree chart.

3.  The challenge tonight is to fill out your 7-in-1 chart and show it to us.  I used the spreadsheet, added the ancestor numbers while adding the names (starting with 1 = me, 2- father, 3= mother, etc.).   I added the names and birth-death years (if known) for the first 7 generations.  Then I colored the boxes by birth place by countries, and saved my chart as an XLS file.  I then saved my chart as a JPG by using the Windows Snipping Tool to create the image. This task took me an hour to complete, so plan ahead!

4.  Show us your 7-in-1 chart in your own blog post, or in a Facebook post.  Please leave a link to your creation in a comment on this post.

Here’s mine:

I downloaded the spreadsheet template and entered all the details.  Since I have only started working on some of my 4x great grandparents as part of my genealogy do-over, I had to refer to my old tree for the dates for these.  Even for the ancestors I don’t have names for, I have colour coded where they are likely to have been born.

I split my chart into 2 images, as it was too hard to read the single image: