Others

How to Create Custom Organizational Chart Shapes in Visio 2019

Muhammad Talha Oct 15, 2026 869 views

Question details

The user is trying to automatically map imported Excel data fields (such as name, title, and position ID) to specific locations on custom organizational chart shapes in Visio 2019.

How to Create Custom Organizational Chart Shapes in Visio 2019

Product: Microsoft Visio Professional 2019
Device & OS: not provided
Scenario: Generating an organizational chart from an Excel data source and attempting to use custom shapes instead of the default Visio templates.
Observed behavior: The standard Organization Chart Wizard does not support automatically mapping imported fields to custom shape locations, causing the data to not display as required.

Before you start

Before attempting to customize shapes, ensure your source Excel data is properly formatted with clear column headers like Name, Title, and Position ID.

Solution 1Recommended

Use Built-in Templates and Data Graphics

Since the standard wizard struggles with custom shape mapping, using built-in shapes and applying Advanced Data Graphics is the most reliable way to display imported properties.

Visio's Organization Chart Wizard is strictly optimized for its built-in shape library. Bypassing custom shapes in favor of standard shapes allows you to leverage built-in data graphic mapping seamlessly.

Run the Organization Chart Wizard

Open Visio 2019, click on File > New, select Organization Chart, and choose to create it from information that is already stored in a file or database.

Map Data Fields

Follow the wizard prompts to import your Excel data. When asked, specify which columns represent the Name and Title to ensure they are displayed on the standard shapes.

Apply Advanced Data Graphics

To display additional fields like Position ID, select your shapes, navigate to the Data tab, click Advanced Data Graphics, and create a new graphic to map the remaining imported fields to the shape.

Use Built-in Templates and Data Graphics

Limitation Note: If you absolutely must use custom shapes instead of built-in templates, manual text entry or advanced VBA programming will be required.

Solution 2

Develop a Custom VBA Automation Solution

For advanced users who require strict automatic mapping of fields to non-standard custom shapes, VBA macros can bypass the standard wizard's limitations.

Solution 3

Submit a Feature Request via Microsoft Feedback

If standard shapes do not meet your aesthetic needs and VBA automation is too complex, submitting a feature request is the official channel to request this capability.

Free Microsoft Office alternative

Create Professional Diagrams and Documents with WPS Office

If you are looking for an accessible way to handle everyday document creation, organizational charts, and data management without the high cost of specialized software, WPS Office provides a powerful and lightweight alternative.

1. Download WPS Office: Visit the official WPS website and click the Free Download button.
2. Install the Suite: Run the installer and follow the on-screen instructions to set up WPS Office on your computer.
3. Create Organizational Charts: Open WPS Presentation or Writer, navigate to the Insert tab, click SmartArt, and select an organizational chart template to easily input your team's structure.

Free and lightweight Microsoft Office alternativeFully compatible with Microsoft Office formats (DOCX, XLSX, PPTX)Built-in SmartArt and diagram features for creating basic organizational charts easilyFamiliar user interface for seamless migration and quick onboarding

Frequently Asked Questions

Why won't my Excel data automatically map to my custom Visio shapes?

The Visio Organization Chart Wizard is hardcoded to work specifically with Visio's built-in organizational chart shapes. Custom shapes lack the necessary predefined data graphic placeholders and strict property tags required for the wizard to automatically map fields like Position ID or Title.

How can I display additional imported fields on standard Visio shapes?

You can display extra fields by applying Data Graphics. Select your chart shapes, go to the Data tab, click on Advanced Data Graphics, and choose which imported properties (like Position ID or Department) you want to overlay on the shapes.

Is it possible to use VBA to map organizational data in Visio?

Yes. Advanced users can develop custom VBA scripts to programmatically drop custom shapes onto a drawing page and explicitly bind imported Excel data to specific text blocks or shape data fields within those shapes.

Office Quick Solutions