Saturday, September 26, 2020

Saturday Night Genealogy Fun - Your "7 Generations in 1" Chart

 Calling all Genea-Musings Fans:

 It's Saturday Night again - 

Time for some more Genealogy Fun!!

Here is your assignment if you choose to play along (cue the Mission Impossible music, please!):

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:

My columns are wider than Ann's and Linda's because I added birth-death years which really help me remember my ancestors.  I could put the color code on the bottom of the table too.

What other color coding could we do?  I want to do color coding by States/Provinces, by Death location, by Marriage Location, by Occupation, by Military Service, etc.

What other Color Coding can you think of?

Thank you to Ann Raymont for the chart concept and the Word file master, and to Linda and Dave for providing the Excel file master.


Copyright (c) 2020, Randall J. Seaver

Please comment on this post on the website by clicking the URL above and then the "Comments" link at the bottom of each post.  Share it on Twitter, Facebook, or Pinterest using the icons below.  Or contact me by email at


Unknown said...

I have had such a spreadsheet for a long time suggested by another great genea-blogger. I color coded my ancestors by line like in my FTM2019. So I don't get upset when I see the quantity of "holes" I have for my "green ancestors" those from Italy on my paternal grand-mother's side. I also color coded the dates that are only estimates to give me an incentive to look into that further. Annick H.

Liz said...

Randy, I love this! It was a lot of work, but it's going to be so worth it! I think I'm going to print it out and keep by my computer so I can work on filling in those blanks!

Here's mine:

Thanks for the idea!


Lois Willis said...

Here's mine:

Janice M. Sellers said...

I think I would like my chart better if the bottom half of it weren't so full of unknowns.

Marcia Crawford Philbrick said...

I used this chart to analyze Ancestry ThruLines for the 4 DNA kits I manage on Ancestry.

I also used it to analyze the sourcing I have for death facts. I was particularly looking at whether I had a Find a Grave citation and an obituary.

Linda Stufflebean said...

Here is Dave's chart, since I posted mine last Thursday. His was much more work to color code since his ancestors didn't seem to stay in one place for very long. They were born everywhere!

Lisa S. Gorrell said...

I got a late start on this, but here it is.

Elizabeth Handler said...

This was fun and an interesting way to see birthplaces. Mine is at

Tess said...

This was fun and helped me answer a question I had:

Steve K said...

An interesting and embarrassing task. Learned and redirected some of my upcoming work.

I have spent the last year on working on identifying many cousins in DNA matches, which while interesting and helpful, doesn't add much in growing the tree (up and down) directly as much as working the Family Bush.