Organisation Chart

Built-in feature

By Neale Blackwood

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. Check out the other diagrams that may be useful for other projects.


In Excel 2007 this feature is in the Insert Ribbon tab under Smart Art inthe Illustrations section. The Hierarchy category is most applicable to Organisation Charts.