Genealogy Junkie
www.genealogyjunkie.net
  • HOME
    • Copyright Statement
  • FAMILY HISTORY
    • Names/Places Summary >
      • Ancestor Surnames & Locations
      • List of All Surnames
    • Pedigree Charts
    • Skinny Branches
    • My Brick Walls
  • GENETIC GENEALOGY
    • ADSA Tool: No Spreadsheets Required!
    • Centromeres & Excessive IBS
    • Lines of Interest >
      • Haplogroup Pedigree Chart
      • Griffith Line Y-DNA
      • Corlett-Dumbell-Aspinall-Mason Line mtDNA
      • Grieve-Coulthard-Hetherington-Dixon Line mtDNA
      • X-DNA Inheritance Charts
    • DNA Tips, Tools & Managing Matches
    • Miscellaneous Notes
  • LINKS
    • Regional Links
    • Miscellaneous Links
    • Useful Family Search URLs
  • DOWNLOADS
  • BLOG
    • List of Blog Postings >
      • DNA & Genetic Genealogy Blog Postings
      • Family History Blog Postings
      • Blog Postings: Miscellaneous Topics
    • Subscribe to Blog
  • CONTACT
    • About Me

Ancestral Percentage Pie Charts

8/29/2013

4 Comments

 
All my known ancestors (some back to the 1500's) were from the United Kingdom, so making a pie chart illustrating just this is pretty uninteresting: a single whole pie of 100% UK. Many other people have much more variable and exotic ancestral origins. However, on coming across an Excel spreadsheet with Ancestry Pie Charts created by John Tierny (under a Creative Commons license), I had another idea: to split up my ancestry into countries within the UK where my ancestors originated: England, Wales, Scotland, and the Isle of Man (the Isle of Man is strictly a Dependancy of the UK) – or to subdivide further by county. I originate from 10 counties/areas + one Unknown (see My Brick Walls and last blog posting on Frederick Woolfall and the Diamond Ring "Hush Money"): 18.75% from Lancashire; 12.5% each from Anglesey, Caernarvonshire, Cumberland, and Shropshire; 9.375% from Devon; 6.25% each from the Isle of Man and Unknown (probably Lancashire or somewhere else in the UK); and 3.125% each from Cornwall, Selkirkshire, and Dumfries-shire. But all of these 11 counties with similar-sized "slices" seemed like too much granularity for pie charts, so I opted to use countries within the UK. 
With John Tierny's spreadsheet, you fill in the ancestry of all 16 of your 2nd great-grandparents, and everything forwards is calculated automatically from there. There are columns for up to 10 "regions", and these can be customized (don't miss the note in the Info. on the 1st worksheet for how to unprotect the worksheets, which allows for customization). My pie charts are shown below. I tweaked a few things on the original spreadsheets to have colours and formatting to my liking, and added some drop shadows to the pie charts.
Ancestral Percentage Pie Charts through to 2nd G-GPs
Click for larger version (Source: Modified from Excel spreadsheet available at http://currach.johnjtierney.com/2011/07/ancestry-pie/)
Ancestral Percentage Pie Charts: Me and Parents
Click for larger version (Source: Modified from Excel spreadsheet available at http://currach.johnjtierney.com/2011/07/ancestry-pie/)
These pie charts broken out by UK countries certainly make my ancestral origins appear a little more interesting than each blob being exactly the same colour and just representing the "UK". Before going through this exercise, I'd never actually given much thought to this, even though everything would have been easy to calculate based on the information on my family tree.
Thanks, John, for making your Ancestry Percentage Spreadsheet available.

What's New on GenealogyJunkie.net

  • Nothing significant since my last blog posting, Frederick Woolfall and the Diamond Ring "Hush Money" (20 August 2013)
  • I'm continuing to add to DNA Tips, Tools, & Managing Matches – last updated 27 August 2013. Don't miss the link there for 13 short "lessons" by Kelly Wheaton in her Beginner's Guide to Genetic Genealogy – she wrote this about 3-4 months too late for me to have maximum benefit!
Sitemap / Blogmap     Copyright Statement     Disclosure Statement
4 Comments
Joe
3/19/2016 23:51:42

Does it have anything to do with your genes? Y-chromosome from dad and X from mom if you're male, her X chromosomes come from her grandmothers, possible 4. If you're female 2 X chromosomes from your grannies' 4.

Reply
Sue Griffith link
3/20/2016 17:44:32

Joe: These pie charts aren't anything to do with genes or chromosomes. You just add the geographical location of your 16 2nd great-grandparents and the spreadsheet calculates the ancestral percentages of subsequent generations to you.

Reply
Debbie Logsdon
4/23/2017 09:21:38

So if I am 1% say Irish does that mean one of my parents were 2%?

Reply
Sue Griffith link
4/30/2017 13:21:50

Debbie: The way to input information for these pie charts is to add the ancestral regions for your 2nd great-grandparents and then everything is calculated forwards to you. I'm wondering if your information of being 1% Irish came from an ethnicity estimate from a DNA test? Low percentages such as 1% can't be relied upon at all, so you can't make any assumptions that you are actually 1% Irish.

Reply

Your comment will be posted after it is approved.


Leave a Reply.

    Author

    See About Me
     

    Contact Me

    or via Contact Page

    Subscribe to Blog

     Subscribe to Genealogy Junkie Blog (it's free) in an RSS Feed Reader
    or
    via e-mail:

    Enter your email address:

    Powered by FeedBurner

    Blog Categories

    - List of All Blog Postings
    - DNA & Genetic Genealogy
    - Family History
    - Miscellaneous Topics

    Archives

    August 2019
    December 2016
    November 2016
    August 2016
    June 2016
    September 2015
    April 2015
    February 2015
    December 2014
    August 2014
    June 2014
    May 2014
    April 2014
    March 2014
    February 2014
    January 2014
    December 2013
    November 2013
    August 2013
    July 2013
    June 2013


    Copyright Statement
    Disclosure Policy
Tree

Disclosure Policy
Copyright © 2013-2022 www.genealogyjunkie.net 
Copyright Statement
Tree