How to Create Organizational Charts With Excel 2007

1. Open Excel to a blank spreadsheet.
2. Click the 'Insert' tab, then click the 'SmartArt' button.
3. Select the 'Hierarchy' group from the left pane. Choose an organizational chart layout you like. Click on each one to see a preview and a description of it in the right pane. Click 'OK' after you have selected the one you want. You should see a chart with text boxes and lines appear.
4. Select a shape in the chart, then click the down arrow next to the 'Add Shape' button in the Design tab to add more boxes to your organizational chart. You can select whether you want to add a shape before, after or next to the box you originally selected. Keep adding shapes to your organizational chart as needed; Excel will automatically add lines showing hierarchies.
5. Click inside each text box to edit the names of each person. If you selected an organizational chart with images, you can click on each image to add an individual's picture.
6. Select different colors or styles for your chart by clicking a different 'SmartArt Styles' design or by clicking 'Change Colors.' Move or resize each text box by clicking and dragging the box or the handles surrounding the box.