Organizational charts are essential for understanding team structures, managing personnel, and communicating internal hierarchies. But building org charts manually can be time-consuming—especially when roles change frequently. That’s where the power of automation and interaction in Microsoft Visio 2024 combined with Excel 2021 can help.

In this guide, we’ll walk you through building a drag-and-drop org chart builder that draws structured employee data from Excel and lets users visually manipulate hierarchy in MS Office 2021 Pro Plus + MS Visio 2024 Pro. Whether you’re in HR, operations, or IT, this workflow will help you manage org charts faster and more intuitively.

Why Use Visio and Excel Together?

Microsoft Excel is excellent for storing structured employee data. Microsoft Visio, on the other hand, provides a visual workspace where that data becomes instantly digestible. When combined:

  • Excel acts as the backend (data source)

  • Visio acts as the frontend (visual interface)

  • Changes in Visio can be mirrored back to Excel (with macros or Power Query)

  • Drag-and-drop editing in Visio simplifies hierarchy updates

Features of a Drag-and-Drop Org Chart Builder

  • Import employee data from Excel

  • Automatically generate hierarchy in Visio

  • Use custom shapes, photos, and color codes

  • Enable drag-and-drop reordering within the hierarchy

  • Export updated structure or sync back to Excel

Step 1: Prepare Your Excel Org Chart Data

Start with a clean, structured spreadsheet that defines employee roles, IDs, and reporting structure.

Example format:

Employee ID Name Title Manager ID Department
E001 Alice Chen CEO Executive Team
E002 Brian Lee CTO E001 Tech
E003 Carol Smith CFO E001 Finance
E004 David Rao Engineering Lead E002 Tech
E005 Eve Grant Developer E004 Tech

Tips:

  • Ensure the Manager ID corresponds to another Employee ID

  • No circular references

  • Save as .xlsx or .csv for import

Step 2: Launch Visio 2024 and Choose the Right Template

  1. Open Visio 2024 Pro

  2. Search for and select the Organization Chart template

  3. Choose “Information that I enter using a wizard”

  4. In the wizard:

    • Select Excel file

    • Browse and open your prepared Excel sheet

    • Map fields accordingly:

      • Name → Name

      • Title → Title

      • Manager ID → Reports To

      • Employee ID → Unique Identifier

Visio will now automatically generate the hierarchy based on the relationships in your Excel file.

Step 3: Customize the Org Chart Appearance

Once the structure is generated, use Visio’s formatting tools to enhance usability:

  • Shapes: Use rectangle or badge shapes with rounded corners

  • Pictures: Insert employee headshots (if available)

  • Colors: Differentiate departments using color-coded borders

  • Text Fields: Display title, name, and department using Data Graphics

To add images:

  1. Right-click a shape

  2. Choose Replace Photo

  3. Select from your system or shared location

To apply conditional color formatting:

  1. Go to Data > Data Graphics > Create New Data Graphic

  2. Add rules (e.g., Department = „Finance“ → Yellow fill)

Step 4: Enable Drag-and-Drop Functionality

Visio allows interactive reshuffling of employees:

  • Click and drag a shape under a different manager

  • Drop to assign a new reporting relationship

  • Visio will redraw the connectors accordingly

To maintain data integrity:

  • Go to Org Chart tab > Options

  • Check “Update linked data when diagram is updated” (if available)

  • Dragging an employee updates their manager ID in the background

Note: To write these changes back to Excel, you’ll need a macro or export method (see Step 6).

Step 5: Add Department-Level Swimlanes (Optional)

For clarity in large org charts:

  1. Insert Swimlanes from the Cross-Functional Flowchart Shapes pane

  2. Label each swimlane by department

  3. Drag shapes into their respective swimlanes

  4. Resize lanes and containers to match your layout

This helps divide technical, financial, and administrative teams visually while keeping the reporting structure intact.

Step 6: Export or Sync Back to Excel

