Pinterest Pixel

Organizational Charts in Excel

Organizational Charts are important in any business and documenting them is very easy to do within Excel... read more

Download Excel Workbook
John Michaloudis
Posted on

Overview

Organizational Charts in Excel | MyExcelOnline Organizational Charts in Excel | MyExcelOnline

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

See also  Change the Axis Units in an Excel Chart

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 Charts in Excel | MyExcelOnline
Download workbookOrganizational-Chart.xlsx

 

See also  Benchmark Chart in Excel 2013

MATCH Function Intro

If you like this Excel tip, please share it
Organizational Charts in Excel | MyExcelOnline Organizational Charts in Excel | MyExcelOnline
Founder & Chief Inspirational Officer at MyExcelOnline.com

John Michaloudis is a former accountant and finance analyst at General Electric, a Microsoft MVP since 2020, an Amazon #1 bestselling author of 4 Microsoft Excel books and teacher of Microsoft Excel & Office over at his flagship Academy Online Course.

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!

Share to...