Showing posts with label #genealogy charts. Show all posts
Showing posts with label #genealogy charts. Show all posts

Friday, March 25, 2016

WHERE WERE THEY BORN? 5 generation color spreadsheet showing birthplaces


Thanks to J. Paul Hawthorne for creating this idea that went viral in the genealogy world the past two days.  While I’m a day behind others, I still wanted to share this great idea with all of you.

The idea is to create a spreadsheet chart showing birth places for our ancestors.  It’s been a lot of fun to see everyone’s colorful charts and see all the various locations.

Here’s the link for the Five Generation template to create your own chart.  AND, thanks to Pat Richley-Erickson (Dear Myrtle) we also have a Six Generation template to play with.

Here they are.  Both my birthplace chart and my husband’s.

You can clearly see the Michigan theme in mine, as well as Scotland and Ireland.  Those red blanks are the brick walls.

Excel birthplace chart 5 GENERATION - MY FAMILY-WITH LABELS

Here is my husband’s chart.  New York and Pennsylvania stand out.  But even more startling when you see it in living color is all the red on his mother’s side.  I’ve worked and worked on locating those families, but have had no luck thus far.

Excel birthplace chart 5 GENERATION - RON'S FAMILY-WITH LABELS

Thanks again to J. Paul Hawthorne for this wonderful exercise. 

Happy hunting,
Michigan Girl

Copyright ©  2010-2016   Diane Gould Hall
ALL RIGHTS RESERVED.  NO USE WITHOUT PERMISSION