Excel Has A Family Tree Generator - It's A Bit Odd!
HTML-код
- Опубликовано: 16 сен 2024
- Excel's family tree generator template works. But the layout of the generated tree is a little odd.
Watch me walk through generating a tree and then applying some changes to make it better.
COMPANION ARTICLE
www.datamining...
HOW TO CREATE A 4-GENERATION FAMILY TREE (article has video link)
www.datamining...
HOW TO CREATE A 5-GENERATION FAMILY TREE
www.datamining...
HOW TO CREATE A 6-GENERATION FAMILY TREE
www.datamining...
HOW TO CREATE A 7-GENERATION FAMILY TREE
www.datamining...
OUR DONE-FOR-YOU BUNDLE OF TEMPLATES
dataminingdna....
Not what I was looking for but quite informative and well presented.
Thanks for reviewing and explaining how to use this template.
I created a 4 generation family tree in the same way as the example.
You pointed out a few short comings and here are a few more with my solutions.
Full names and years wont fit in the boxes. I changed the spreadsheet settings to "Show row and column headings". Now I can change the row height until the text fits and also set Word Wrap. Yes its a nuisance but if you have to run "Create Family Tree" you have to make the changes all over again. With some names this might chop up them up, then you might have to change the relevant column width.
I would not reduce the font size as it makes printed versions harder to read as the tree gets wider.
I had to change the tree page to Landscape each time I ran "Create Family Tree".
Perhaps some VB proficient person would make the code changes to remove these chores (i.e. unless there is Microsoft embargo). Or record your own macro to make the changes.
I don't like the drop-down connectors for people who are married or partnered, I would prefer a horizontal connector.
I would compliment the template creator as it is quite a reasonable piece of work.
Hope this is helpful.
Than you for your helpful tips there!
Great explanation thanks. Have you found a family tree template that allows you to enter birthdate and location per family member? TIA
How i want to get this template.. In my excel dont have it
Is there non pedigree one?
Looking for a template that have multiple person included. all if not most of your uncles/aunties, grandparents siblings too.
That automatically Arranges the layout.
You're looking for a vertical layout, which is only really suitable for a few generations in a spreadsheet.
The excel templates works fine for what I use it for - so quick and easy. However, I keep getting errors on it and requires de-bugging - I have no idea how to do this? Any tips? "Runtime error 1004"
I also encountered errors with the generator. I think the problem is that the code is old. Unless Microsoft update it, there's nothing really that can be done.
Good video, instead of changing font size just wrap the text in the cell....no?
Yes you can @Tanko3691 or alternatively press + between first name and family name
My family have 16 generation. Can I use it?
No, this only works for 4 generations.
However, we have a tutorial for those who want to create larger trees in Excel - here's the link:
ruclips.net/video/lMQ5k09i9Wo/видео.html
The last family tree only supports one child per couple?
Is it possible to add one more generation?
No, unfortunately not with the Microsoft template. Check out my channel for videos where I show how to prepare your own template for different numbers of generations.
Looks like a pain. Lol.