How to Make a Family Tree in Microsoft Excel

Microsoft Excel is likely one of the maximum flexible knowledge visualization gear to be had these days. It may be used to create easy-to-understand charts, graphs, and diagrams — together with circle of relatives tree charts. Since Excel is so broadly used, it’s the very best strategy to create your individual circle of relatives tree.

On this article, we’ll provide an explanation for the right way to make a circle of relatives tree in Excel.

Desk of Contents

Methods to Make a Circle of relatives Tree Chart in Excel

There are two clean techniques to make a circle of relatives tree chart in Excel. You’ll use a pre-made circle of relatives tree maker template from Microsoft, or create your individual circle of relatives tree from scratch. There also are dozens of extra unfastened circle of relatives tree templates to be had on-line to fulfill your wishes.

1. Use the Circle of relatives Tree Generator Template

The best way to make a easy circle of relatives tree diagram is via the usage of Microsoft’s integrated circle of relatives tree templates. The most simple of those is the Circle of relatives Tree Generator. To make use of this template:

  1. Open Microsoft Excel and make a selection New within the left-hand menu.
  2. Within the seek bar, sort “Circle of relatives tree.”
  1. Double-click Circle of relatives tree generator, then press Create.
  1. Within the workbook, you’ll see two spreadsheets. The primary is the Circle of relatives Contributors web page, and the second one is the Circle of relatives Tree. Within the Circle of relatives Contributors web page, upload your recognized kin within the corresponding columns for grandparents, first-generation kids, and so forth.
  1. Whenever you’ve added your whole kin, transfer to the Circle of relatives Tree spreadsheet to look the general product.

2. Use a Extra Tough Template

Unfastened PowerPoint Templates supplies a template that permits you to create a six or seven-generation circle of relatives tree, which means you’ll upload great-grandparents or even great-great-grandparents. That is a lot more robust than Microsoft’s template and lets you upload additional info to create an in-depth family tree chart.

To make use of this template:

  1. Head to the Unfastened PowerPoint Templates web site and obtain the template.
  2. Open the downloaded record.
  3. Within the Excel workbook, you’ll see seven pages for each and every member of your circle of relatives. Make a choice any of those so as to add main points together with heart names, start dates, demise dates, circle of relatives relationships, and so forth. You’ll additionally upload circle of relatives pictures for each and every member.
  1. After you collect data and upload it to the prolonged circle of relatives tree, transfer to the Circle of relatives Tree tab to look a visible illustration of your circle of relatives tree.

3. Make a Unfastened-Shape Circle of relatives Tree

If you wish to create your individual free-form circle of relatives tree, it’s somewhat clean. It could now not glance as great because the circle of relatives tree examples proven above, but it surely’ll be enough — particularly in case you simply want a kick off point for some elementary genealogical analysis and also you don’t want added functionalities.

  1. Open Microsoft Excel and create a brand new spreadsheet.
  2. Make a choice the Insert tab within the ribbon menu.
  3. Make a choice Illustrations > SmartArt.
  1. When the window opens, make a selection Hierarchy from the left-hand menu. This may occasionally display you a collection of organizational charts you’ll use. If you wish to upload circle of relatives pictures, make a selection one that permits footage just like the Image Organizational Chart.
  1. Make a choice the SmartArt Design tab to prepare your circle of relatives tree as desired. Press Upload Form > Upload Form After so as to add new shapes for members of the family in a basic pyramid form till your whole circle of relatives is represented.
  1. Along with your circle of relatives tree in position, all you want to do is upload textual content to turn your members of the family’ names. To take action, double-click on a rectangle and get started typing. You’ll upload as a lot additional info as you prefer.
  1. As soon as finished, you’ll modify your tree or beautify it as you prefer.

Percentage Circle of relatives Tales for Unfastened

Don’t put out of your mind, in case you don’t have get admission to to Microsoft Excel, you’ll use the internet model of the app (or Google Sheets) without cost to create an internet circle of relatives tree. That is even more straightforward to percentage along with your circle of relatives and can let you simply visualize and percentage your circle of relatives historical past.