Create Gantt Chart in excel in 5 Minutes | Learn to make Gantt chart in Excel. MIS Chart in Excel

 Create Gantt Chart in excel in 5 Minutes | Learn to make Gantt chart in Excel. MIS Chart in Excel

   Table of Contents

1.   Create Gantt Chart in Excel | MIS Chart in Excel

2.   Want to Learn Advance Excel OR MIS Chart in Excel

3.   How to make Gantt Chart? , Create Gantt Chart in Excel

4.   Gantt Chart in Excel Video | Learn Gantt Chart from video.

5.  Download Practice File for Gantt Chart in Excel

Create Gantt Chart in Excel | MIS Chart in Excel

Friends, sometimes we are sitting in an interview using Excel, and then we are asked to make this type of chart related to MIS (as you can see in the image below). So how do you make it?

By the way, this chart is known as Gantt Chart (Gantt Chart in Excel). This is an important chart in MIS Chart and Management level. It is mostly used for project management.

In this, there is your Task List on the left side, in the next column there is Start Date (date of starting the work) and End Date (date of completion of the work).

And in the next column, dates from 1 to 31 days are written. For example, if we select the Start Date and End Date of a task, then the cells in the next column from Start Date to End Date are automatically filled with color. (As you see in the chart.)

Due to which management becomes very easy, by looking at the chart once, one can understand when each task is starting and when it is ending. With this, managers can easily plan and organize any new tasks ahead.

So in today's blog, we are going to learn how to make a Gantt chart. If you have knowledge of advance excel, then you can create Gantt Chart in Excel very easily.

Want to Learn Advance Excel OR MIS Chart in Excel

Friends, to make Gantt Chart in Excel and to learn MIS, then you must know Advance Excel. Otherwise you will not understand some things at all.

If you do not know Advance and want to learn Advance Excel, then definitely check our Excel Basic to Advance Full Course in English course. Where you will get information from Basic to Advance, and along with videos with solutions of Real Job Query, you will also get practice files of all.

If you know Advance Excel, and want to become an expert in MIS. So you must check our Excel MIS Beginner to Advance course.

How to make Gantt Chart? , Create Gantt Chart in Excel

First of all, your Excel should have data like this.

• Sr No: In the first column we will create a column of SR NO.
• Activity/Project/Task: Here you have to make a list of Activity/Project/Task. It can be as per your requirement.
• Start date and End Date: Now start date column in the next column and end date column next to that. So here is the day our project starts. We will write its date in Start Date and the day it will end. We will write its date in End Date. For example, suppose one of my projects is starting on the 15th and that
• If it is ending on 25th, then 15 will be written in Start Date and 25 will be written in End Date. And as soon as we apply Conditional Formatting in it, the cells with dates from 15 to 25 will be highlighted in color.
• Task Scheduled (Complete Month Date Column): In the next column, headings for that date have to be given from 1 to 31 or 30, whichever is the last date of your month.
• Now we will select those cells where we want to create a Gantt chart and highlight those cells with color.
• After selecting the cells, we will select New Rule under Conditional Formatting in the Home tab.
• 
  
• Now after the New Rule window opens, we will choose the option “Use a Formula to determine which cells to format”.
• After choosing the option of “Use a Formula to determine which cells to format”, below it Edit the Rule Description, you get a box to write the formula. Above which it is written Format Values ​​where this formula is True, this means that if the formula written here is correct then format the selected cell (whatever color you want to format).
• Now we have to write this formula =AND(E$3>=$C4,E$3<=$D4) in the formula box, which we have created using AND function.
• 
  
• If you have knowledge of Advance excel then you will understand this formula and if not then no problem, watch our video given below where I have explained it in very easy language.
• After writing the formal, you have to click on the Format button and then you can give whatever formatting you want and create the rule by clicking OK.
• After which your Gantt Chart will be ready.

 

INSERT Tab [Excel] | Complete Use in Urdu | Excel Tutorial for beginners in Urdu and Hindi