✦Template Printable Ideas Insights

"Mastering Excel: Create a Family Tree Chart"

By

Want to preserve your family history but struggling with how to create a family tree chart in Excel? You're not alone. While it might seem daunting at first, creating a family tree in Excel is a straightforward process that allows you to visualize your family's lineage while keeping the data organized and accessible. Let's dive into the step-by-step guide to help you understand how to build a family tree chart in Excel.

Before we begin, ensure you have Excel installed on your computer. We'll be using features from Excel 2010 onwards in this guide, but the basic principles apply to older versions as well. Now, let's start gathering information about your family members and begin crafting your family tree.

Gathering and Organizing Data

Before you start creating the chart, it's essential to gather and organize data about your family members. Information can include names, birthdates, marriage dates, and spouses' names. Having this data ready will make the creation process more manageable. For this example, let's assume you have a simple dataset like this:

How to Create a Family Tree Chart in Excel, Word, Numbers, Pages, PDF - Tutorial
How to Create a Family Tree Chart in Excel, Word, Numbers, Pages, PDF - Tutorial
How to Make a FAMILY TREE in EXCEL (Using Free Templates or from Scratch)
How to Make a FAMILY TREE in EXCEL (Using Free Templates or from Scratch)
How To Make a Family Tree in Microsoft Excel (Plus Tips) Family Tree Templates, Family Tree Spreadsheet Template, How To Make A Family Tree On Powerpoint, Family Tree Spreadsheet, How To Make A Family Tree On Computer, Genealogy Excel Template, Family Tree Template Google Sheets, Family Tree Excel, How To Create Tree Diagrams In Excel
How To Make a Family Tree in Microsoft Excel (Plus Tips) Family Tree Templates, Family Tree Spreadsheet Template, How To Make A Family Tree On Powerpoint, Family Tree Spreadsheet, How To Make A Family Tree On Computer, Genealogy Excel Template, Family Tree Template Google Sheets, Family Tree Excel, How To Create Tree Diagrams In Excel
Name Birthdate Marriage Date Spouse's Name
Grandma 1920-01-01 1940-06-15 Grandpa
Parent 1 1945-02-15 1970-07-03 Parent 2
Sibling 1 1972-05-10
Sibling 2 1975-12-20

Set up your data like this, ensuring each person has a row, and the information is organized in columns.

Arranging Data for a Family Tree

For a family tree, you'll want to organize the data in a specific way. Start with the oldest generations at the top and work your way down and to the sides. In our example, 'Grandma' and 'Grandpa' are at the top. Below them, their children 'Parent 1' and 'Parent 2' are listed, and finally, their grandchildren 'Sibling 1' and 'Sibling 2' at the bottom.

How to Make a FAMILY TREE in EXCEL (Using Free Templates or from Scratch)
How to Make a FAMILY TREE in EXCEL (Using Free Templates or from Scratch)
How to Make a Family Tree in Excel | Edrawmax Online
How to Make a Family Tree in Excel | Edrawmax Online
HOW TO MAKE A FAMILY TREE IN EXCEL ANY EDITION EASY
HOW TO MAKE A FAMILY TREE IN EXCEL ANY EDITION EASY

Now that you have your data organized, it's time to create the family tree chart in Excel.

Creating the Family Tree Chart

Excel offers various chart types, but for a family tree, a hierarchy chart works best. Here's how to create one:

  1. Select your data (including the header row) and click on the Insert tab in the Excel ribbon.
  2. In the Illustrations group, click on Organization Chart and then choose Hierarchy.
  3. Excel will place an initial chart based on your data. To format it as a family tree, click on the Design tab in the new Organization Chart group that appears.
  4. Under Audience, choose Both to display both the name and title (or, in our case, the spouse's name) of each family member.
  5. customize the layout and design by manipulating the Layout and Shape options as desired.

The hierarchy chart should now display your family tree, with the oldest generations at the top and working downwards and outwards.

Create and Print a Family Tree Online - Free
Create and Print a Family Tree Online - Free
How to Make a Family Tree in Microsoft Excel
How to Make a Family Tree in Microsoft Excel
Discover Your Family Story for Free 🌳
Discover Your Family Story for Free 🌳
41 Free Family Tree Templates (Word, Excel, PDF, PowerPoint)
41 Free Family Tree Templates (Word, Excel, PDF, PowerPoint)
a screenshot of a computer screen showing the user's name and date selection
a screenshot of a computer screen showing the user's name and date selection
Free Generation Family Tree Template For Google Docs
Free Generation Family Tree Template For Google Docs

Adding More Details to Your Family Tree

Once you have the basic family tree chart set up, you can add more details and customize it to fit your needs. Here are some ideas to make your family tree more engaging and informative:

Adding Photos

Add photos of your family members to personalize the chart. Right-click on a shape (family member) in the chart and select Add Shape > Picture to insert an image. Position and resize the picture as needed.

spacing and colors to make the chart visually appealing, click on the Shape Styles option under the Design tab, and choose a style that suits your theme. You can also adjust the Line and Fill colors to match your preferences.

3 Ways to Make a Family Tree on Excel - wikiHow
3 Ways to Make a Family Tree on Excel - wikiHow
Free Family Tree Maker with Templates
Free Family Tree Maker with Templates
Family Tree Maker With Photos - Automatic Excel Template
Family Tree Maker With Photos - Automatic Excel Template

Creating a Different Layout

If you prefer a different layout for your family tree, try creating a different type of chart, such as a tree map or an org chart with branches. You can also use non-chart tools like SmartArt to create family tree diagrams.

Family trees are a fantastic way to explore your heritage and preserve your family history. Creating a family tree chart in Excel is accessible and helps you present the information in an engaging and organized manner. By following this step-by-step guide, you'll have a beautiful family tree that you can share with your loved ones. Don't stop at just creating the chart – update it regularly to keep it current and relevant, and consider sharing it with other family members to gather more information and stories.

Embrace the journey of discovery that comes with creating your family tree. Who knows what fascinating stories and connections you'll uncover along the way? Happy exploring!