How to Build Hierarchy in Excel. A hierarchy shows relationships between objects, ... To add a box, click the closest box in the diagram to where you want to place a new box.