Home > Excel Program > XLGantt > XLGantt(Excel Gantt) Chart and WBS (ver 4.5.0) 1/2/2021. Release

XLGantt(Excel Gantt) Chart and WBS (ver 4.5.0) 1/2/2021. Release

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.

  1. Ribbon Menu for Excel Gantt : After entering a task and schedule, you can calculate and analyze the workload.
  2. Project information : Project name, project period, plan/Actual progress display area.
  3. Group : Grouping rows.
  4. WBS : Area for entering task name, start/finish date, resources, deliverables,  %work complete, etc.
  5. 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

XLGantt(Excel Gantt) Chart and WBS (ver 4.5.0) 1/2/2021. Release

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.

XLGantt(Excel Gantt) Chart and WBS (ver 4.5.0) 1/2/2021. Release

 

2. If the actual start date is different from the planned date, the progress line of the Gantt chart is displayed in color.

XLGantt(Excel Gantt) Chart and WBS (ver 4.5.0) 1/2/2021. Release

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.

XLGantt(Excel Gantt) Chart and WBS (ver 4.5.0) 1/2/2021. Release

 

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.

XLGantt(Excel Gantt) Chart and WBS (ver 4.5.0) 1/2/2021. Release

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".

XLGantt(Excel Gantt) Chart and WBS (ver 4.5.0) 1/2/2021. Release

XLGantt(Excel Gantt) Chart and WBS (ver 4.5.0) 1/2/2021. Release

3) If you choose “Custom” as the language in the XLGantt ribbon menu> Options> Language menu,

XLGantt(Excel Gantt) Chart and WBS (ver 4.5.0) 1/2/2021. Release

the title is changed to the changed value.

XLGantt(Excel Gantt) Chart and WBS (ver 4.5.0) 1/2/2021. Release

 

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]

XLGantt(Excel Gantt) Chart and WBS (ver 4.5.0) 1/2/2021. Release

 

3) Setting Gantt chart display styles

You can click the "Options" button on the ribbon to customize a Gantt chart style. [Learn more]

XLGantt(Excel Gantt) Chart and WBS (ver 4.5.0) 1/2/2021. Release

 

4) Keeping track of project progress

You can use %work complete to keep track of the progress of the project. [Learn more]

XLGantt(Excel Gantt) How to – Keeping track the progress of the project

 

5) Analysis Report

Provides you with analysis reports such as progress, workload, and workload data for tracking the status of your project. [Learn more]

XLGantt(Excel Gantt) Chart and WBS (ver 4.5.0) 1/2/2021. Release

XLGantt(Excel Gantt) Chart and WBS (ver 4.5.0) 1/2/2021. Release

 

6)  Managing Schedule Changes

Manages the planned schedule and actual schedule of the project. [Learn more]

XLGantt(Excel Gantt) Chart and WBS (ver 4.5.0) 1/2/2021. Release

 

 

7) Deliverables

Specifies the save path of the deliverables and open the deliverables. [Learn more]

XLGantt(Excel Gantt) Chart and WBS (ver 4.5.0) 1/2/2021. Release

 

8) Adding Tasks to Microsoft Outlook Calendar

Adds tasks to the Outlook calendar(You must have Microsoft Outlook installed on your PC). [Learn more]

XLGantt(Excel Gantt) Chart and WBS (ver 4.5.0) 1/2/2021. Release

 

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]

XLGantt(Excel Gantt) Chart and WBS (ver 4.5.0) 1/2/2021. Release

 

10) Importing Schedules from Another File

Imports schedules into XLGantt. You can import the schedules by mapping the fields. [Learn more]

XLGantt(Excel Gantt) Chart and WBS (ver 4.5.0) 1/2/2021. Release

 

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]

XLGantt(Excel Gantt) Chart and WBS (ver 4.5.0) 1/2/2021. Release

 

12) Integration with Excel Features

You can include the formulas and functions of the Excel in XLGantt. [Learn more]

XLGantt(Excel Gantt) Chart and WBS (ver 4.5.0) 1/2/2021. Release

 

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]

XLGantt(Excel Gantt) Chart and WBS (ver 4.5.0) 1/2/2021. Release

 

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]

XLGantt(Excel Gantt) Chart and WBS (ver 4.5.0) 1/2/2021. Release

 

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]

XLGantt(Excel Gantt) Chart and WBS (ver 4.5.0) 1/2/2021. Release

 

[ Posts related to 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).
    Excel gantt task level

 

  • Added a feature to view the progress graph of planned / earned / actual workload (weekly / monthly).
    Excel Gantt EVM
  • 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

11 thoughts on “XLGantt(Excel Gantt) Chart and WBS (ver 4.5.0) 1/2/2021. Release”

    1. 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

  1. The column width is too small for date cells, on my excel, it displays #########
    win7 64bit
    excel 2013

  2. Pingback: XLGantt(Excel Gantt) Task input, schedule update - XLWorks

  3. Pingback: Getting Started With XLGantt - XLWorks

  4. Pingback: XLGantt(Excel Gantt) How to #3 - Setting Gantt chart display styles - XLWorks

    1. 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.

    2. Today, I released version 4.0.0 by adding milestone feature. Download version 4.0.0 from the link above.

Leave a Reply

Your email address will not be published.