I have to create a very large organizational chart with well over 60 divisions/sub-divisions. When I attempt to format it, I can clearly see that there is more than enough room to resize the boxes and move them around to allow for some breathing room and readability. However, I am having trouble adjusting the SmartArt to fit in a page. Is there any way to adjust the size of the boxes to make better use of the available space? Is designing such a chart on Word/Excel even possible or should I consider a different program? I’ve attached the screenshot and file for reference.



Thanks for the help!

Attached Images

image.png (215.9 KB, 33 views)

Attached Files

Org Chart Format.xlsx (108.0 KB, 18 views)

Generally with an org chart of this scale I would recommend using a separate program. Microsoft Visio is a good one and provides some better tools to be able to construct an org chart containing this many elements.

Your other option if you really want to use a program from the Office suite is to possibly use PPT to create your main org chart showing your Main branches and then use hyperlinks to link each "branch" through to a different slide which would have the rest of the hierarchy in more detail. I'm attached a sample file so you can see what i mean (I've only hyperlinked items 1, 2 and 3).

Hope this helps.

Attached Files

Linked Org Chart.pptx (101.8 KB, 29 views)