How To Make A Genogram in Excel

1. How To Make A Genogram in Excel

Genogram charts are now widely used in study-related fields. The medical field uses a genogram as a tool to diagnose gene-borne disease features. They find out the root cause of a disease. The doctors may seek the help of these Genogram charts.

An individual can use MS-Excel to create their genogram. However, the process is a bit complicated. Here are some steps that they can follow if they wish to know how to make a genogram in Excel.

Step 1: Create a new Spreadsheet

The first step to creating a genogram in Excel is to open a new spreadsheet. For that, the user needs to open Microsoft Excel and then click on File from the menu and then select New. They can use several similar options to open a new spreadsheet. They can also select the “Blank Worksheet” option to have a new spreadsheet for the genogram.

Step 2: Use Shapes to Create a Genogram

After opening the new spreadsheet, the user needs to put shapes to create their genogram. There is the Insert option at the top of the menu bar or on the ribbon menu. From there, the user needs to select the shapes they want for their family tree. The square represents the male ancestors of the family, while the circle represents the female members. The user can put multiple circles and squares on the sheet as per the requirement by dragging the shapes on the spreadsheet. The user can also choose the size and color of the shapes they are using.

Step 3: Join the shapes by Lines

The genograms also denote the relationship between individuals and the generations. The user needs to use a line to join the male ancestor with his companion with whom he had children. The user needs to follow this step.

They have to click on the Insert option and go to the shape option and choose the straight lines. In the genogram, the user can create the next generation by drawing a vertical line from the straight line joining the male ancestor and the female ancestor. Then they have to draw another horizontal line that connects the children. Similarly, the user can draw other generations.

Step 4: Put Text Boxes under the shapes

In the case of a genogram, the user can provide some additional details about the person including, their names or other statements in the box. For example, if the user is creating a genogram for medical purposes, they can use the textbox to mention the medical condition; if the person has any notable medical condition. The user can list their date of birth, date of demise, any achievement, medical conditions, and other details in the box, as per their choice. For the text boxes, they can change the font size and the color of the boxes.

Step 5: Save the Genogram

Finally, when the user has finished with the arrangements of the family members, the need to save the genogram. They can click on the File and find the save option to save the content.

2. How to Make A Genogram Easier

Though a user can make a genogram on Excel, the procedure is lengthy. For an inexperienced individual, it can be challenging enough to create a genogram on Excel. The steps here are a bit confusing. The best option is to use EdrawMax Online in this case. The tool is effortless to handle, and anyone can use the tool to make a genogram without any hassle. There are only a few steps that the user needs to follow.

Step 1: Select Genogram Template

The user needs to find the [Science and Education] option in the EdrawMax online application. then select [Genogram] under this classification, as image shows;

Step 2: Customize Your Genogram

Then from the templates present in the genogram option, the user can select one as per their choice. They can edit these templates to add as many family members as they need, and put the required details. Also, you can make a genogram from the start. Click [+], select the shapes and lines from [Symbol Libraries] in the left toolbar, and keep customizing as your preference.

Step 3: Export and Insert

Once you finish your creation, you can save your genogram file in multiple formats, including Graphic, Microsoft Office, PDF, and more. Just export as [Graphic] or [Excel] format, and insert to your Excel file. Or even you can share your file through social media and Email.

3. The Genogram Excel Templates

Sometimes, it is really hard to follow the steps on how to make genogram on word or on EdrawMax Online and create the perfect diagram. At this time, there are genogram examples you can edit immediately, or for more references. The genogram exampels not only help people to understand genogram and its classification deeper, but also assist to draw gengorams without efforts.

Example 1: Family Genogram Template

Here is a genogram about the Brianna Family. A genogram is a pictorial depiction of a family ancestry that exhibits comprehensive statistics on association amid solitary individuals. It is used in a diversity of departments, like medication, mental processes, communal work, genealogy, patrimonial analysis, and education.

Example 2: Clayton Z. Bertin Genogram

Here is a genogram of my family relationship. A genogram is a detailed display of data on relationships among individuals using a family tree graphic representation. You can also define it as a pictorial display of a person’s medical history or a family relationship.

Example 3: Lyon Genogram

This is the genogram of my family. A genogram is a pictorial depiction of a family ancestry that exhibits comprehensive statistics on association amid solitary individuals. It is used in a diversity of departments, like medication, mental processes, communal work, genealogy, patrimonial analysis, and education.

4. Online Genogram Maker

EdrawMax Online genogram maker is the best way when it comes to creating a genogram. It has some unique features which make it a favorite of many users. Several companies also consider it as a trusted diagramming tool for their projects. EdrawMax Online is user-friendly and comes with multiple templates. An individual can choose from the templates and customize them as per their liking to create their genogram. The tool also has a symbol library from where they can pick shapes of their choice. The user can easily create their genogram and save it to share with others.

EdrawMax Online is not just an online genogram maker. Use EdrawMax online to create your gneograms without efforts, just grab a template or choose one genogram template from EdrawMax Template Gallery and keep customization as your preference.

5. Key Takeaways

The genogram is a helpful way to depict the nature of blood relations between individuals present in a family. A user can put specific details about the members in the genogram. The hospitals seek these genograms to have an overview of the medical history of a person. When an individual creates a genogram using Excel, the process is time-taking and lengthy. The person may not get satisfied with the result. Thus, they can stop wondering about how to make a genogram in Excel start using EdrawMax Online.

EdraeMax Online comes with some professional templates. It allows the users can edit them to create their genogram without any difficulty.If you still confused about how to make a genogram in EdrawMax Online, here is an genogram guide to help you create in minutes.