Learn how to create a treemap chart in Excel. Skip to primary navigation; ... The reason why this chart is called a treemap is that it represents hierarchical data in a tree-like structure.

A three-generational tree is focused, as it helps you highlight the most impactful relationships and is easy to follow.

Create a new workbook in Excel, and then type the column headings for your bill of materials. The headings should reflect all attributes of a part that are relevant to the completed project.

How to create an Excel table. 1. First, enter the field names in the columns across the top, and then enter some records/data in the rows under each column.