Gantt Chart in Excel
Charts and Visualization

Quick Gantt Chart

In this article you will learn how we can create a Gantt Chat quickly in Microsoft Excel. A Gantt Chart is used to show the project plan or project schedule. We will create this chart by using the horizontal Stacked Bar Chart. Position of the bar will display the Start Date of an activity. Length of the bar will display the duration of the activity.

Below is the data set for which we will create the Gantt Chart. In this table there are 8 activities/tasks, their start date and duration(in days).

Data set to create a Quick Gantt Chart.
Data set to create a Quick Gantt Chart.

Below are the step to create a Quick Gantt Chart in Excel

  • Select the column B in the date set and change the format as General (Press Shift+Ctrl+~)
Start Date format as General
Start Date format as General
  • Select the entire data set and go to Insert Tab>>Charts>>Insert 2D Bar Chart.
Insert 2D-Bar Chart
Insert 2D-Bar Chart
  • In the Bar Chart Right click on the Vertical Axis (Task names) and click on Format Axis.
Format Axis option
Format Axis option
  • In the Format Axis window, tick the Categories in reverse order.

  • Now right click on Horizontal Axis (on dates) and click on Format Axis
Format Axis option
Format Axis option
  • Put the Minimum value as “43191” (Start date of Task-1)
  • Put the Maximum value as “43235” (Start date of Task-8 + Duration of Task-8)
Format Axis window
Format Axis window
  • Now in the chart select the blue bars (Start Date series)
  • Right click and click on Format Data Series.
Format Data Series option
Format Data Series option
  • In Format Data Series window, select Gap Width as 40% available under Series Option.
Series Options in Format Data Series
Series Options in Format Data Series
  • In Format Data Series window, select the Fill & Line option.
  • Select No fill option available in under Fill.
Fill and Line in Format Data Series
Fill and Line in Format Data Series
  • Click on Chart Elements button (“+” button of chart)
  • Remove the Legend and tick all the Gridlines.
Chart Elements
Chart Elements
  • Now select the orange bar and right click and click on Format Data Series.
  • In Format Data Series window go to the Fill & Line option.
  • Select the Gradient fill option available under Fill.
  • Select a Preset gradients as given in below image.
Gradient Fill option
Gradient Fill option
  • After doing the above settings, our chart will look like below image.
Chart after doing the settings
Chart after doing the settings
  • Now select the column B in data set can open Format cells window by using Shortcut key Alt+O+E.
  • Go to the Custom in Number tab and give the Type as “d-mmm
Format Cells window
Format Cells window

 

Our Gantt Chart is ready and it will look like below given image.

 

Gantt Chart in Excel
Gantt Chart in Excel

 

Click here to download this excel file.

 

Watch the Video tutorial of Gantt Chart-

PK
My Name is PK. I am founder of PK-AnExcelExpert.com. I am a Microsoft Certified Professional. I have more than 12 years of experience in Data Visualization, Excel Automation and dashboard creation. Excel is my passion and I like to do always something innovative in Excel and share it with other people.
https://www.pk-anexcelexpert.com

Leave a Reply