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

Pie Charts in Excel Pie Charts are used widely in the Microsoft Excel community but for the wrong analysis.Even though pies are delicious!, a Pie Chart should only be used to show several parts that make up a whole, for example, a product cost breakdown, margin breakdown or the market share of c...
Bubble Chart: 3 Variables On A Chart A Bubble Chart is an extension of the XY Scatter Chart.  It adds a 3rd variable to each point in the XY Scatter Chart.For example, if you have a Scatter Chart that shows the relationship between the age of a house and its proximity to the city and want to add the value of...
Excel Sparklines with Excel Tables Did you know that you can include an Excel Sparkline inside an Excel Table? Well you can!To create an Excel Table you need to highlight your data and press CTRL+TSee Tutorial HereOnce you have your Excel Table you can add your Excel Sparklines inside one Column and us...
Change the Axis Units in an Excel Chart Whenever you create a chart in Excel, it gives you the default vertical Axis based on the values that are in your data set.If you have large numbers in your data, like tens or hundreds of millions of dollars, then the vertical axes will take up lots of real estate space in yo...