Detailed instructions on how to build a Gantt chart in Excel

Date:

2018-03-23 20:49:12

Views:

525

Rating:

1Like 0Dislike

Share:

Table of contents:

Tabular editor "Microsoft Excel" is an excellent tool, suitable for creating all kinds of charts. However, you should select one that is perfect for display of time intervals, and it is called the Gantt chart. Its construction is somewhat different, so this article further, you will learn how to construct a Gantt chart in Excel.

Gantt chart excel

The Preparatory phase

Initially, before building a Gantt chart in Excel, you need to prepare the table itself, because it must have proper form, otherwise it will not work. It must be made temporary variables, that is why the article will be building on the example schedule of employees on leave. It is also important that the column names of the employees were not entitled, that is the cap it was empty. If you put the name, remove.

Gantt chart in excel template

If your table was created by analogy with the above presented, it means that you will succeed, and we can continue to talk about how to build a Gantt chart in Excel.

Step 1: build a bar of the stacked bar chart

However, before you can build a Gantt chart in Excel, you must create the other bar. To do this, follow these steps:

  1. Select your table. Place your cursor in one corner and holding the left mouse button (LMB), drag to another corner, placed diagonally.
  2. Go to the tab "Insert".
  3. Click on the button "Bar" that is located in the tool group "Graph".
  4. In the drop-down menu, click on any stacked chart. In this case, "three-dimensional stacked bar".

Gantt chart in excel example

Recommended

How to get out of

How to get out of "Skype" on the "Android" and not only

How to get out of "Skype" "Android"? This question bothers many users. The thing is that the messenger is not so difficult. But there are features that are only for mobile versions. To log out of Skype in this case more difficult than it seems. But i...

Kingo ROOT: how to use the program to gain administrative rights on Android

Kingo ROOT: how to use the program to gain administrative rights on Android

The Gadgets on the platform Android regained the lion's share of the market. Developers are continually perfecting the OS, trying to fit the needs of the users, but from year to year admit palpable mistake: forbid the owner to "stuffing" of his gadge...

How to get from Stormwind to Tanaris: practical tips

How to get from Stormwind to Tanaris: practical tips

World of Warcraft is an iconic MMORPG, uniting millions of players around the world. There are many locations and puzzles, secret trails and larger, but rather dangerous paths. Sooner or later, every player chose the side of the Alliance, we have to ...

Once you have done this, the worksheet will show the corresponding graph. This means that the first stage has been completed.

Step 2: format chart

At this stage of building a Gantt chart in Excel, you must make invisible the first row, which in our case is indicated by a blue color, that is, you need to in the diagram was just the holiday period, highlighted in red. To do this, you will need:

  1. Click LMB on any of the blue area.
  2. Call the context menu by pressing the RMB.
  3. To select "Formatting data".
  4. Go to the "Fill".
  5. Select "No fill."
  6. Click Close.

build Gantt charts in excel

Now, as you can see, the chart is missing the blue stripes, of course, more to the point that they became invisible. On that second phase is completed.

Step 3: change axis format

Displays the axis at the moment does not correspond exactly with the pattern, so it needs to change. To do this, follow these steps:

  1. Left-Click on the employee names to select them.
  2. Click.
  3. In the menu that appears click on "Format axis".
  4. A window will Appear. In it you need to go to the "axis Options" (usually opens by default).
  5. In the category you need to tick the "Reverse categories".
  6. Click Close.

build Gantt charts in excel

Now the chart has changed its appearance - the date at the top, and the names turned over. So, first of all, it will be easier to perceive the information, and the second will be correct, so to speak, as required by the standard.

By the way, at this stage, it would be nice to remove the legend in the chart, as it is in this case not needed. To do this, you need to initially select it by pressing LMB, and then press the DELETE key. Or remove it via the context menu invoked by right mouse button.

The Third step instructions on how to build a Gantt chart completed, but it is not the end, so go directly to the next step.

Step 4: changing the period

If you pay attention to the time period in the chart, we can see that its values are outside its boundaries that, at least, looks ugly. Now we are doing what will correct this nuance.

First, you need to allocate yourself time period. Then click the right mouse button on it and select from the menu the familiar paragraph "Format axis". In the appeared window you need is in the "axis Options". There are two values of "minimum" and "maximum", it is them you will need to change, but before you start move the switch to "Fixed". Then enter the period of time that you need. By the way, in this window you can set the minor tick marks if needed.

