Making Organization Chart with Excel & Visio

Here we discuses about making Organization chart with visio by importing data from Excel sheet.

It is very simple and there is no need to use SmartArts or Shapes.

Step 1:

Prepare database in excel in this way:

The database sheet must have 2 columns. The first column is the person who reports and is labeled as “Owner”.  Second column is the person who gets the report and is labeled as “Report to” (See the figure below). Person A is the head of organization. B1 -B6 reports to A and so on.

step 2:

Open Visio> open Organization template> select “Org Chart” tab> click Import. you will see’ll something like the figure below.

Note: the other steps will shown in figures step by step.

after clicking finish you will see the Organization chart.

Looking for visualizing your Excel reports? Please contact us through the Excel data analysis & visualization services page.