Add an organization chart - Excel - Microsoft Office Online

	Try Excel 2007 Buy the 2007 release
Highlights

	Present your data in a bar chart
Chart of the month

	Check for free updates
Office downloads

Product Information

Help and How-to

Training

Templates

Related Products and Technologies

Support and Feedback

Technical Resources

Additional Resources

Warning: This site requires the use of scripts, which your browser does not currently allow. See how to enable scripts.

Add an organization chart

On the Drawing toolbar (toolbar: A bar with buttons and options that you use to carry out commands. To display a toolbar, click Customize on the Tools menu, and then click the Toolbars tab.), click Diagram or Organizational Chart .
Click the Organization Chart diagram, and then click OK.
Do one or more of the following:
- If you want to add text to a shape, right-click the shape, click Edit Text, and type the text.
  Text cannot be added to lines or connectors in organization charts.
- If you want to add a shape, select the shape you want to add the new shape under or next to, click the arrow on the Insert Shape button on the Organization Chart toolbar, and then click one or more of the following:
  Coworker— to place the shape next to the selected shape and connect it to the same superior (superior shape: In an organization chart, a shape that is placed above and connected to any other shape, such as an employee (subordinate or coworker shape) or assistant shape.) shape.
  
  Subordinate— to place the new shape below and connect it to the selected shape.
  
  Assistant— to place the new shape below the selected shape with an elbow connector.
- If you want to add a preset design scheme, click AutoFormat on the Organization Chart toolbar, and select a style from the Organization Chart Style Gallery.
Click outside the drawing when you are finished.