From this week's Saturday Night Genealogy Fun from Randy Seaver of Genea-Musings:
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 [Randy's] 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 [Randy] opened it to "Editor" so you can download it and work with it).
As you can see below, 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 [Randy] used the spreadsheet, added the ancestor numbers while adding the names (starting with 1 = me, 2=father, 3= mother, etc.). I [Randy] added the names and birth-death years (if known) for the first 7 generations. Then I [Randy] colored the boxes by birth place by countries, and saved my chart as an XLS file. I [Randy] 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 had already set up my chart using Ann Raymont's Word document and mine is a little bit different than how Randy set his up. (I didn't have enough room to add birth and death years.) This prompt reminded me that I had wanted to set it up with color-coding for birthplaces. This was fun:
By using color coding that is somewhat geographical, I can see how each grandparents' ancestors came from certain regions.
Thank you to Ann Raymont for sharing this form.