Organizational Charts are important in any business and documenting them is very easy to do within Excel and in particular, SmartArt.

To create an Organizational Chart in Excel you have to go to the ribbon menu and select Insert > SmartArt > Hierarchy > Organizational Chart.

These charts are very intuitive and you can click inside each shape to add your organizational titles.

When you click on the Organizational Chart it opens up the SmartArt Tools menu and in the Design tab you have an array of options in the Create Graphic group, which is loacted on the far left hand side of the ribbon.  You can:

ADD A SHAPE AFTER/BEFORE: This adds another shape to the right/left of the selected shape

ADD A SHAPE ABOVE/BELOW: This adds another shape one level above/below the selected shape E.g. Adds Managers after the VP

ADD AN ASSISTANT: This adds an assistant below the selected shape

RIGHT TO LEFT: This switches the layout of the selected hierarchy to the Left or to the Right of the Organizational Chart

PROMOTE/DEMOTE: This increases/decreases the level of the selected shape E.g. You can select a Manager and promote him/her to a VP

MOVE UP/DOWN: Moves the selected shape forward or backward in the sequence E.g. Swap the Managers around

CHANGE THE DESIGN: Click in the Organizational Chart and go to SmartArt Tools in the ribbon menu and choose the Design tab.  From the drop down box you can choose a variety of designs.

CHANGE THE COLORS: Click in the Organizational Chart and go to SmartArt Tools in the ribbon menu and choose the Design tab.  Click on the Change Colors button to change the color variation of your Organizational Chart.

P.S. You can also change shapes by Right Clicking on a shape and selecting the Change Shape option.


Organizational Chart



If you like this Excel tip, please share itEmail this to someone


Pin on Pinterest


Share on Facebook


Tweet about this on Twitter


Share on LinkedIn


Share on Google+


Related Posts

Custom Chart Labels Using Excel 2013 In a previous blog post we created a Benchmark Chart using Excel 2013.  We are going to extend this concept and add some cool looking custom chart labels to make our chart more informative. View the Benchmark Chart using Excel 2013   DOWNLOAD EXCEL WORKBOOK STEP ...
Process Map Using Excel If you want to show a process in your workplace then this can be designed using Excel´s Smart Art. There are heaps of Process Maps in Excel that shows progress from left to right, top to bottom, one way and circular.  Here is how you can insert a left to right Process Map usin...
100% Stacked Column Chart: Percentage Contribution... The 100% Stacked Column chart is an extension of the Stacked Column chart in that it compares the percentage that each value contributes to a Total. For example, if you want to show the percentage contributions for the North & South sales over the last 5 years then thi...
Sparklines: Line Sparklines are new in Excel 2010 and they show a graphical representation of your data in one cell. You can style them in different colors and add a marker for the High and Low points of your data.  As your data changes so do the Sparklines, which gives them that much more pow...