How to Format Fields and Hide Data in Visio Organization Charts
Question details
The user needs to format title fields differently and hide specific data fields, such as email addresses, for executive positions in a database-linked Visio organization chart.

- Product
- Microsoft Visio
- Device & OS
- not provided
- Scenario
- Customizing the text formatting and controlling the visibility of specific data fields for different hierarchy levels in an automatically synchronized organization chart.
- Observed behavior
- Visio does not provide a built-in conditional formatting rule to hide entire data fields for selected positions, requiring alternative workarounds to achieve the desired display.
Before modifying your organization chart or its connected data source, ensure you have backed up the original source database (such as your Excel file) and saved a copy of your current Visio diagram.
Modify the Data Source to Hide Specific Information
Since Visio cannot conditionally hide fields for specific shapes, removing the targeted data directly from the connected database is the most reliable workaround.
Organization charts synchronized with an external database will always pull the exact information stored in the source file. To prevent data like email addresses from displaying for top-level executives, you must clear those specific cells in the database before synchronizing.
Open the external data source linked to your Visio chart, such as the corresponding Microsoft Excel spreadsheet or SQL table.
Locate the rows corresponding to the top-level executives and delete the values in the specific fields you wish to hide (e.g., the email address column).
Save and close the database file to ensure Visio can access the most recent changes.
Return to your Visio organization chart, navigate to the Org Chart tab on the ribbon, and click Refresh to apply the changes and hide the deleted fields.

Apply Custom Formatting via Data Graphics
Use Visio's Data Graphics feature or manual shape formatting to change the font and appearance of title fields for specific hierarchy levels.
Create Stunning Organization Charts with WPS Office
If you are looking for a simpler, more intuitive way to build and format organization charts without the complexities of database-linked Visio diagrams, WPS Office provides built-in SmartArt and diagramming tools that are highly intuitive and completely free.
- 1. Download WPS Office: Install WPS Office for free from the official website.
- 2. Open WPS Presentation: Launch WPS Presentation and navigate to the Insert tab.
- 3. Insert SmartArt: Click on SmartArt, select the Hierarchy category, and easily manually build and format your customized organization chart.

Frequently Asked Questions
Can I apply conditional formatting to hide specific fields in Visio org charts?
No, Visio does not offer a built-in conditional rule to completely hide a data field based on the shape's hierarchical position or text content. The most effective method is to clear the data from the linked source file and refresh the diagram.
How do I change the font color for only the executive titles in Visio?
You can manually select the executive shapes in the organization chart, navigate to the Home tab, and apply your desired font settings. Alternatively, you can create and apply a specific Data Graphic tailored for executive roles via the Data tab.
Why is the email field still showing after I deleted it from the shape in Visio?
If your organization chart is linked to an external database, any manual deletions directly on the Visio shape might be overwritten or ignored during synchronization. Always remove the data directly in the linked Excel spreadsheet or SQL database, then refresh the chart in Visio.




