Organizational hierarchy charts are vital tools for visualizing and understanding the structure, roles, and relationships within a company. Microsoft Excel, with its powerful tools and wide use, is an excellent platform to create these charts. Here's a step-by-step guide to help you make an organizational hierarchy chart in Excel.
To start, let's assume you have the following data: Department, Position, and Employee Name.
Preparing Your Data
Before creating the chart, ensure your data is structured correctly:
- Start by listing all the departments and positions in the first two columns.
- In the third column, list the employee names under their respective positions.
Creating a Hierarchy List
First, create a hierarchy list using the Department and Position data. This will serve as the basis for your chart.
- In a new sheet, create a table with two columns: 'Level' and 'Text'.
Populating the Hierarchy List
Next, populate this table:
- In the 'Level' column, use the Department and Position data. The top level is the highest organizational level (e.g., '1' for the CEO).
- In the 'Text' column, combine the 'Level' and 'Text' to form a clear hierarchy (e.g., '1 - CEO').
Creating the Organizational Chart
Now, we'll use the organization chart layout to create your hierarchy chart.
- Go to 'Insert' tab, click on 'Organization Chart'. Then, select 'Create a new organizational chart'.
Adding Data to the Chart
Add the data from your hierarchy list:
- Click on 'Select-data-source'. Under 'Data', choose your hierarchy list sheet.
- Under 'Visual', select 'Use 'Level' Column for Hierarchy'. Click 'OK'.
Customizing Your Chart
Customize your chart to fit your organization's needs:
- Click on any box to open the 'Format' pane. Here, you can change the 'Name', add 'Subordinates', or change the shape and color of the boxes.
- You can also 'Add Organization Chart Layout' to the existing chart, making it a full organizational hierarchy.
And there you have it! A well-structured, visually appealing organizational hierarchy chart in Excel.