Microsoft Excel是当今最通用的数据可视化工具之一。它可用于创建易于理解的图表、图形和图表 - 包括家谱图。由于Excel的使用如此广泛，它是创建您自己的家谱的完美方式。
在本文中，我们将解释如何在Excel(Excel)中制作家谱。
如何在Excel中制作(Excel)家谱图(Family Tree Chart)
在Excel(Excel)中制作家谱图有两种简单的方法。您可以使用Microsoft(Microsoft)提供的预制家谱制作模板，或从头开始创建您自己的家谱。网上还有数十个额外的免费家谱模板可以满足您的需求。
1.使用家谱生成器模板(Family Tree Generator Template)
制作简单家谱图的最简单方法是使用 Microsoft 的内置家谱模板。其中最简单的是家谱生成器(Family Tree Generator)。要使用此模板：
- 打开Microsoft Excel并在左侧菜单中
选择新建。(New)
- 在搜索栏中输入“家谱”。
- 双击“家谱(Family)生成器”，然后按“创建”(Create)。
- 在工作簿中，您将看到两个电子表格。第一个是家庭成员(Family Members)页面，第二个是家庭树(Family Tree)。在“家庭成员”(Family Members)页面中，在祖父母、第一代子女等相应栏中添加您已知的亲属。
- 添加所有亲戚后，切换到家谱(Family Tree)电子表格以查看最终产品。
2.使用更强大的模板
免费的PowerPoint 模板(PowerPoint Templates)提供了一个模板，可让您创建六代或七代家谱，这意味着您可以添加曾祖父母甚至曾曾祖父母。这比 Microsoft 的模板功能强大得多，允许您添加其他信息来创建深入的家谱图表。
要使用此模板：
- 前往免费 PowerPoint 模板网站(Free PowerPoint Templates website)并下载模板。
- 打开下载的文件。
- 在Excel 工作簿(Excel workbook)中，您将看到每个家庭成员的七页。选择(Select)其中任意一项以添加详细信息，包括中间名、出生日期、死亡日期、家庭关系等。您还可以为每个成员添加家庭照片。
- 收集信息并将其添加到扩展家谱后，切换到“家谱”(Family Tree)选项卡以查看家谱的直观表示。
3.制作自由形式的家谱
如果您想创建自己的自由形式家谱，这相当容易。它可能看起来不如上面显示的家谱示例那么好，但它已经足够了 - 特别是如果您只需要一些基本家谱研究的起点并且不需要添加功能。
- 打开Microsoft Excel并创建一个新的电子表格。
- 选择功能区菜单中的
“插入”选项卡。(Insert)
- 选择“插图”>“SmartArt”。
- 窗口打开后，从左侧菜单中选择层次结构。(Hierarchy)这将向您显示一组可以使用的组织结构图。如果您想添加家庭照片，请选择一张允许使用图片（例如“图片组织结构图”）(Picture Organizational Chart)的照片。
- 选择“SmartArt 设计”(SmartArt Design)选项卡以根据需要组织家谱。Press Add Shape > Add Shape之后添加形状”可为一般金字塔形状的家庭成员添加新形状，直到代表整个家庭。
- 建立好家谱后，您所需要做的就是添加文本来显示家庭成员的姓名。为此，请双击矩形并开始键入。您可以添加任意数量的附加信息。
- 完成后，您可以根据自己的喜好调整树或装饰它。
免费分享家庭故事
不要忘记，如果您无法访问Microsoft Excel，您可以免费使用该应用程序的网络版本（或Google Sheets）来创建在线家谱。这更容易与您的家人分享，并将帮助您轻松可视化和分享您的家族史。
How to Make a Family Tree in Microsoft Excel
Microsoft Excel is one of thе most versatіlе data visualization tools avaіlablе today. It cаn be used to create easy-to-understand charts, graphs, and diаgrams — including family tree charts. Since Excel is so widely used, it’s the perfect way to create your own family tree.
In this article, we’ll explain how to make a family tree in Excel.
How to Make a Family Tree Chart in Excel
There are two easy ways to make a family tree chart in Excel. You can use a pre-made family tree maker template from Microsoft, or create your own family tree from scratch. There are also dozens of additional free family tree templates available online to meet your needs.
1. Use the Family Tree Generator Template
The easiest way to make a simple family tree diagram is by using Microsoft’s built-in family tree templates. The simplest of these is the Family Tree Generator. To use this template:
- Open Microsoft Excel and select New in the left-hand menu.
- In the search bar, type “Family tree.”
- Double-click Family tree generator, then press Create.
- In the workbook, you’ll see two spreadsheets. The first is the Family Members page, and the second is the Family Tree. In the Family Members page, add your known relatives in the corresponding columns for grandparents, first-generation children, and so on.
- Once you’ve added all of your relatives, switch to the Family Tree spreadsheet to see the final product.
2. Use a More Powerful Template
Free PowerPoint Templates provides a template that lets you create a six or seven-generation family tree, meaning you can add great-grandparents and even great-great-grandparents. This is much more powerful than Microsoft’s template and allows you to add additional information to create an in-depth genealogy chart.
To use this template:
- Head to the Free PowerPoint Templates website and download the template.
- Open the downloaded file.
- In the Excel workbook, you’ll see seven pages for each member of your family. Select any of these to add details including middle names, birth dates, death dates, family relationships, and so on. You can also add family photos for each member.
- After you gather information and add it to the extended family tree, switch to the Family Tree tab to see a visual representation of your family tree.
3. Make a Free-Form Family Tree
If you want to create your own free-form family tree, it’s fairly easy. It might not look as nice as the family tree examples shown above, but it’ll be sufficient — especially if you just need a starting point for some basic genealogical research and you don’t need added functionalities.
- Open Microsoft Excel and create a new spreadsheet.
- Select the Insert tab in the ribbon menu.
- Select Illustrations > SmartArt.
- When the window opens, select Hierarchy from the left-hand menu. This will show you a set of organizational charts you can use. If you want to add family photos, select one that allows pictures like the Picture Organizational Chart.
- Select the SmartArt Design tab to organize your family tree as desired. Press Add Shape > Add Shape After to add new shapes for family members in a general pyramid shape until your entire family is represented.
- With your family tree in place, all you need to do is add text to show your family members’ names. To do so, double-click on a rectangle and start typing. You can add as much additional information as you like.
- Once completed, you can adjust your tree or decorate it as you like.
Share Family Stories for Free
Don’t forget, if you don’t have access to Microsoft Excel, you can use the web version of the app (or Google Sheets) for free to create an online family tree. This is even easier to share with your family and will help you easily visualize and share your family history.
