Office Settings & Configuration

How to Format Fields and Hide Data in Visio Organization Charts

Emma BrownEmma Brown Nov 3, 2026 871 views

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.

How to Format Fields and Hide Data in Visio Organization Charts
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 you start

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.

Solution 1Recommended

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.

1
Open the source database

Open the external data source linked to your Visio chart, such as the corresponding Microsoft Excel spreadsheet or SQL table.

2
Remove the targeted data

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).

3
Save the data source

Save and close the database file to ensure Visio can access the most recent changes.

4
Synchronize the chart in Visio

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.

Modify the Data Source to Hide Specific Information
Synchronization Tip: Refreshing the data ensures that the structural integrity of the chart remains intact while safely omitting the confidential or unnecessary fields.
Free Microsoft Office alternative

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. 1. Download WPS Office: Install WPS Office for free from the official website.
  2. 2. Open WPS Presentation: Launch WPS Presentation and navigate to the Insert tab.
  3. 3. Insert SmartArt: Click on SmartArt, select the Hierarchy category, and easily manually build and format your customized organization chart.
Easily create and customize beautiful organization charts using SmartArt in WPS Presentation.Seamlessly open, edit, and save Microsoft Office file formats, including .docx, .xlsx, and .pptx.Lightweight software that runs smoothly on Windows, Mac, Linux, and mobile devices.Completely free alternative to expensive premium diagramming and office subscriptions.
microsoft office alternative - wps office

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.