What is Excel Gantt?
XLGantt is a program designed to enable project scheduling in Microsoft Excel. It is composed of the following features. You don’t need to install this program because it is a Excel macro file.
Main Sheet
The schedule sheet is the main sheet and is composed as follows.
- Ribbon Menu for Excel Gantt : After entering a task and schedule, you can calculate and analyze the workload.
- Project information : Project name, project period, plan/Actual progress display area.
- Group : Grouping rows.
- WBS : Area for entering task name, start/finish date, resources, deliverables, %work complete, etc.
- Gantt Chart : Gantt chart is displayed based on the data entered in WBS.
Other sheets
| Schedule | When you enter a task and a schedule, the progress rate is calculated and the schedule of the task is displayed as a gantt chart. |
| Progress | Shows you the workloads, progresses, etc. |
| AnalysisReport | Shows you the progresses and workloads of the project by weeks, months, and resources. |
| Calendar | Sets nonworking days. |
| Workload | Makes workload data by weekly and monthly. You can do analysis as you want by using Excel features such as pivot. |
| ServerData | It is used when you want to see schedule data of IT system where server exists separately. |
| TranslatedLanguages (Hidden sheet) | Contains language-specific translations. |
Program Updates
XLGantt version 4.5.0 has been released (1/2/2021 Release)
Version 4.5.0 includes following features and bug fixes :
1. Added a feature to display in color when there are schedule variances
The "%Work Complete" column is displayed in green when the task is ahead of schedule, white when the task is on schedule, and red when the task is behind.
The color can be changed by choosing the “Custom” theme from the color theme of the option as follows.
2. If the actual start date is different from the planned date, the progress line of the Gantt chart is displayed in color.
The progress line of the Gantt chart is displayed in green if the actual start date starts earlier than the plan, blue if it starts on the same day as the plan, and red if it starts later than the planned date.
The color can be changed by choosing the “Custom” theme from the color theme of the option as follows.
3. User language (Custom) definition feature that allows users to change titles, messages, etc.
If you want to change the "Finish" title to "End Date" as shown below, proceed in the following order.
1) Unhide the sheet containing the language setting(TranslatedLanguages sheet).
2) In column F (column marked as Custom), find the value of "Finish" and change it to "End Date".
3) If you choose “Custom” as the language in the XLGantt ribbon menu> Options> Language menu,
the title is changed to the changed value.
Download the program file from the link below!
After downloading, unzip and use the "XLGantt_v4.5.0_20210102_Release_ENG.xlsm" file.
XLGantt Version 4.5.0 Terms of Use
This “Program" is free software developed and distributed by xlworks.net. This program is free to use anywhere, anytime including personal / business / government / school.
This Software is protected by copyright laws and other intellectual property laws and international treaties and may not be modified, reverse engineered, decompiled, disassembled, or made part of other software.
How to use XLGantt(Excel Gantt)
"How to" is prepared for each feature as follows. When you click on the [View] link, the "How to" page opens.
1) Getting Started With XLGantt
If you want to learn the features quick and easily, see the "Getting Started With XLGantt". [Learn more]
2) Enter tasks, update schedule
When you enter task names, start and finish dates, and %work complete values, XLGantt automatically calculates the tasks durations, planned %work complete, etc. [Learn more]
3) Setting Gantt chart display styles
You can click the "Options" button on the ribbon to customize a Gantt chart style. [Learn more]
4) Keeping track of project progress
You can use %work complete to keep track of the progress of the project. [Learn more]
5) Analysis Report
Provides you with analysis reports such as progress, workload, and workload data for tracking the status of your project. [Learn more]
6) Managing Schedule Changes
Manages the planned schedule and actual schedule of the project. [Learn more]
7) Deliverables
Specifies the save path of the deliverables and open the deliverables. [Learn more]
8) Adding Tasks to Microsoft Outlook Calendar
Adds tasks to the Outlook calendar(You must have Microsoft Outlook installed on your PC). [Learn more]
9) Multilingual Support
Currently we support only English and Korean as user interface(UI) language at XLGantt. Since the program code and the resource file for multiple languages are separated, it is possible to add multiple languages without modifying the program. [Learn more]
10) Importing Schedules from Another File
Imports schedules into XLGantt. You can import the schedules by mapping the fields. [Learn more]
11) Calendar
When you enter nonworking days, XLGantt excludes them from calculations of working time. Standard calendar is the default calendar. If you want to specify a different calendar for a specific task, please use "User Defined Calendar 1" or "User Defined Calendar 2". [Learn more]
12) Integration with Excel Features
You can include the formulas and functions of the Excel in XLGantt. [Learn more]
13) Importing Server Data
You can use this feature if you want to see the server's schedule data. If you put the schedule data on the Server into the ServerData sheet and download the XLGantt file and open the XLGantt file, the data comes into the Schedule sheet. [Learn more]
14) Workload calculation
In previous versions, you could only calculate the workload by weight, but now you can calculate the workload by resource allocation ratio. [Learn more]
15) Setting WBS Area and Color Theme
XLGantt provides features to change the appearance of the Schedule sheet. You can change the appearance of the WBS area and change the title of the schedule sheet and the color of the Gantt chart using the color theme feature. [Learn more]
[ Posts related to XLGantt ]
- XLGantt(Excel Gantt) How to #7 – Deliverables
- XLGantt(Excel Gantt) How to #8 - Adding Tasks to Microsoft Outlook Calendar
- XLGantt(Excel Gantt) How to #9 - Multilingual Support
- XLGantt(Excel Gantt) How to #10 – Importing Schedules from Another File
- XLGantt(Excel Gantt) How to #11 – Calendar
- XLGantt(Excel Gantt) How to #12 – Integration with Excel Features
- XLGantt(Excel Gantt) How to #13 – Importing Server Data
- XLGantt(Excel Gantt) How to #14 – Workload calculation
- XLGantt(Excel Gantt) How to #15 – Setting WBS Area and Color Theme
- XLGantt(Excel Gantt) How to #6 – Managing Schedule Change
- XLGantt(Excel Gantt) How to #5 – Analysis Report
- XLGantt(Excel Gantt) Chart and WBS (ver 4.5.0) 1/2/2021. Release
- XLGantt(Excel Gantt) 4.0.0 version has been released.
- XLGantt(Excel Gantt) 3.0.1 version has been released.
- XLGantt(Excel Gantt) How to #4 – Keeping track the progress of the project
- XLGantt(Excel Gantt) How to #3 - Setting Gantt chart display styles
- XLGantt(Excel Gantt) How to #2 - Enter tasks, Update schedule
- XLGantt(Excel Gantt) How to #1 - Getting Started With XLGantt
Program update history
Version 4.5.0 includes following features and bug fixes :
- Pre-specified color themes are provided and can be set by the user.
- You can mark tasks as milestones.
- In previous versions, you could only calculate the workload by weight, but now you can calculate the workload by resource allocation ratio.
- In addition, you can display the project week number and year on the Gantt chart.
Version 3.0.1 includes following features and bug fixes :
- Tasks can be added up to 10 levels (previous version only supports 7 levels).
- Added a feature to view the progress graph of planned / earned / actual workload (weekly / monthly).
- Data export for analysis to “Workload” sheet.
- Week number display on the Gantt chart.
- Date display on the Gantt chart timescale.
- Bug fixes etc.
Version 2.1.0 includes following features and bug fixes :
- Group rows feature
- Fixed bugs that do not work with Excel 2007 version
- Fixed errors when opening multiple XLGantt files at the same time
- Fixed errors when saving a XLGantt file using 'Save as'
Version 2.0.0 includes following features :
- Gantt chart displays planned %Work Complete and Resource
- Gantt chart Daily / Weekly / Monthly view
- Gantt chart Zoom
- You can set the First day of week
- Improvement of calculation method of nonworking days
"Open Deliverables Folder" menu - "Add to MS Outlook Task" menu
That was useful. Thx
Run-time error '91':
Object variable or bloch variable "With" has not been defined
Hi.
I'm sorry for the error.
If you have any errors while using the program XLGantt(Excel Gantt), please let us know the following information when you comment or mail.
1. Windows version in use: Windows7, Windows 10, etc.
2. System type: 64-bit operating system or 32-bit operating system
3. Microsoft Office (Excel) version: Office (Excel) 2007, 2010, 2013, 2016 etc.
4. Error : Le me know the error message and error code when the error occurs, and let me know what data you entered when using the XLGantt.
5. File with errors: If possible, please delete the important contents and send the errored file to admin@xlworks.net.
Thank you,
xlworks admin
The column width is too small for date cells, on my excel, it displays #########
win7 64bit
excel 2013
Hi.
If the column width is too small for date cells, you can select the column and increase the column width. This is the same as increasing columns in Excel.
See the link below for instructions.
https://www.dummies.com/software/microsoft-office/excel/how-to-change-column-width-and-row-height-in-excel-2007/
Thank you.
Pingback: XLGantt(Excel Gantt) Task input, schedule update - XLWorks
Pingback: Getting Started With XLGantt - XLWorks
Pingback: XLGantt(Excel Gantt) How to #3 - Setting Gantt chart display styles - XLWorks
Is there a plan to add milestone feature
Hi!
Milestone feature will be added in the next version.
The next version will be released on the last day of July 2020.
Thank you.
Today, I released version 4.0.0 by adding milestone feature. Download version 4.0.0 from the link above.