Hi,Gingee245
Welcome to the Microsoft Community, and we'll be happy to help you.
We understand that you are experiencing problems with Excel and apologize for any inconvenience this issue may cause you.
In Excel, the charting tools may not directly support the creation of complex family tree relationship charts with more than three generations. This is because Excel's charting capabilities are designed primarily to display a limited number of relatively simple data relationships. For easy creation of more branches, you may want to look for a three-party application, but please be careful to keep your personal information secure.
Your ideas and suggestions are vital to improving Microsoft products, but this forum is primarily a technical forum and the Microsoft development team will not be concerned with it.
If you have any ideas or suggestions about Microsoft Office applications you can post them on the specialized feedback platform Ideas · Community (microsoft.com) (this is an English platform), where specialized developers will follow and comment on your feedback. After sending your feedback, you can share the feedback link in this forum, so that other users with similar problems, including me, can vote for your feedback, and the more votes you get, the more likely you are to get attention from the development team.
Also you can add shapes manually in Excel, but with more data it can be tricky, use the Tab key to add branches: in the chart editor, select a family member shape in the chart. Then, press the Tab key and Excel will add a new branch shape next to that shape to represent the relationship between family members.
I wish you good health and all the best
Zoro-MSFT | Microsoft Community Support Specialist
