How to Color Vacant Positions Red in a Visio Organization Chart
Question details
The user wants to format a Visio organization chart so that any shape associated with a vacant role automatically changes to a red fill color.

- Product
- Microsoft Visio
- Device & OS
- not provided
- Scenario
- Managing an organization chart and needing visual cues to quickly identify unassigned or vacant staff positions.
- Observed behavior
- The user needs a method to apply conditional formatting rules based on the 'Staff Name' data field within the chart.
Ensure that your Visio organization chart shapes contain shape data, specifically a 'Staff Name' or similar field, that accurately reflects the text 'Vacant' for empty roles.
Create a Data-Based Coloring Rule in Visio
Use Visio's 'Color by Value' data graphic feature to automatically evaluate the shape data and change the fill color to red when the specific condition is met.
Microsoft Visio includes a powerful feature called Data Graphics, which allows you to format shapes dynamically based on their underlying shape data. By setting up a 'Color by Value' rule, the chart updates automatically whenever a role becomes vacant.
Open your Visio organization chart. Navigate to the 'Data' tab on the ribbon and click on 'Advanced Data Graphics' or check the 'Data Graphics' pane depending on your Visio version.
Click on 'Create New Data Graphic'. In the dialog box that appears, select 'New Item' and choose 'Color by Value' from the list of display formats.
In the 'Data field' dropdown, select the field that holds the employee name (e.g., 'Staff Name' or 'Name').
Add a value mapping where the field equals 'Vacant'. Next to this value, click the color dropdown and select Red. Click 'OK' to save the rule.
Select the shapes in your organization chart (or press Ctrl+A to select all), then click on the newly created Data Graphic in the gallery to apply it. The vacant positions will now appear red.

Design Professional Organization Charts with WPS Office
While advanced data automation requires a premium Microsoft Visio subscription, you can easily create, manage, and color-code stunning organization charts for free using WPS Office. As a fully compatible suite, it provides an intuitive interface for all your diagramming and presentation needs.
- 1. Launch WPS Presentation: Open WPS Office and create a new Presentation or Document where you want to build your chart.
- 2. Insert a Diagram: Go to the 'Insert' tab, click on 'SmartArt' or 'WPS Art', and select a 'Hierarchy' template for your organization chart.
- 3. Customize and Highlight: Enter your team's hierarchy. To highlight a vacant position, simply click the specific shape, navigate to 'Shape Format', and change the 'Shape Fill' to red.

Frequently Asked Questions
Why is the Color by Value option grayed out in Visio?
This usually happens if your shapes do not contain underlying Shape Data. Right-click a shape, select 'Data', then 'Shape Data' to define fields before applying data graphics. Additionally, ensure you are using Visio Professional or Visio Plan 2, as Visio Standard has limited data connectivity features.
Can I color multiple positions with different colors automatically?
Yes. Within the 'Color by Value' configuration window, you can add multiple rows. For example, you can set 'Vacant' to red, 'Manager' to blue, and 'Contractor' to yellow.
Will this rule work across multiple pages of an organization chart?
Yes, but you must apply the created Data Graphic to the shapes on the other pages. You can do this by navigating to the other pages, selecting the shapes, and clicking the Data Graphic from the gallery.




