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 https://dnasleuth.wordpress.com/2020/09/01/7-gen-1-sheet/.  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   https://drive.google.com/file/d/1s7rTacxacWVCWxUEWq5pAArJCv8mCZWT/view?usp=sharing.  Linda’s chart is in https://emptybranchesonthefamilytree.com/2020/09/using-excel-to-display-7-family-generations-on-1-sheet/ (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: