If you’re using Excel 2007 or earlier, you may not see these options. You can either search online for unofficial templates, or skip to the sections below for other options.
To add cells for your siblings, copy-paste “your” cell onto another cell in the same column to turn it the same green color. Similarly, you can copy-paste your parents’ cells into the same column to make lighter green cells for your aunts and uncles.
Click anywhere in the document to make the Text Pane appear. This lets you edit the family tree through a simple, compact list. To add another relative, press the + button at the top of the pane. With the new cell selected, use the → or ← buttons to move it between generations. Click and drag to move it below the name of its son or daughter. Above the document itself, the SmartArt ribbon menu has many visual options. For example, click the Hierarchy icon to see a selection of ways to display the data.
In Excel 2007, instead select the Insert tab, then find SmartArt in the Illustrations group. [4] X Research source
Alternatively, use the Text Pane that appears when you select the diagram. Any change you make in the text pane will instantly affect the diagram’s appearance.
