Tutorial Playlist
68 Lessons1. Excel Tutorial
2. Excel Worksheet for Practice
3. Google Sheets Vs. Excel
4. Excel Shortcut Keys
5. Excel Keyboard Shortcuts
6. Excel AutoSum Shortcut
7. Redo Shortcut in Excel
8. Charts in Excel
9. Pivot Charts in Excel
10. Excel Sum Formula
11. Excel Percentage Formula
12. Excel Age Calculation Formula
13. Excel Range Formula
14. Round Off Formula in Excel
15. VLOOKUP Formula in Excel
16. Excel Transpose Formula
17. Average Equation in Excel
18. How to Use DATEDIF Formula in Excel
19. IRR Formula in Excel
20. Standard Deviation Formula
21. Excel Age Calculation Formula
22. Excel MAX Function
23. Excel LEFT Function
24. Excel RIGHT Function
25. Trim Function In Excel
26. LookUp function in Excel
27. Columns in Excel
28. How To Sort Data In Excel
29. How To Freeze Panes in Excel
30. Page Setup in Excel
31. How to Recover an Unsaved Excel File
32. Concatenate in Excel
33. Count In Excel
34. IF Condition In Excel
35. H LOOK UP in Excel
36. How Do You Move Columns in Excel
37. Split Cells in Excel
38. Remove Blank Rows in Excel
39. How To Lock Cells in Excel
40. Data Validation in Excel
41. How to Insert Checkbox in Excel
42. How To Highlight Duplicates in Excel
43. Fill Series in Excel
44. How to Create Excel Drop-Down List
45. What-If Analysis in Excel
46. How to Use SUMIFS Function in Excel
47. INDIRECT Function in Excel
48. Pivot Table in Excel
49. Slicers in Excel
50. How to Create a Dashboard in Excel
51. Excel Data Cleaning
52. Data Analysis In Excel
53. Goal Seek in Excel
54. Solver in Excel
55. Power Query in Excel
56. Macros In Excel
57. How To Make Graph in Excel
58. How To Make Histogram In Excel
59. How To Convert PDF to Excel Without Software
60. Barcode Font For Excel
61. Gantt Chart in Excel
Now Reading
62. Excel RANK function
63. AND Function in Excel
64. How to Calculate NPV
65. Format Painter in Excel
66. Count Colored Cells in Excel
67. Amortization Schedule in Excel
68. Master Cell References in Excel
Excel remains my favored tool for data calculation and visual representation even after being in project management for so long. Working with large datasets can be overwhelming. Excel has made my life simpler. Using the available tools I can create tables and charts.
I use a Gantt chart in Excel to present the tasks of a project. It is a type of bar graph that helps simplify complicated tasks. These charts are mainly used in project management to visualize the duration of events.
Let me walk you through the steps of how to create an effective Excel project Gantt chart.
Gantt charts are project management tools. They are primarily used to visualize the duration of tasks or events. This useful tool has helped me look at my project timeline at a glance. Excel project Gantt chart organizes tasks with their starting and ending dates. The duration of different tasks is shown on the chart as bars.
Gantt chart in Excel has two main axes. The horizontal axis represents the project timeline, and the vertical axis lists the tasks. It has horizontal bars, with the length of the bar representing the duration. This has helped me immensely by letting me predict the timeline for my projects.
Let me show you an example of a Gantt chart Excel template.
A typical Gantt chart in Excel looks something like this. Let me go over the steps to make a Gantt chart in detail for you.
Creating a Gantt chart in Excel requires using stacked bars. Working with the software for so long has taught me some tips and tricks. This is how I create Gantt chart Excel from my project data easily.
1. Create a table in Excel
I start by creating my project data in a spreadsheet. I list all the different tasks in different rows and their tenure. Make sure you mention the starting date, the ending date, and the duration of the project in this chart.
2. Create an Excel bar chart
Unfortunately, Excel does not have any particular option for making Gantt charts. I use stacked bars to create the chart I want. These are the steps I follow:
Step 1: Select the starting date column along with the header. In my case, the range is from B1 to B6.
Step 2: Click on ‘Insert’ from the top ribbon.
Step 3: Navigate to the ‘Charts’ group
Step 4: Choose the ‘Bar’ option.
Step 5: From the ‘2D’ section, select the ‘Stacked Bar’ option.
When you choose this option, a Stacked Bar will appear on your screen:
Note: Sometimes you might face the issue that all the dates at the bottom might overlap and not appear properly. You can simply use the cursor to drag and adjust the chart size.
3. Add duration to the stacked chart
To make the chart more elaborate, add the duration column to the chart. Check out the steps below:
Step 1: Right-click on the top of the chart. You will be shown a menu. From the menu, choose the ‘Select Data’ option.
Once you select that option, the ‘Select Data Source’ dialogue box will appear on the screen.
Look at the image above; start date has already been listed in ‘Legend Entries (Series)’. We want to add the duration to this series.
Step 2: Select the ‘Add’ button to include the duration data in the chart. The ‘Edit Series’ window will appear. Now enter the ‘Series name’ to whatever you want it to be. I have used ‘duration’, but you can choose anything you like.
Step 3: Click on the blue icon beside the ‘series values’ bar to select the range. A ‘Edit Series’ option will appear on your screen. Using the cursor, select the range from the duration column. Do not add the header to this range.
Step 4: Now, when I go back and press ‘OK’, I will again be shown the ‘Select Data Source’ window. In the image given below, you can see that ‘duration’ has been added to ‘Legend Entries (Series)’.
The resulting chart will look somewhat like this:
4. Add the task descriptions
You will notice that on the left of the chart, no task names have been mentioned. They are only represented by numbers. Here is how we can add the task names to the chart.
Step 1: Right-click on the chart. Select the ‘Select Data’ option from the menu. This will display the ‘Select Data Source’ window on your screen again.
Step 2: Select the ‘Edit’ option under the ‘Horizontal (Category) Axis Labels’ on the chart right. Keep an eye on the ‘start date’ is highlighted on the left panel.
Step 3: An ‘Axis Label’ window pops up on the screen. I selected the tasks just like I selected the ‘duration’.
In my case, I placed my cursor at A2 and dragged it up to A6. Again, ensure that you are not including the header or any empty cell when selecting the column.
Step 4: Click on ‘OK’ twice, and the tasks will be added to the chart.
You can also remove the index provided on the right-hand side of the chart. Place the cursor over it and right click. A menu will appear from which you can select the ‘delete’ option.
This is what my chart looks like without the index:
5. Transform the stacked bar to form a Gantt chart
The image given above is not a Gantt chart yet. To create a proper Gantt chart, I perform some formatting. I want to remove all the blue parts and only display the orange sections to make the tasks visible.
However, to achieve this, I will not remove the blue-colored bars but make them invisible. Let’s see how to do it to Gantt chart in Excel.
Step 1: Start by clicking on the blue bar. All the blue bars will be highlighted.
Step 2: Right-click and a menu will appear on your screen.
Step 3: Select the ‘Format Data Series’ option.
Step 4: From the ‘From Data Series’ window on your screen, navigate to the ‘Fill’ tab and choose ‘No Fill’.
Then, navigate to the ‘Border color’ tab and select the ‘No line’ option.
Finally, this is what the chart will look like.
This helps easily identify the Gantt chart Excel milestones.
6. Fixing the order
As you can see, the tasks listed on my chart are in the reverse order. Let me show you how you can fix that.
Here, I have listed the steps to reverse the order of tasks.
Step 1: Right-click on the vertical axis over the listed tasks. A menu will appear as shown below.
Step 2: Select the ‘Format Axis’ option. The ‘Format Axis’ window will appear on the screen.
Step 3: Check the ‘Categories in reverse order’ check box and close the window.
Do you want to improve your Excel skills? Learn how you can boost your knowledge of Excel.
Gantt chart in Excel is a popular tool among Project Managers. I have been using it to make my life simpler. Here are some of the benefits:
1. Visualizing project progression
A Gantt chart in Excel makes it simpler to see when projects begin and how they progress. This tool has helped me immensely in identifying overlapping projects.
It has also helped in identifying potential bottlenecks and making necessary changes. In these situations, staggering the dates slightly helps avoid possible issues.
2. Better time management
Let me illustrate this with an incident. Once, I had allotted three tasks to the same team with the same starting date. Using a Gantt chart in Excel helped me identify my mistakes and immediately make changes.
Understanding the tasks allocated to each team every day helps with better time management and equal task allocation.
3. Excel is easy
To manually create Gantt charts, Excel is daily easy-to-use software. As I have shown above, I simply add the data range to a spreadsheet and use the stacked bars option to create the Gantt charts.
Excel is very easy to use. However, knowing some Excel shortcuts can make the job even easier.
Gantt charts can be a blessing for Project Managers. It is an excellent project management tool used for project timeline tracking. Using a Gantt chart in Excel can help visualize project operations at a glance and streamline them.
Eager to learn more about Gantt chart in Excel with dates to streamline projects? Check out the certified courses offered by upGrad, which will help you boost your employability.
A Gantt chart in Excel is created using stacked bars. To get a full Excel Gantt chart tutorial, check out the steps listed above.
Duration in Gantt charts can be calculated using the following formulae:
A Gantt chart is a project management tool that comprises horizontal lines representing the time duration of a project. It makes visualizing project timelines easier.
To create Gantt charts, you can use stacked bars. Navigate to the ‘Insert’ option from the top ribbon. From ‘Bars’ select ‘Stacked Bar’ listed under 2D options.
You can create a simple Gantt chart Excel using the stacked bar option. Check out the steps of the process in this tutorial.
The ‘Stacked Bar’ option is the way to create a simple Gantt chart in Excel. Furthermore, you can make changes to it as needed.
Select the ‘Insert’ tab on the top ribbon. You will see a list of charts that you can use to present your data.
You can make a Gantt chart in Excel and partly automate it. Although Excel doesn't come with a built-in Gantt chart tool, you can still use its features, such as conditional formatting, formulae, and bar charts, to put together a Gantt chart.
Devesh
Passionate about Transforming Data into Actionable Insights through Analytics, with over 3+ years of experience working in Data Analytics, Data V…Read More
Talk to our experts. We’re available 24/7.
Indian Nationals
1800 210 2020
Foreign Nationals
+918045604032
upGrad does not grant credit; credits are granted, accepted or transferred at the sole discretion of the relevant educational institution offering the diploma or degree. We advise you to enquire further regarding the suitability of this program for your academic, professional requirements and job prospects before enrolling. upGrad does not make any representations regarding the recognition or equivalence of the credits or credentials awarded, unless otherwise expressly stated. Success depends on individual qualifications, experience, and efforts in seeking employment.
upGrad does not grant credit; credits are granted, accepted or transferred at the sole discretion of the relevant educational institution offering the diploma or degree. We advise you to enquire further regarding the suitability of this program for your academic, professional requirements and job prospects before enr...