Blog post

Monday, July 10, 2017

Visualising Ancestry DNA matches–Index

This series of posts describes how you can use a free Excel template (Windows only, I’m afraid) to draw a network graph of your Ancestry DNA matches.

Published posts

Part 1: Getting ready

  • NodeXL
  • DNAGedcom

Part 2: Loading files the first time

  • Additional input file (‘skip’ close relatives)
  • Load in-common-with
  • Load matches
  • Load additional input
  • Identify groups

Part 3: Navigation and presentation

  • Hiding columns
  • Zooming in
  • Changing layouts
  • Dot sizes and labels
  • Scale the features

Part 4: Updating

  • How new data is treated
  • Clearing duplicates
  • Updating – the process

Part 5: Busy graph diagnosis

Part 6: Busy graph treatments

Part 7: Adding shared administrator lines

Part 8: Adding known ancestors

Part 9: Combining kits

  • Loading more kits into the same graph
  • Using a formula to adjust dot sizes


Planned posts

I am planning to write on the following topics in coming weeks (list may be subject to change)

Part 10: Colour coding

14 comments:

  1. I'm making my way thru this with the help of your excellent posts. looking forward to the simplifying a busy graph.

    ReplyDelete
  2. What a fantastic job you've done Shelley!

    ReplyDelete
  3. Thank you very much for these posts Shelley. I'm looking forward to parts 4-6.

    ReplyDelete
  4. I'm curious: What would be the minimum requirements for a computer doing this project in terms of working memory?

    ReplyDelete
    Replies
    1. Hi Anonymous, I don't know. There may be answers on the developer's page (https://nodexl.codeplex.com/). I certainly see a difference in performance between large and small in-common-with files on my PC.

      Delete
  5. It took me a while to figure this out (I can be slow), but once I did, I found this to be an incredibly helpful tool. Thank you SO much for blogging on this tool!

    ReplyDelete
  6. This is from NodeXL's web page: "A bad experience. Didn't work. My experience is that it doesn't install to Excel2016/64bit & Win10, despite a statement that the installation was successful, It's nowhere to be seen. This was a big disappointment, and checking the logs many users have reported similar problems to mine, without followup. All very frustrating, as the tool very good from what I've read. I've gone to the trouble to create an ID here just to enter yet another review in the hope that the developers get this back on the rails soon. With so many high profile organisations in the mix, my expectations were different. Maybe I just came to try this out at a bad time. Please let me know if things improve.
    by pjmcleod on Aug 4, 2016 at 11:20 PM" I am having the same problem

    ReplyDelete
    Replies
    1. Hi Julie, How frustrating!

      You won't see any difference when you open Excel normally, only when you create a new worksheet using the template. If you open Excel and click File - New then hopefully you will see it as an option in the list of templates.

      If not, do you know how to search your PC? The file you need to find is NodeXLGraph.xltx. On my system it's sitting in Documents/Custom Office Templates. If you find it, double click to create a new worksheet based on the template (don't open it using File Open from Excel or you will be editing the template itself).

      I hope it works for you. If it does, could you please comment here again so that other people will know what steps worked?

      If you can't find it, please message me using the "CONTACT ME" link at the top of my blog as there's one more thing I can think of but I'll need to email you.

      Delete
    2. Hi Shelley, in Win10 NodeXL template can also be accessed from the Start Menu and scrolling through the alphabetical index or by typing NodeXL in the search box adjacent to the Start button.

      Delete
  7. Does this only work with ancestry.com dna test? I've tested at FTDNA & 23andme

    ReplyDelete
    Replies
    1. Hi Sybil, you can do this with any 'in common with' and match list. My FTDNA chart was much more interlinked and complex than my Ancestry one because FTDNA data includes more distant 'in-common-with' relationships. If you try it, enter 'skip' next to the most distant matches to filter them off before you try to create a chart. I haven't yet tested it with 23andMe data.

      Delete
  8. Hello. I have downloaded the files from Ancestry through NodeXL, and I have the matches file and the in-common-with file, and a tree file, but I don't have an additional input file. I don't see how to find it to download it. What should I do? Thank you in advance.

    ReplyDelete
    Replies
    1. Hi Richard, it's not a download file. You make it yourself (see part 2). Alternatively, you can enter 'skip' in the visibility column manually for the appropriate people.

      Delete