Others

How to Add One-Time Public Holidays to a Visio Gantt Chart

Steve KSteve K Oct 26, 2026 868 views

Question details

The user wants to configure a specific, nonrecurring public holiday as a nonworking day in a Microsoft Visio Gantt chart.

How to Add One-Time Public Holidays to a Visio Gantt Chart
Product
Microsoft Visio
Device & OS
not provided
Scenario
Setting up project schedules and working hours to exclude single, one-off dates like specific national holidays.
Observed behavior
Visio currently only allows users to define nonworking days as recurring events, missing a native option for one-time holidays.
Before you start

Identify the exact dates of the public holidays affecting your project timeline, as you will need to manually account for these days in your Visio chart.

Solution 1Recommended

Manually Adjust Task Scheduling and Document the Holiday

Because Visio lacks a built-in feature for nonrecurring holidays, you must manually adjust the task durations or dates around the specific holiday.

Since Microsoft Visio's Gantt chart options only allow for recurring nonworking days (like weekends), single public holidays cannot be automatically excluded from the timeline. The most effective workaround is to adjust the schedule manually and add visual indicators.

1
Select the affected task

Click on the specific task bar in your Gantt chart that overlaps with the one-time public holiday.

2
Adjust the duration

Open the task properties and manually increase the task's duration by one day to account for the nonworking holiday.

3
Add a visual milestone or annotation

Drag a text box or milestone shape from the Shapes pane onto the timeline exactly on the date of the holiday, labeling it as a 'Public Holiday' for your team's reference.

Manually Adjust Task Scheduling and Document the Holiday
Alternative Tool: If your project requires complex scheduling with multiple one-off exceptions, consider using dedicated project management software like Microsoft Project, which fully supports nonrecurring calendar exceptions.
Free Microsoft Office alternative

Manage Project Schedules Easily with WPS Office

Microsoft Visio can be rigid and expensive for basic project scheduling. WPS Office provides a lightweight, highly compatible alternative. With WPS Spreadsheet, you can utilize professional Gantt chart templates that give you complete manual control over every working and nonworking day, all within a familiar interface.

Fully compatible with Microsoft Excel (.xlsx) formats for easy schedule sharing.Access a rich library of free, customizable Gantt chart templates.Lightweight and completely free to use for everyday office tasks.Familiar user interface ensures a seamless transition with zero learning curve.
microsoft office alternative - wps office

Frequently Asked Questions

Can I import an external calendar (.ics) into a Visio Gantt chart to set holidays?

No, Visio does not support importing external calendar files to automatically configure working and nonworking days. All timeline configurations must be done manually within the chart settings.

How do I configure recurring nonworking days in Visio?

Right-click on your Gantt chart, select 'Configure Working Time', and use the dialog box to set standard working hours and recurring nonworking days, such as weekends.

Is there another Microsoft tool that supports one-time holidays?

Yes, Microsoft Project is designed specifically for complex scheduling and allows you to add nonrecurring calendar exceptions, such as one-time public holidays, directly into the project calendar.