How to Create a BOM Using MS Excel. Tree diagrams use graphics to indicate the materials comprising a project or product and the relationships between those materials.

To make a tree diagram in Excel you will need to utilize third-party diagramming tools, such as Lucidchart that allows you to create a tree diagram in Excel. These are known as add-ins to the program.