Family tree Excel/VBA

[Formula11]

Hi, I was wondering if anyone's come across any coding to prepare a family tree.
I have purchased proprietary software but don't think it's flexible enough and think Excel may be the way to go.

 

[severynm]

Give Graphviz a try. Here is an example of a tree you can use to get started. Paste that code into Viz.js to start editing by hand, or if your data is already in Excel, you could potentially use formulas or VBA to create the code for you and paste the generated dot code into that site to generate the image.

 

[MARK858]

Have a look to see if anything @Worf posted is suitable for your needs (Part 5 probably for a family tree)

Organization Chart with VBA – Part 5

The Microsoft smart art engine has some limitations, including lack of support for headless charts and several parents for the same person. The following code overcomes these deficiencies. Here is how to use it: Type the relationship table at...

www.mrexcel.com

Organization Chart with VBA – Part 4

A request came up to accommodate wide boxes. Since it would be complicated to modify the core algorithm, I opted to prepare an interface where the user will be able to adjust the chart to their liking. You will be presented with a basic chart...

www.mrexcel.com

Organization chart with VBA – Part 2

This is a continuation of the article mentioned below; instead of updating, I decided to create another one. Now there is an option to make a top to bottom chart. As before, the source table goes on a sheet named “fshap”. You need to insert two...

www.mrexcel.com

Organization chart with VBA – Part 3

This is a continuation of the project mentioned below. To produce the chart, run the main routine. The information on each box is now presented in two different colors. These colors come from the corresponding cells at the source table. For more...

www.mrexcel.com

Organization chart with VBA

Smart art can create organization charts, but it will have formatting limitations; the code below overcomes that. Prepare a source table containing the following information: Columns A and B – the relationships between two elements. The shape...

www.mrexcel.com

 

[Formula11]

Thanks severynm and MARK858 I'll look into these.
It does get increasingly complicated when you extend family tree into another generation and to account for the tree associated with siblings and relatives as well.

 

[Trevor G]

Do you have access to Microsoft Visio? I used to use this to create a variety of diagrams and you can import Excel and create Organisation charts (Family Tree). An example on YouTube to see how to is shown here:

 

[Formula11]

Thanks Trevor G, I don't have access to Visio though.