excel gantt chart recurring task

Excel Gantt Chart: Mastering Recurring Tasks

By Michael Allen
AD

Ever found yourself in a project management ordeal, wishing you could magically-systemize recurring tasks? Excel's Gantt Chart feature can make your wish come true. Let's delve into how to create a Gantt Chart in Excel and make recurring tasks a breeze.

First, let's demystify the Gantt Chart. Despite being a project management staple, it's merely a visual representation of a project timeline using bar charts. Now that we have our bearings, let's dive right in!

Setting Up Your Excel Gantt Chart

Before we begin, ensure you have Excel 2010 or later. Here's how to set up your Gantt Chart:

AD
Dynamic Excel Gantt Chart | PMP schedule | Projects Tracker Spreadsheet| Construction | (Digital Excel Template)
Dynamic Excel Gantt Chart | PMP schedule | Projects Tracker Spreadsheet| Construction | (Digital Excel Template)
an excel spreadsheet showing project schedules and other items in the workflow
an excel spreadsheet showing project schedules and other items in the workflow
a project plan is shown in the middle of a large sheet with several different sections
a project plan is shown in the middle of a large sheet with several different sections

1. Create a task list in columns. Let's use A2 to A15 for tasks.

Adding TaskDurations

In column B, enter the number of days each task will take. For recurring tasks, use the recurring days, e.g., every 5 days.

Professionelles Gantt-Diagramm-Dashboard | Projektmanagement-Profi | Bauzeitplan | Fortschrittsübersicht
Professionelles Gantt-Diagramm-Dashboard | Projektmanagement-Profi | Bauzeitplan | Fortschrittsübersicht
Project Gantt Chart Excel Template | Project Timeline | Task Tracker | Project Management Spreadsheet
Project Gantt Chart Excel Template | Project Timeline | Task Tracker | Project Management Spreadsheet
Gantt Chart Excel & Google Sheets Template | Project Timeline, Task Planning & Progress Tracker
Gantt Chart Excel & Google Sheets Template | Project Timeline, Task Planning & Progress Tracker

For example, if you're task in A2 takes 5 days and occurs every 10 days, enter '5' in B2 and '10' in C2 (we'll discuss this later).

Setting Start Dates

In column C, put the start date of the task or '0' for immediate start.

AD

For our recurring task example, enter '0' in C2 as it starts immediately. Other recurring tasks can have their first occurrence set by adding the recurrence period to the start date.

How to Use Timeline Gantt Chart in Excel
How to Use Timeline Gantt Chart in Excel
Excel Gantt Chart Tutorial: Highlight Task Durations by Status with Conditional Formatting
Excel Gantt Chart Tutorial: Highlight Task Durations by Status with Conditional Formatting
Free Gantt Chart Template for Excel
Free Gantt Chart Template for Excel
Excel Gantt Chart Template for Project Management & Budget Tracking
Excel Gantt Chart Template for Project Management & Budget Tracking
Planned vs Actual Gantt Chart Excel Tracker | Baseline tracking Template | Progress tracker timeline
Planned vs Actual Gantt Chart Excel Tracker | Baseline tracking Template | Progress tracker timeline
a project plan is shown in the office calendar tool box, with multiple tasks displayed on it
a project plan is shown in the office calendar tool box, with multiple tasks displayed on it

Creating the Gantt Chart

Now that we have our task data, let's create the chart.

1. Select your data (A1:C15), then go to Insert > Recommended Charts. Choose 'All Charts' if your version doesn't have recommendations.

AD

Optimizing the Chart

Once inserted, optimize the chart as follows:

Gantt Chart Excel Template: Streamline Project Timelines & Budgets
Gantt Chart Excel Template: Streamline Project Timelines & Budgets

1. Right-click on the chart, select 'Select Data', then click 'Switch Row/Column' to orient tasks as rows.

2. On the 'Format' tab that appears, use 'Format Selection' to adjust colors, width, etc. On 'Add Chart Element', customize your axis and legends.

AD

Adding Recurrence

To show recurring tasks, use conditional formatting:

1. Select your chart, then go to Home > Conditional Formatting > New Rule.

2. Choose 'Use a formula to determine which cells to format', enter '=MOD($C2, $B2)=0' (adjust as needed), and format as desired.

And there you have it! Your Excel Gantt Chart now visualizes your project timeline, including recurring tasks. Keep refining and adjusting as your project evolves. Happy planning!

AD