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