How to Create an Organization Chart From Excel

Every company has an organization chart that depicts who the employees are and what their position is in the firm. Organization charts help internal and external stakeholders understand the hierarchy in the company and who they need to contact. It is fairly simple to create an organization chart in Microsoft Excel 2007 with the SmartArt feature. You can easily type each person's name and a box with the hierarchy relationship is instantly drawn. Using Microsoft Excel to create an organization chart will save you time and make it appear professionally done.

Difficulty: Moderately Easy

Instructions

Things You'll Need:

• Microsoft Excel 2007

1. Open a new document in Microsoft Excel 2007 and click on the "Insert" tab.

2. Click on "SmartArt". In the "Choose a SmartArt Graphic" window, click on "Hierarchy".

3. Select the first chart, which is the Organization Chart. Click OK.

4. Begin typing the name of the first person at the highest level in the organization such as the CEO in the "Type your text here" window. Click on the indented text areas to add names for the rest of the employees. You can add additional boxes by pressing Enter in the "Type your text here" window at the desired position.

References

• Microsoft Excel 2007 Tips