Calling all Genea-Musings Fans:
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 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:
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.
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.
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 firstname.lastname@example.org.