Others

How to Color Vacant Positions Red in a Visio Organization Chart

Rana GarciaRana Garcia Nov 3, 2026 869 views

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.

How to Color Vacant Positions Red in a Visio Organization Chart
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.
Before you start

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.

Solution 1Recommended

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.

1
Access Data Graphics

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.

2
Create a New Data Graphic

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.

3
Configure the Condition

In the 'Data field' dropdown, select the field that holds the employee name (e.g., 'Staff Name' or 'Name').

4
Set the Value and Color

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.

5
Apply 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.

Create a Data-Based Coloring Rule in Visio
Automatic Updates: If your chart is linked to an external Excel or database file, simply refreshing the data in Visio will automatically turn shapes red if someone leaves and the role is updated to 'Vacant'.
Free Microsoft Office alternative

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. 1. Launch WPS Presentation: Open WPS Office and create a new Presentation or Document where you want to build your chart.
  2. 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. 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.
Access built-in SmartArt and diagramming tools to build organization charts quickly.Fully compatible with Microsoft Word, Excel, and PowerPoint file formats.Manually color-code or apply quick styles to highlight vacant positions effortlessly.Lightweight, fast, and completely free to use for daily office tasks.
microsoft office alternative - wps office

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.