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

  From Randy over at Genea-Musings:

it's Saturday Night - 

time for more Genealogy Fun!!!

Your mission, should you decide to accept it, is to:

(1)  Please see the Genea-Musings post for this challenge to get the template, etc. used.  I'm going to just cut to my result tonight.  

My challenge tonight was to fill out my 7-in-1 Ancestor chart and show it off.  The chart covers ancestors #1 through #127 in an ahnentafel list.  I used the spreadsheet, added the ancestor numbers while adding the names (starting with 1 = me, 2 = my father, 3 = my mother, etc.).  I added the names and birth and death years (if known) for the first 7 generations.  I colored the boxes for the two ancestors who were born in other countries.  As you can see, my families are deeply rooted in the United States.  I saved my chart in Excel, copied it to Paint 3D and then saved it as a JPG image file.  This task has taken more than an hour!  So if you choose to do it, plan ahead!

(2)  Show me your 7-in-1 chart in your own blog post, in a comment to this post, or in a post on Facebook.  

Here's mine:

My columns are wider than the ones you'll view from Genea-Musings because, like Randy, I added their birth and death years.  This helps me a lot since several of my ancestors share the same name.  

There is other color coding I would like to do, such as by states, military service, blanks that need to be filled in, etc.  I'm open to other ideas for coloring coding!

Thank you to Ann Raymont (DNAsleuth) for the original idea of doing this; Linda and Dave Shufflebean (Empty Branches on the Family Tree) (Also, thank you Linda for always commenting on my Saturday Night Genealogy Fun posts.  I love the feedback!) for creating and sharing the spreadsheet version of the chart, and of course Randy Seaver for sharing this idea.  I think I am going to suggest to my mother, BFF, cousins, etc. to refer back to this chart when I am going on and on about an ancestor - it may help to keep them all straight!