Ever needed to create an organisation chart but don't have Visio? Have a look at Excel's built-in Org Chart creator.

Click Insert menu > Diagrams and select the Org Chart. Use the drop downs on the toolbar to add to the chart. The AutoFormat button has a selection of built-in formats that you can try. The chart is treated as a picture so you can resize the whole chart easily by clicking and dragging the sizing handles on the edges and corners of the chart.

In Excel 2007 you use Insert > SmartArt > Heirarchy and make a choice.

Check out the other diagrams that may be useful for other projects. 

Neale Blackwood a senior business analyst with Access Analytic Solutions, which provides financial modelling, management reporting services, as well as advanced Excel training. You can email Neale at nblackwood@accessanalytic.com.au