✦Template Printable Ideas Insights

Print Excel Org Chart: Step-by-Step Guide

By

Whether you're managing a team, conducting an organizational audit, or simply need to visualize your company's structure, understanding how to print an org chart in Excel can be incredibly beneficial. This popular spreadsheet software provides a multitude of tools to create and print organizational charts with ease. Let's delve into a step-by-step guide to help you achieve this efficiently.

Before we commence, ensure that you have the latest version of Microsoft Excel installed on your computer. Additionally, having some basic understanding of Excel's user interface and functions can be helpful, but don't worry if you're new to this - we'll guide you through the process.

Preparing Your Data in Excel

Excel requires your data to be in a specific format to create an org chart. The first column should contain the names of the employees, and the second column should contain the names of their respective managers. For example:

How to Make an Org Chart in Excel (+ video tutorial)
How to Make an Org Chart in Excel (+ video tutorial)
How to Create the Organizational Chart You Know Your Business Needs | Process Street | Compliance Operations Platform
How to Create the Organizational Chart You Know Your Business Needs | Process Street | Compliance Operations Platform
a computer screen with an arrow pointing to the text boss how did you make this org chart?
a computer screen with an arrow pointing to the text boss how did you make this org chart?
Name Manager
John Doe Jane Smith
Jane Smith Bob Johnson
Alice Brown Jane Smith

Creating the Org Chart

With your data neatly organized, it's time to create the org chart.

1. Click on the 'Insert' tab in the Excel menu.

How to Make an Organizational Chart in Excel - Tutorial
How to Make an Organizational Chart in Excel - Tutorial
How to Create an Organizational Chart Linked to Data in Excel (Easy & Dynamic)
How to Create an Organizational Chart Linked to Data in Excel (Easy & Dynamic)
How to Make an Organizational Chart in Excel - Tutorial
How to Make an Organizational Chart in Excel - Tutorial

2. In the 'Illustrations' group, click on 'SmartArt'.

3. Choose the 'Organization Chart' layout, then click on 'OK'.

Populating the Org Chart

Now, we'll fill in the chart with your data.

How to Create an Organizational Chart in Word with Free Templates | EdrawMax
How to Create an Organizational Chart in Word with Free Templates | EdrawMax
41 Organizational Chart Templates (Word, Excel, PowerPoint, PSD)
41 Organizational Chart Templates (Word, Excel, PowerPoint, PSD)
Organizational Chart Maker
Organizational Chart Maker
Excel Automatic Org Chart Generator
Excel Automatic Org Chart Generator
15+ Organizational Chart Template Free
15+ Organizational Chart Template Free
How to create a progress chart.#excel #microsoft #microsoftexcel #office #word #o #powerpoint.
How to create a progress chart.#excel #microsoft #microsoftexcel #office #word #o #powerpoint.

1. In the 'Text' box, click on the large text field that displays 'Hierarchy 1'.

2. In the 'Name' column of your Excel data, select the name at the top of the list (usually the highest authority).

3. Press 'Ctrl + C' to copy, then go back to your 'SmartArt' org chart and press 'Ctrl + V' to paste. The name should now appear in the first 'Hierarchy 1' text box.

Create a Stacked Column Chart with Total in Microsoft Excel
Create a Stacked Column Chart with Total in Microsoft Excel
How to make a male_female ratio chart in Excel
How to make a male_female ratio chart in Excel
Organizational Charts in Excel | MyExcelOnline
Organizational Charts in Excel | MyExcelOnline

Adding More Levels and Names to the Chart

Repeat the above steps to add additional levels and names to your org chart. Each time you paste a name, Excel will automatically create a new level in the chart.

Adding Managers

Excel will automatically insert managers based on your data, but what if you want to add or change a manager? Here's how:

1. Right-click on the individual whose manager you want to change.

2. Select 'Add Shape' then 'Add Assistant'.

3. In the 'Text' box that appears, enter the name of the manager.

Formatting Your Org Chart

Once you've added all the names, you can format your org chart to make it more engaging and professional.

1. Click on the 'Design' tab under 'SmartArt Tools'.

2. Choose the layout, colors, and style that best fit your company's branding.

3. You can also 'Reset Graphic' or 'Change Colors' and 'Change Layout' for additional customization options.

Congratulations, you've successfully created and populated your organizational chart in Excel! But we're not quite done yet - let's print it.

Printing Your Org Chart

Before printing, ensure your printer is connected and has enough ink or toner.

Adjusting Page Orientation and Margins

Depending on the size of your org chart, you may need to adjust the page orientation and margins.

1. Click on the 'File' tab.

2. Select 'Print'.

3. Under 'Settings', click on the drop-down menu for 'Orientation' and choose 'Portrait' or 'Landscape' based on your chart's layout.

4. Adjust the 'Margin' settings if needed to ensure your org chart prints in its entirety.

Printing Your Org Chart

Now, you're ready to print. Click on the 'Print' button, or press 'Ctrl + P'. Ensure the correct printer is selected, then click 'OK'.

There you have it! Your org chart is now printed and ready to use. This tool can be incredibly useful for visually understanding and communicating your organization's structure. However, remember that regular updates will keep your org chart current and accurate. Happy managing!