Others

How to Update a Visio Organization Chart from Excel Data

Camila Milosovich Oct 22, 2026 868 views

Question details

The user needs to reliably update a Visio organization chart when the underlying Excel data changes, specifically regarding the automatic addition or removal of shapes.

How to Update a Visio Organization Chart from Excel Data

Product: Microsoft Visio
Device & OS: not provided
Scenario: Modifying source data in Excel and attempting to refresh the linked Visio organization chart to reflect structural changes.
Observed behavior: Native data linking in Visio updates existing shapes but fails to reliably add new shapes or remove deleted ones. The Excel Data Visualizer add-in supports dynamic updates but restricts datasets to 100 entries and offers limited formatting.

Before you start

Count the number of employees in your Excel dataset. If you have fewer than 100 entries, you can use the Excel add-in; otherwise, you will need to rebuild the chart using Visio's native wizard.

Solution 1Recommended

Use the Visio Data Visualizer Add-in in Excel

Use this method if your organization chart has fewer than 100 entries and you need automatic shape creation and removal upon refreshing.

The Data Visualizer add-in for Excel is designed to establish a dynamic, two-way link. Unlike standard Visio data linking, this tool automatically generates, modifies, and deletes shapes based on your Excel rows.

Install the Add-in

Open your Microsoft Excel workbook, navigate to the 'Insert' tab on the ribbon, click 'Get Add-ins', and search for 'Visio Data Visualizer'.

Insert the Chart

Add the extension, click on it, and select 'Organization Chart'. Choose your preferred layout style.

Update and Refresh

A sample data table will appear. Replace the placeholder text with your actual employee data (ensure it does not exceed 100 rows). Click the 'Refresh' button on the diagram header to automatically sync and create the shapes.

Use the Visio Data Visualizer Add-in in Excel

Add-in Limitations: This add-in limits entries to 100 rows and provides fewer formatting options compared to a native Visio file.

Solution 2

Re-run the Organization Chart Wizard in Visio

Ideal for organization charts exceeding 100 entries where the Data Visualizer add-in cannot be used.

Solution 3

Submit Feedback for Feature Enhancement

If these limitations impact your workflow, report the issue directly to the Microsoft Visio development team.

Free Microsoft Office alternative

Create Charts and Spreadsheets with WPS Office

If you are frustrated by the data limits and updating constraints of Microsoft Visio and Excel, consider using WPS Office. It provides a robust, free suite for managing complex spreadsheet data and creating stunning diagrams without the heavy subscription fees.

1. Download and Install: Get the free WPS Office suite from the official website and install it on your device.
2. Manage Data in WPS Spreadsheet: Open your existing .xlsx files directly in WPS Spreadsheet to organize your employee hierarchies effortlessly.
3. Design Your Chart: Use WPS presentation and drawing tools, along with integrated templates, to manually or systematically build beautiful organization charts.

Fully compatible with Microsoft Excel (.xlsx) files to handle all your organization data.Built-in diagram tools and rich template library for creating organizational charts.Free, lightweight, and easy-to-use Microsoft Office alternative.Familiar user interface ensuring seamless migration with zero learning curve.

microsoft office alternative - wps office

Frequently Asked Questions

Why doesn't Visio add new shapes when I refresh my linked Excel data?

Visio's basic data linking feature is designed to update the text and data properties of existing shapes. It does not contain the logic to automatically draw new shape boxes or restructure the hierarchy when rows are added or deleted in the source Excel file.

What is the maximum number of entries the Excel Data Visualizer add-in supports?

The Visio Data Visualizer add-in currently supports a maximum of 100 entries for automatic diagram generation. If your dataset exceeds this limit, you must use the native Visio Organization Chart Wizard.

Can I customize the look of the shapes generated by the Excel add-in?

The add-in offers limited layout and theme options directly within Excel. For full customization, including changing individual shape geometries or advanced formatting, you need to open the generated diagram in the full Visio desktop application.

Office Quick Solutions