CFO 1

All About Gantt Charts

In this post, we will discuss everything you need to know about Gantt  charts. We will be introducing what Gantt charts are, how they have  come about, who should use it, and the pros and cons of using them. On  top of that, we will demonstrate how you can create your very own basic  Gantt Chart.

What are Gantt charts

Gantt charts serve as a scheduling tool which allows you to visually  see your plan of action on a project. A Gantt chart helps to bridge the  gaps of a plan by incorporating the timeline for when tasks of the  project should be implemented. Essentially, by visualising project  management timelines in cascading horizontal bar charts with tasks that  may be interdependent on one another, it aims to help you get a better  overview of the project.

How Gantt charts came about

The initial prototype of the Gantt chart was first developed in the  mid 1890s by a Polish engineer named Karol Adamiecki. He created the  first visual work flow chart which he called a “harmonogram.”
Around 15 years after Adamiecki, Henry Gantt further improved on  Adamiecki’s “harmonogram”. With the goal of helping manufacturing  supervisors determine if their work was behind of, ahead of, or on  schedule, Gantt’s work formed the foundation of the tool we know of and  use today.

Who should use Gantt charts

Gantt charts are for everyone who need to plan and schedule their  list of tasks that fall under an overarching goal or theme. Hence, this  useful tool can be used for personal management, team level  coordination, as well as on the corporate level. In general, if you are  working on a longer project with a high number of elements and tasks,  the Gantt chart may be a tool which you would like to consider using.

Advantages of using Gantt charts

1. Simplified Summary of Tasks

The Gantt chart helps to simplify complex linear list of tasks by  collating them into a single visual diagram which helps in understanding  of the project as a whole, by illustrating these thoughts and ideas  together in a pictorial format.

2. Visibility of Project Progress

With Gantt charts being visual in nature, it is much easier to view a  project’s progress through the bars that it displays. This improves the  accountability of members of the project as it allows the team leader  to track the team’s progress and discuss forward-planning strategies  during review sessions.

By understanding if a project’s task is on schedule, the project  manager is able to use the Gantt chart to remind members to keep to the  schedule for punctual delivery of the project. Also, by using bars to  indicate the duration of a task, it gives you a better perspective of  the total project, and the timeframe as a whole.

3. Clarity of Project Implementation

When you execute a complex project, you will have a great multitude  of tasks. With a visual tool like the Gantt chart, there is clarity in  implementing these tasks as they are displayed in a single document. It  shows how the interplay of tasks come together towards project  completion.
The clarity of mind to know how long a project should take for  completion aids in the management of time, scope of work, as well as  motivation. As Stephen R. Covey puts it “Start with the end in mind”. A  clear plan which shows all that needs to be done and in what order helps  decision-makers look farther ahead to ensure each given project is  working toward the achievement the organization’s long-term strategic  objectives.

The Gantt chart also promotes the concept of dividing and conquering,  as it breaks project into smaller tasks and shows what is to be  delivered in each project phase. This makes it much easier for the  project’s tasks to be executed, and for the overall project to be  successfully completed.

4. Concise Communication & Coordination

The Gantt chart helps to keep everyone involved in the project on the  same page. This means that all stakeholders are able to possess the  same information, where mutually understood expectations can be set and  managed better. Project managers would then be better able to  communicate concisely to subcontractors and lead them more  strategically.

With this ease of coordination project managers would have the  ability to sequence events and break projects into smaller manageable  tasks, which ultimately prevents overburden

5. Increased Task Efficiency of a Team

A team member can start on another task while waiting for a dependent  task to be completed by other members. The Gantt chart helps one to  focus on what truly needs to be done, thus making you more organised and  allowing for a more successful project.

With better focus, there will naturally be better time management.  This useful tool helps to foster greater collaboration, with the ability  to see the impact of delays of tasks through understanding task  relationships. Eventually, this ensures optimum work flow, maximised  productivity and overall project success.

Disadvantages of using Gantt charts

1. Danger of being too detailed

If you become too detailed, you might end up losing sight of the  bigger picture of the project. Hence, it is always a good practice,  especially for big businesses, to have project managers overseeing each  project that they have undertaken.

2. Size of bar doesn’t indicate amount of work to be done

The Gantt chart serves to give just a general gauge of tasks. The  bars of the Gantt chart does not show how much work each task will  involve or the amount of people or resources each task will require.

3. Need for constant updating

A Gantt chart can be quite troublesome to update. As tasks are  completed or reviewed, the chart will need to be updated frequently to  reflect those changes. Any amendments to the chart takes time to be  carried out, which can be better spent working on the actual tasks.

4. Difficult to see on one sheet of paper

On occasions where the project is more complex, it is difficult to  show details of the plan, and charts can be too large and hard to read.

How to create a basic Gantt chart

Now, let us explore more into creating a basic Gantt Chart.

Step 1:  List down the main phases of your project

Step 1

Step 2: List down the tasks associated under these phases

Step 2

Step 3: Fill in the start date and the estimated duration (days) which you think you can complete these tasks

Step 3

Step 4: Insert a 2D stacked bar chart as shown in the picture

Step 4

Step 5: Click on “Select Data” under Chart Tools > Design

Step 5

Step 6: Click “Add”

Step 6

Step 7: Enter “Start Date” into the series name field and select series values as shown

Step 7

Step 8: Click “Add”

Step 8

Step 9: Enter “Duration” into the series name field and select series values as shown

Step 9

Step 10: Click “Edit”

Step 10

Step 11: Select the range of cells as shown

Step 11

Step 12: Right click on the y-axis and format it

Step 12

Step 13: Check “Categories in reverse order”

Step 13

Step 14: Right click on the x-axis and format it

Step 15: Use the following settings for the formatting

Step 15

Step 16: Right click on the “Start Date” series and format it. Select “No fill”

Step 16

Step 17: Right click on the earliest “Start Date” and click on  “General” as the category. Note down the number (eg. 42370) and then  click “Cancel”.

Step 17

Step 18: Right click on the latest “End Date” and click on “General”  as the category. Note down the number (eg. 42442) and then click  “Cancel”.

Step 18

Step 19: Right click on the x-axis and apply these two numbers under  “Axis Options”. This is to accurately frame your Gantt chart.

Step 19

Step 20: Adjust your Gantt chart to the most suitable size and you’re done!

Step 20

Here is a video walkthrough to help you better understand the steps.

Subscribe Paloe

Thank you for reading! Like our content?

Sharpen your finance acumen through our FREE WEBINARS. Sign up for our mailing list and we’ll inform you about any future events or webinars.

Free Webinars

Optimise your company’s finance functions with a FREE 1-hr consultation

Related content

Here are similar contents you might like:

Tips to improve your “work from home” productivity

Working from home offers flexibility and convenience, but it also presents unique challenges when it comes to maintaining productivity. With a few simple adjustments to your routine and environment, you can maximize your efficiency and achieve your professional goals. Let’s explore four practical tips that can help you stay on

Read More >

Two types of online shopping and how they can help your business

How the pandemic has affected market preferences in online shopping It is not foreign to hear of people shopping online nowadays, especially after the pandemic has affected other transaction methods except online transactions. The online shopping experience, too, has evolved since then as more users are using c-commerce. There are

Read More >

What does building a full-fledged software looks like?

Imagine one day you woke up with a brilliant idea, and you’re excited to build a software around it, what would be your next step and how can you build a full-fledged, sustainable software product? Building a full-fledged and sustainable software is not just about code development (programming). It is

Read More >
Open chat
Hi I'm Sam! How may I help you today?