build Gantt charts in excel

In the end completing all steps, click "Close".

Step 5: enter the name

Was the last, fifth phase, which will finish the final formatting of our Gantt chart in Excel. In it we specify the name of the chart. Immediately move on to the process:

  1. Go to the Layout tab that is tab group "Working with diagrams". Please note that this group appears only in cases when a chart is selected.
  2. In the tab "Layout" you need to click on the button "chart Title" and in the drop-down list, select "Above chart".
  3. In the box that appears in the chart, youyou must enter directly the name itself. It is desirable to select this to fit the meaning.

build Gantt charts in excel

We Hope that our example of a Gantt chart in Excel helped you, as this creating is finished. Of course, you can continue formatting, but it will affect, so to speak, is a cosmetic part. By the way, if you don't want to bother and create it yourself, on the Internet you can find a lot of templates Gantt charts in Excel.


Article in other languages:

AR: https://www.tostpost.com/ar/computers/2845-excel.html

BE: https://www.tostpost.com/be/kamputary/5052-padrabyaznaya-nstrukcyya-yak-pabudavac-dyyagramu-ganta-excel.html

DE: https://www.tostpost.com/de/computer/5050-eine-detaillierte-anleitung-wie-man-ein-gantt-diagramm-in-excel.html

ES: https://www.tostpost.com/es/los-ordenadores/5055-instrucciones-detalladas-de-c-mo-construir-un-diagrama-de-gantt-en-exc.html

HI: https://www.tostpost.com/hi/computers/2846-detailed-instructions-on-how-to-build-a-gantt-chart-in-excel.html

JA: https://www.tostpost.com/ja/computers/2845-excel.html

KK: https://www.tostpost.com/kk/komp-yuterler/5053-toly-n-s-auly-ret-nde-salu-gant-diagrammasyn-excel.html

PL: https://www.tostpost.com/pl/komputery/5055-szczeg-owe-instrukcje-jak-zbudowa-wykres-gantta-w-programie-excel.html

PT: https://www.tostpost.com/pt/computadores/5052-instru-es-detalhadas-de-como-construir-um-gr-fico-de-gantt-no-excel.html

TR: https://www.tostpost.com/tr/bilgisayarlar/5058-ayr-nt-l-talimatlar-kurmak-i-in-nas-l-bir-gantt-grafi-i-excel.html

UK: https://www.tostpost.com/uk/komp-yuteri/5055-detal-na-nstrukc-ya-yak-pobuduvati-d-agramu-ganta-v-excel.html

ZH: https://www.tostpost.com/zh/computers/3077-excel.html






Alin Trodden - author of the article, editor
"Hi, I'm Alin Trodden. I write texts, read books, and look for impressions. And I'm not bad at telling you about it. I am always happy to participate in interesting projects."

Comments (0)

This article has no comment, be the first!

Add comment

Related News

How to remove Baidu from your computer? How to remove Baidu: useful information

How to remove Baidu from your computer? How to remove Baidu: useful information

increasingly, users are interested in, how to remove Baidu from your computer. What is this? And how is the removal of the software? To answer these questions is not as difficult as it seems. Can, study app is not only harmless, b...

The Geforce GTX 770: specifications, reviews, overclocking

The Geforce GTX 770: specifications, reviews, overclocking

the focus of this article is new from the company Nvidia, the graphics card slot on the base of the 770 GTX. The potential buyer has the opportunity to get acquainted with the product better, learn technical characteristics of vid...

File. How to change file extension

File. How to change file extension

As is known, the user file consists of two parts: name and extension. The name provided by the user and typically represents a logical link between the title and the content of the file. The extension will include the data to any ...

As to the power of a mermaid? The real power of a mermaid out of water

As to the power of a mermaid? The real power of a mermaid out of water

Mermaid is incredible mythical creatures that are found in a variety of narratives and stories. But whether they are mythical, what may seem at first glance? For example, you can take the series "H2O", produced in Australia - it t...

How to make a slide show on the computer? Program for a slideshow

How to make a slide show on the computer? Program for a slideshow

People involved in photography, often thinking about how to present their creations to the viewer most effectively. One of the easiest ways to achieve this goal is to create a slide show. If you wish so you can showcase a series o...

Sit Vkontakte offline

Sit Vkontakte offline

 As shown by recent studies on the websites called social networks, was more than 72 percent of our population. Now their popularity is also steadily increasing, albeit slower. And it's understandable – most people alre...