✦Template Printable Ideas Insights

Easy Guide: Create Gantt Chart in Excel 2016

By

Looking to streamline your projects and keep track of tasks? A simple Gantt chart in Excel can be an excellent tool for visualizing tasks, deadlines, and progress. Let's dive into a step-by-step guide to create one, no advanced skills required!

Before we start, ensure you're using Excel 2010 or a later version, and your workbook is saved in the Excel 97-2003 format (.xls) or the Office Open XML format (.xlsx). Now, let's begin!

Setting Up Your Gantt Chart

Before we add the tasks and dates, we need to set up the basic structure. First, delete any data in columns A and B, then add a heading to cell A1: "Task". In cell B1, type "Start" and in C1, "End".

How to Use Timeline Gantt Chart in Excel
How to Use Timeline Gantt Chart in Excel
the gantt chart in excel book with text overlaying it, and an image of
the gantt chart in excel book with text overlaying it, and an image of
How to Use a Gantt Chart for Production Planning in Excel
How to Use a Gantt Chart for Production Planning in Excel

Next, we'll create a timeline. In cell D1, type "1" and then drag the fill handle down to D1000 to automatically generate numbers. This will serve as our timeline's scale.

Entering Your Tasks and Start Dates

Now it's time to add your tasks. Starting from cell A2, enter each task one by one. Move down to A3 for the next task. Below each task, you'll enter the start date. In the corresponding cell under "Start" (column B), enter the task's start date using the DATE function, like this: =DATE(2022,5,1).

Make Gantt Chart in Excel: Quick Tutorial - How to Create Gantt Charts in Excel with Progress Bars
Make Gantt Chart in Excel: Quick Tutorial - How to Create Gantt Charts in Excel with Progress Bars
TECH-005 - Create a quick and simple Time Line (Gantt Chart) in Excel
TECH-005 - Create a quick and simple Time Line (Gantt Chart) in Excel
3 Easy Ways To Make a Gantt Chart (+ Free Excel Template)
3 Easy Ways To Make a Gantt Chart (+ Free Excel Template)

For example, if your first task starts on May 1, 2022, in cell B2, enter: =DATE(2022,5,1). Repeat this process for each task, adjusting the date as needed.

Calculating End Dates

Now, let's calculate the end dates for each task. In the corresponding cell under "End" (column C), use the following function: =B2+5. This assumes a task duration of 5 days. Adjust as needed. Copy this formula across to the rest of the tasks.

Formula example: Assuming your first task start date is B2, in C2, type: =B2+5. Copy this formula to C3, change the number to match your second task's days, and so on.

Gantt Chart Excel
Gantt Chart Excel
Monthly Gantt Chart Excel Template Xls In the event that you manage a team employee or busy h...
Monthly Gantt Chart Excel Template Xls In the event that you manage a team employee or busy h...
Gantt Chart in Excel Simple, Easy and Quick Method
Gantt Chart in Excel Simple, Easy and Quick Method
Showing Actual Dates vs. Planned Dates in a Gantt Chart
Showing Actual Dates vs. Planned Dates in a Gantt Chart
Download Gantt Chart Excel Template Project Planner
Download Gantt Chart Excel Template Project Planner
How To...Create a Basic Gantt Chart in Excel 2010
How To...Create a Basic Gantt Chart in Excel 2010

Formatting and Filling the Gantt Chart

Next, we'll format the cells to reflect the tasks' durations. Select cells A1:C1000, click "Format" (Home tab), then "Conditional Formatting". Choose "New Rule...", then "Use a formula to determine what cells to format".

In the 'Format values where this formula is true:' field, type: =AND($A$1:$A$1000=C2, $B$1:$B$1000<=C1, $C$1:$C$1000>=B1). Click "Format" and choose the fill color for your bars. Then, click "OK", "OK", and finally "Close".

Adjusting the Timeline

Resize the column D width to approximately 50, and row 70 height to 50. This ensures our Gantt chart fits nicely within our spreadsheet. Now, you should see your tasks' bars in the timeline, representing their start and end dates.

Gantt Chart Template for Excel
Gantt Chart Template for Excel
Project Gantt Chart Template for Excel
Project Gantt Chart Template for Excel
3 Easy Ways To Make a Gantt Chart (+ Free Excel Template)
3 Easy Ways To Make a Gantt Chart (+ Free Excel Template)

To view empty days between tasks, apply conditional formatting to cells D1:D1000. "Format" (Home tab), "Conditional Formatting", choose "Highlight Cells Rules", then "Equal to". Input "0" and choose a fill color without border. Click "OK", then "OK".

And there you have it! A simple yet powerful Gantt chart to keep your projects on track. Happy planning! Now that you've mastered the basics, consider exploring advanced features like adding dependencies between tasks, adding milestones, or using color-coding for different project strands. Good luck!