Add an organization chart - Excel - Microsoft Office Online

Home > Products > Excel > Excel 2003 Help and How-to > Charts and Graphics > Drawings and Diagrams > Diagrams and Organization Charts

Warning: You are viewing this page with an unsupported Web browser. This Web site works best with Microsoft Internet Explorer 6.0 or later, Firefox 1.5, or Netscape Navigator 8.0 or later. Learn more about supported browsers.

Email this link

Printer-Friendly Version Bookmark and Share

Add an organization chart

Applies to: Microsoft Office Excel 2003, PowerPoint 2003, Word 2003

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.