However, DNA matches are better. Have you had any matches maybe from the London/Essex area etc that might be useful?
I wish. Unfortunately the numbers are overwhelming just to browse the matches - 9,433 maternal matches and another 2890 not yet assigned to a specific parent! However only a couple of hundred matches are given when you ask for geographical info (see attached map). There were very few matches in London and none plausible even when expanding the radius. Though it may be that using the US-based Ancestry.com for the DNA test has caused a bias of matches from the US - several hundred compared to only 50 in total from the UK. I've also searched for matches with relevant surnames - Graham, Campbell, and Harris - and not found significant numbers or plausibly identifiable links different from any other surname.
There were only 3 matches in London - one was clearly Scottish (all Scots surnames) and one was a paternal relative (and Irish surnames) and the third had a private tree so no clues there.
If the Ancestry service had an API where I could programmatically access the trees of all the DNA matches I might be able to do some statistical analysis of the family names and perhaps identify some significant geographical cluster, but basically all they tell you is the six most common surnames (and who isn't related to some Smiths somewhere...) and everything else you have to work out, by manually browsing the trees of your 10,000 relatives, or at least the ones that are public. It's all rather hit or miss.
I really appreciate the help you and your fellow group members have given - I really didn't expect that people would actually go research on our behalf when I posted - I had just hoped that someone might have recognised some aspect of my story - so I'm amazed and grateful for your help, but also it's frustrating that despite finding out lots of new info on my grandfather, I'm no closer to knowing why he was given the surname Graham and hence why I was too! That was one of the main things I was hoping to discover from this exercise. You know I had always worn the Graham tartan and thought it was my clan so it came as a bit of a surprise to say the least that I had no connection to the Grahams at all!
G