Where to Find the Organizational Chart Wizard in Visio Plan 2
Question details
The user needs to locate the Organizational Chart Wizard in Visio to create a chart from Excel data.

- Product
- Microsoft Visio
- Device & OS
- not provided
- Scenario
- Attempting to generate an automated organizational chart using an Excel data source.
- Observed behavior
- The Organizational Chart Wizard option is missing and cannot be found in the current Visio view (Visio for the web).
Verify your Microsoft account subscription details to ensure you have an active Visio Plan 2 license, as Visio Plan 1 does not include the necessary desktop application.
Install and Use the Visio Desktop Application
Access the Organizational Chart Wizard by switching from the web version to the fully featured Visio desktop app included in your Plan 2 subscription.
Visio for the web is a lightweight tool designed for basic diagramming and does not support advanced data-linking features like the Organizational Chart Wizard. To import organizational data from Excel, you must utilize the Visio desktop application.
Navigate to the Microsoft 365 portal in your web browser and sign in with the account associated with your Visio Plan 2 subscription.
Click on the 'Install Office' or 'Install apps' button on your dashboard, locate Visio, and download the desktop installer. Run the installer to complete the setup.
Launch the Visio application from your computer's start menu and sign in using your Microsoft credentials.
Click on 'File' > 'New', search for 'Organization Chart', and select the template to launch the Organizational Chart Wizard. Follow the prompts to import your Excel file.

Create Professional Charts Easily with WPS Office
If you don't want to pay for a premium Visio Plan 2 subscription just to create charts, WPS Office offers a free, lightweight suite with built-in drawing and diagramming tools. Enjoy high format compatibility, a familiar interface, and versatile document management without the hefty price tag.
- 1. Download WPS Office: Visit the official WPS website and download the free installation package for your operating system.
- 2. Install the Suite: Run the setup file and follow the on-screen instructions to install WPS Office on your computer.
- 3. Create Your Charts: Open WPS Presentation or WPS Writer, navigate to the 'Insert' tab, and use the 'SmartArt' or 'Shapes' features to easily build your organizational charts.

Frequently Asked Questions
Can I manually create an organizational chart in Visio for the web?
Yes, you can manually drag and drop shapes to build an organizational chart in Visio for the web. However, you cannot automatically generate one by importing an Excel data file, as the Wizard is missing.
Why is the Organizational Chart Wizard missing in my desktop Visio app?
If you are using the desktop app and the wizard is missing, ensure you are starting a new document using the specific 'Organization Chart' template. Go to File > New > Templates > Business, and select Organization Chart.
What Excel format is required for the Visio Organizational Chart Wizard?
Your Excel file (.xlsx or .xls) should contain clear columns for the employee's name, their role/title, and who they report to (Manager's name). The 'Reports To' column is crucial for the wizard to understand the hierarchy.