Unfortunately, Visio doesn’t offer native reverse syncing to Excel, but you can export data:

Option A: Copy from Shape Data

  1. Select all shapes (Ctrl + A)

  2. Go to Review > Shape Reports

  3. Choose fields (Name, Title, Reports To, etc.)

  4. Export to Excel or CSV

Option B: Use VBA Macro

If needed, use a VBA macro to extract updated shape relationships. Here’s a simple example:

Sub ExportOrgChartToExcel()

    Dim shp As Visio.Shape

    Dim xlApp As Object

    Dim xlWB As Object

    Dim row As Integer

    

    Set xlApp = CreateObject(„Excel.Application“)

    Set xlWB = xlApp.Workbooks.Add

    xlApp.Visible = True

    

    row = 2

    xlWB.Sheets(1).Cells(1, 1).Value = „Name“

    xlWB.Sheets(1).Cells(1, 2).Value = „Title“

    xlWB.Sheets(1).Cells(1, 3).Value = „Reports To“

    

    For Each shp In ActivePage.Shapes

        If shp.Type = visTypeGroup Then

            xlWB.Sheets(1).Cells(row, 1).Value = shp.Cells(„Prop.Name“).ResultStr(„“)

            xlWB.Sheets(1).Cells(row, 2).Value = shp.Cells(„Prop.Title“).ResultStr(„“)

            xlWB.Sheets(1).Cells(row, 3).Value = shp.Cells(„Prop.Manager“).ResultStr(„“)

            row = row + 1

        End If

    Next shp

End Sub

 

Step 7: Share and Collaborate

  • SharePoint/OneDrive: Save your Visio file to the cloud for team access

  • Teams Integration: Embed org charts in a Microsoft Teams channel

  • PDF Export: Use File > Export > Create PDF for presentation or printing

  • PowerPoint Export: Use Copy Drawing to paste visuals into a slide deck

Advantages of This Setup

  • Real-time visual planning without editing raw data

  • Easy updates when team structure changes

  • Centralized data source (Excel) for reporting

  • Enhanced stakeholder communication with visuals

  • Reusable template for ongoing HR activities

Use Cases

Department Use Case
Human Resources Onboarding structure planning
IT Role-based access control maps
Project Teams Temporary team organization
Finance Budgeting based on hierarchy
Operations Reporting workflows

Troubleshooting Tips

Problem Solution
Drag-and-drop not working Ensure you’re in Normal View and shapes are not locked
Images not appearing after drag Reassign photos manually post-move
Chart not reflecting Excel changes Refresh data source from Data > Refresh
Layout is cluttered Use Re-Layout Page from Org Chart tab
Macro security warning Enable macros via File > Options > Trust Center

Creating a drag-and-drop org chart builder using MS Office 2021 Pro Plus + MS Visio 2024 Pro transforms static team structures into dynamic visual tools. By linking Excel’s structured data with Visio’s design capabilities, you unlock a powerful system for organizational planning, employee management, and business transparency.

This solution not only reduces manual workload but also ensures charts are up-to-date, interactive, and easy to share across the organization. It’s a must-have toolset for modern HR and ops teams.

FAQs

1. Can I add photos to each employee shape in Visio?

Yes. You can right-click a shape and select “Replace Photo” to upload an image for each team member.

2. Can I update the Excel data from Visio after reshuffling?

Not natively, but you can export the updated structure via Shape Reports or VBA macros.

3. Is the drag-and-drop feature available in all versions of Visio?

It is supported in Visio Professional versions, including Visio 2024 Pro. Ensure shapes are not locked.

4. How do I handle large org charts with 100+ employees?

Use containers, swimlanes, or multiple pages. You can also collapse subordinates in Visio to simplify views.

5. Can this be automated for recurring org chart updates?

Yes. With Power Query or VBA, you can refresh Visio charts from updated Excel sources on a schedule.