XLGantt for Google Sheets™ XLGantt (pronounced “Excel Gantt”) for Google Sheets™ is a Google Sheets™ editor add-on that helps you create and manage project schedules directly in Google Sheets™. With XLGantt, you can enter tasks, start and finish dates, resources, deliverables, and progress values, then […]
XLGantt for Google Sheets™ Read More »
In this chapter, you will learn how to set the appearance and color of the XLGantt (Excel Gantt) "Schedule" sheet. 1. Schedule sheet The “Schedule” sheet in XLGantt looks like the following illustration. You can set the display style and color in the options.
Excel Gantt Chart - How to #15 – Setting WBS Area and Color Theme Read More »
Let's take a look at how to calculate the workload when scheduling a project. As shown below, if the start date of the “Design database” task is July 22 and the finish date is July 31, the working days(excluding nonworking days) are 8. ※
Excel Gantt Chart - How to #14 – Workload calculation Read More »
You can use this feature when you want to see the schedule management data of the IT system running on the server on your PC. After exporting the schedule management data to the ServerData sheet of the XLGantt file in the Server, download and open
Excel Gantt Chart - How to #13 – Importing Server Data Read More »
You can include the formulas and functions of Excel in XLGantt. 1. Display project information using functions provided by XLGantt You can add rows above the title and use the functions provided by XLGantt to display the project start date, etc. at the range you
Excel Gantt Chart - How to #12 – Integration with Excel Features Read More »
XLGantt(Excel Gantt) provides the features to set nonworking days and to set the first day of the week. On the XLGantt tab in the ribbon, click the "Options" button and then Choose the "Calendar" tab to set options. 1. Set nonworking days If you
Excel Gantt Chart - How to #11 – Calendar Read More »
XLGantt(Excel Gantt) provides a feature to import a schedule file which is created in Microsoft Excel or XLGantt. To import the schedule, click the "Import" button on the ribbon menu as shown below. 1. Import files created in XLGantt. You can import schedules created
Excel Gantt Chart - How to #10 – Importing Schedules Read More »
Currently, we support only English and Korean as user interface(UI) languages 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. 1. Choose a language Depending on the language
Excel Gantt Chart - How to #9 - Multilingual Support Read More »
XLGantt(Excel Gantt) provides a feature to add a task entered in a Schedule sheet as a task or an appointment to Microsoft Outlook (Microsoft Outlook must be installed on your PC). 1. Add tasks to Microsoft Outlook Task As shown in the illustration below, let's
Excel Gantt Chart - How to #8 - Adding Tasks to Microsoft Outlook Calendar Read More »
Excel Gantt provides the feature to set the save path (folder location) of the deliverables and open the deliverables from the Schedule sheet. 1. Setting the deliverables saving path On the XLGantt tab in the ribbon, click the "Options" button. Choose one of the following
Excel Gantt Chart - How to #7 – Deliverables Read More »
