{"id":21048,"date":"2025-05-10T21:25:07","date_gmt":"2025-05-10T12:25:07","guid":{"rendered":"https:\/\/xlworks.net\/?p=21048"},"modified":"2025-05-18T01:43:46","modified_gmt":"2025-05-17T16:43:46","slug":"xlgantt-project-scheduler","status":"publish","type":"post","link":"https:\/\/xlworks.net\/en\/xlgantt-project-scheduler\/","title":{"rendered":"Excel WBS and Gantt Chart - XLGantt(ver 5.0.0) June 5, 2022 Release"},"content":{"rendered":"

What is XLGantt(Excel Gantt)?<\/h2>\n

XLGantt is a program designed to enable project scheduling in Microsoft Excel. It is composed of the following features. You don\u2019t need to install this program because it is an Excel macro file.<\/p>\n

Main Sheet<\/h3>\n

The schedule sheet is the main sheet and is composed as follows.<\/p>\n

\"XLGantt<\/p>\n

    \n
  1. Ribbon Menu for Excel Gantt<\/strong>: After entering a task and schedule, you can calculate and analyze the workload.<\/li>\n
  2. Project information<\/strong>: Project name, project period, plan\/Actual progress display area.<\/li>\n
  3. Group<\/strong>: Grouping rows.<\/li>\n
  4. WBS<\/strong>: Area for entering task name, start\/finish date, resources, deliverables,\u00a0 %work complete, etc.<\/li>\n
  5. Gantt Chart<\/strong>: Gantt chart is displayed based on the data entered in WBS.<\/li>\n<\/ol>\n

    Other sheets<\/h3>\n
    \n\n\n\n\n\n\n\n\n
    Schedule<\/strong><\/td>\nWhen you enter a task and a schedule, the progress rate is calculated and the schedule of the task is displayed as a Gantt chart.<\/td>\n<\/tr>\n
    Progress<\/strong><\/td>\n\u00a0Shows you the workloads, progresses, etc.<\/td>\n<\/tr>\n
    AnalysisReport<\/strong><\/td>\n\u00a0Shows you the progress and workloads of the project by weeks, months, and resources.<\/td>\n<\/tr>\n
    Calendar<\/strong><\/td>\n\u00a0Sets nonworking days.<\/td>\n<\/tr>\n
    Workload<\/strong><\/td>\nMakes workload data by weekly and monthly. You can do analysis as you want by using Excel features such as pivot.<\/td>\n<\/tr>\n
    TranslatedLanguages (Hidden sheet)<\/strong><\/td>\n\u00a0Contains language-specific translations.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/figure>\n

     <\/p>\n

    Program Updates<\/h3>\n

    XLGantt version 5.0.0 has been released (June 5, 2022 Release)<\/p>\n

    Version 5.0.0 includes the following features and bug fixes :<\/p>\n

    1. You can use formulas in date fields<\/h4>\n

    In the previous version, only date values could be entered, but in version 5.0.0, you can enter formulas that refer to other cells. This feature allows you to set task dependencies(however, multiple predecessors cannot be specified).<\/p>\n

    \"You<\/p>\n

    You can calculate the finish date by adding 3 days to the start date. Holidays are also included in the calculation because you are simply adding the durations.
    \n=P10+3<\/strong>\u00a0=> 6\/5\/2022 (Calculation of completion date including holidays)<\/p>\n

    If you want to calculate including only actual working days excluding non-working days, you can use the user-defined function GetFinishDate provided from Excel Gantt 5.0.0 version.
    \n=GetFinishDate(P10,3)<\/strong>\u00a0=> 6\/6\/2022 (Calculation of completion date excluding holidays)<\/p>\n

     <\/p>\n

    2. Setting task dependencies<\/h4>\n

    You can set dependencies between tasks.<\/p>\n

    Using the user-defined function provided from Excel Gantt 5.0.0 version, you can set the task dependencies. Once the dependencies are set, the Gantt chart shows the connecting lines between the tasks.<\/p>\n

    \"Setting<\/p>\n

    Syntax : GetWorkday(date of predecessor, [duration])
    \n=GetWorkday(Q15)<\/strong>\u00a0=> 7\/14\/2022 (Specify 'Program A' as a predecessor and calculate the start date excluding non-working days so that 'Program B' starts when 'Program A' is completed (FS:Finish-to- Start)).\u00a0In addition to FS, FF, SS, and SF can also be specified.<\/p>\n

     <\/p>\n

    Download the program file from the link below!<\/h3>\n

    After downloading, unzip and use the \"XLGantt_v5.0.0_20220605_Release_ENG.xlsm\" file.<\/p>\n

    Program Download<\/div>
    XLGantt_v5.0.0_20220605_Release_ENG.zip<\/a><\/div><\/div>\n

    XLGantt Version 5.0.0 Terms of Use<\/strong>
    \nThis \u201cProgram\" is free software developed and distributed by xlworks.net. This program is free to use anywhere, anytime including personal\/business\/government\/school.<\/p>\n

    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.<\/p>\n

    \n

    How to use XLGantt(Excel Gantt)<\/h2>\n

    \"How to\" is prepared for each feature as follows. When you click on the [View] link, the \"How to\" page opens.<\/p>\n

    1) Getting Started With XLGantt<\/h3>\n

    If you want to learn the features quickly and easily, see the \"Getting Started With XLGantt\".\u00a0[Learn more]<\/a><\/strong><\/p>\n

    2) Enter tasks, update schedule<\/h3>\n

    When you enter task names, start and finish dates, and %work complete values, XLGantt automatically calculates the duration of the tasks, planned %work complete, etc.\u00a0[Learn more]<\/a><\/p>\n

    \"XLGantt(Excel<\/p>\n

     <\/p>\n

    3) Setting Gantt chart display styles<\/h3>\n

    You can click the \"Options\" button on the ribbon to customize a Gantt chart style.\u00a0[Learn more]<\/a><\/strong><\/p>\n

    \"XLGantt(Excel<\/p>\n

     <\/p>\n

    4) Keeping track of project progress<\/h3>\n

    You can use %work complete to keep track of the progress of the project.\u00a0[Learn more]<\/a><\/strong><\/p>\n

    \"Keeping<\/p>\n

    5) Analysis Report<\/h3>\n

    Provides you with analysis reports such as progress, workload, and workload data for tracking the status of your project.\u00a0[Learn more]<\/a><\/strong><\/p>\n

    \"XLGantt(Excel<\/p>\n

    \"XLGantt(Excel<\/p>\n

     <\/p>\n

    6)\u00a0 Managing Schedule Changes<\/h3>\n

    Manages the planned schedule and actual schedule of the project.\u00a0[Learn more]<\/a><\/strong><\/p>\n

    \"XLGantt(Excel<\/p>\n

     <\/p>\n

    7) Deliverables<\/h3>\n

    Specifies the save path of the deliverables and open the deliverables.\u00a0[Learn more]<\/a><\/strong><\/p>\n

    \"XLGantt(Excel<\/p>\n

     <\/p>\n

    8) Adding Tasks to Microsoft Outlook Calendar<\/h3>\n

    Adds tasks to the Outlook calendar(You must have Microsoft Outlook installed on your PC).\u00a0[Learn more]<\/a><\/strong><\/p>\n

    \"Adding<\/p>\n

     <\/p>\n

    9) Multilingual Support<\/h3>\n

    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 \u200b\u200bare separated, it is possible to add multiple languages \u200b\u200bwithout modifying the program.\u00a0[Learn more]<\/a><\/strong><\/p>\n

    \"Excel<\/p>\n

     <\/p>\n

    10) Importing Schedules from Another File<\/h3>\n

    Imports schedules into XLGantt. You can import the schedules by mapping the fields.\u00a0[Learn more]<\/a><\/strong><\/p>\n

    \"Excel<\/p>\n

     <\/p>\n

    11) Calendar<\/h3>\n

    When you enter nonworking days, XLGantt excludes them from calculations of working time. The \"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\".\u00a0[Learn more]<\/a><\/strong><\/p>\n

    \"Excel<\/p>\n

     <\/p>\n

    12) Integration with Excel Features<\/h3>\n

    You can include the formulas and functions of Excel in XLGantt.\u00a0[Learn more]<\/a><\/strong><\/p>\n

    \"Excel<\/p>\n

     <\/p>\n

    13) Importing Server Data<\/h3>\n

    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.\u00a0[Learn more]<\/a><\/strong><\/p>\n

    \"Excel<\/p>\n

     <\/p>\n

    14) Workload calculation<\/h3>\n

    In previous versions, you could only calculate the workload by weight, but now you can calculate the workload by resource allocation ratio.\u00a0[Learn more]<\/a><\/strong><\/p>\n

    \"Excel<\/p>\n

     <\/p>\n

    15) Setting WBS Area and Color Theme<\/h3>\n

    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.\u00a0[Learn more]<\/a><\/strong><\/p>\n

    \"Excel<\/p>\n

    <\/figure>\n[ Posts related to XLGantt ]\n\n
    \n

    Program update history<\/h2>\n

    Version 4.7.0 includes the following features and bug fixes :<\/h3>\n

     <\/p>\n

      \n
    • Added 'date or day display' feature on the timescale.<\/li>\n
    • You can align the WBS column horizontally.<\/li>\n<\/ul>\n

      Version 4.5.0 includes the following features and bug fixes :<\/h3>\n
        \n
      • Added a feature to display in color when there are schedule variances<\/li>\n
      • If the actual start date is different from the planned date, the progress line of the Gantt chart is displayed in color.<\/li>\n
      • User language (Custom) definition feature that allows users to change titles, messages, etc.<\/li>\n<\/ul>\n

        Version 4.0.0 includes the following features and bug fixes :<\/h3>\n
          \n
        • Pre-specified color themes are provided and can be set by the user.<\/li>\n
        • You can mark tasks as milestones.<\/li>\n
        • In previous versions, you could only calculate the workload by weight, but now you can calculate the workload by resource allocation ratio.<\/li>\n
        • In addition, you can display the project week number and year on the Gantt chart.<\/li>\n<\/ul>\n

          Version 3.0.1 includes the following features and bug fixes :<\/h3>\n
            \n
          • Tasks can be added up to 10 levels (the previous version only supports 7 levels).<\/li>\n<\/ul>\n
              \n
            • Added a feature to view the progress graph of planned\/earned\/actual workload (weekly\/monthly).<\/li>\n
            • Data export for analysis to \u201cWorkload\u201d sheet.<\/li>\n
            • Week number display on the Gantt chart.<\/li>\n
            • Date display on the Gantt chart timescale.<\/li>\n
            • Bug fixes etc.<\/li>\n<\/ul>\n

              Version 2.1.0 includes the following features and bug fixes :<\/h3>\n
                \n
              • Group rows feature<\/li>\n
              • Fixed bugs that do not work with Excel 2007 version<\/li>\n
              • Fixed errors when opening multiple XLGantt files at the same time<\/li>\n
              • Fixed errors when saving an XLGantt file using 'Save as'<\/li>\n<\/ul>\n

                Version 2.0.0 includes the following features :<\/h3>\n
                  \n
                • Gantt chart displays planned %Work Complete and Resource<\/li>\n
                • Gantt chart Daily \/ Weekly \/ Monthly view<\/li>\n
                • Gantt chart Zoom<\/li>\n
                • You can set the First day of the week<\/li>\n
                • Improvement of calculation method of nonworking days
                  \n\"Open Deliverables Folder\" menu<\/li>\n
                • \"Add to MS Outlook Task\" menu<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"

                  What is XLGantt(Excel Gantt)? XLGantt is a program designed to enable project scheduling in Microsoft Excel. It is composed of the following features. You don\u2019t need to install this program because it is an Excel macro file. Main Sheet The schedule sheet is the main […]<\/p>\n","protected":false},"author":2,"featured_media":20981,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"default","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"default","adv-header-id-meta":"","stick-header-meta":"default","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"set","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","enabled":false},"version":2}},"categories":[1014,1025],"tags":[186,187,581,973,974,975,976,977,978,979,980,981,982,184],"class_list":["post-21048","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-xlgantt_excel_program","category-excel_program_download","tag-gantt-chart-en","tag-schedule-en","tag-project-en","tag-scheduling-en","tag-schedule-management","tag-excel-en-2","tag-project-en-2","tag-project-en-3","tag-scheduling-en-2","tag-schedule-management-tool","tag-gantt-chart-en-2","tag-wbs-en","tag-sample-en","tag-excel-en"],"yoast_head":"\nExcel WBS and Gantt Chart - XLGantt(ver 5.0.0) June 5, 2022 Release - XLWorks<\/title>\n<meta name=\"description\" content=\"XLGantt is an Excel macro program designed to manage project schedules in Microsoft Excel. You can input tasks and calculate progress, display Gantt charts, analyze project progress and resources, import schedules from other files, manage holiday calendars, etc.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/xlworks.net\/en\/xlgantt-project-scheduler\/\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/xlworks.net\/en\/xlgantt-project-scheduler\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/xlworks.net\/en\/xlgantt-project-scheduler\/\"},\"author\":{\"name\":\"Admin\",\"@id\":\"https:\/\/xlworks.net\/en\/#\/schema\/person\/a1811d47aca1af1770b05a0a0938f33a\"},\"headline\":\"Excel WBS and Gantt Chart - XLGantt(ver 5.0.0) June 5, 2022 Release\",\"datePublished\":\"2025-05-10T12:25:07+00:00\",\"dateModified\":\"2025-05-17T16:43:46+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/xlworks.net\/en\/xlgantt-project-scheduler\/\"},\"wordCount\":1283,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/xlworks.net\/en\/#organization\"},\"image\":{\"@id\":\"https:\/\/xlworks.net\/en\/xlgantt-project-scheduler\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_06_en_05.png?fit=503%2C387&ssl=1\",\"keywords\":[\"gantt chart\",\"schedule\",\"project\",\"scheduling\",\"Schedule Management\",\"Excel\",\"Project\",\"project\",\"Scheduling\",\"Schedule Management Tool\",\"Gantt Chart\",\"wbs\",\"sample\",\"excel\"],\"articleSection\":[\"Excel Gantt\",\"Excel Program Download\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/xlworks.net\/en\/xlgantt-project-scheduler\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/xlworks.net\/en\/xlgantt-project-scheduler\/\",\"url\":\"https:\/\/xlworks.net\/en\/xlgantt-project-scheduler\/\",\"name\":\"Excel WBS and Gantt Chart - XLGantt(ver 5.0.0) June 5, 2022 Release - XLWorks\",\"isPartOf\":{\"@id\":\"https:\/\/xlworks.net\/en\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/xlworks.net\/en\/xlgantt-project-scheduler\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/xlworks.net\/en\/xlgantt-project-scheduler\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_06_en_05.png?fit=503%2C387&ssl=1\",\"datePublished\":\"2025-05-10T12:25:07+00:00\",\"dateModified\":\"2025-05-17T16:43:46+00:00\",\"description\":\"XLGantt is an Excel macro program designed to manage project schedules in Microsoft Excel. You can input tasks and calculate progress, display Gantt charts, analyze project progress and resources, import schedules from other files, manage holiday calendars, etc.\",\"breadcrumb\":{\"@id\":\"https:\/\/xlworks.net\/en\/xlgantt-project-scheduler\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/xlworks.net\/en\/xlgantt-project-scheduler\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/xlworks.net\/en\/xlgantt-project-scheduler\/#primaryimage\",\"url\":\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_06_en_05.png?fit=503%2C387&ssl=1\",\"contentUrl\":\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_06_en_05.png?fit=503%2C387&ssl=1\",\"width\":503,\"height\":387},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/xlworks.net\/en\/xlgantt-project-scheduler\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Excel Program\",\"item\":\"https:\/\/xlworks.net\/en\/category\/excel_program\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel Gantt\",\"item\":\"https:\/\/xlworks.net\/en\/category\/excel_program\/xlgantt_excel_program\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Excel WBS and Gantt Chart - XLGantt(ver 5.0.0) June 5, 2022 Release\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/xlworks.net\/en\/#website\",\"url\":\"https:\/\/xlworks.net\/en\/\",\"name\":\"\uc5d1\uc140\uc6cd\uc2a4\",\"description\":\"Excel Works!\",\"publisher\":{\"@id\":\"https:\/\/xlworks.net\/en\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/xlworks.net\/en\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/xlworks.net\/en\/#organization\",\"name\":\"XLWorks\",\"url\":\"https:\/\/xlworks.net\/en\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/xlworks.net\/en\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlworks_logo_new_w512.png\",\"contentUrl\":\"https:\/\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlworks_logo_new_w512.png\",\"width\":512,\"height\":512,\"caption\":\"XLWorks\"},\"image\":{\"@id\":\"https:\/\/xlworks.net\/en\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.instagram.com\/excelworks\/\",\"https:\/\/www.youtube.com\/c\/xlworks\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/xlworks.net\/en\/#\/schema\/person\/a1811d47aca1af1770b05a0a0938f33a\",\"name\":\"Admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/xlworks.net\/en\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c51b70865d63eda5b2f50ebef685a6df4b9fac341c5132ce8541d9ba61101475?s=96&d=identicon&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c51b70865d63eda5b2f50ebef685a6df4b9fac341c5132ce8541d9ba61101475?s=96&d=identicon&r=g\",\"caption\":\"Admin\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel WBS and Gantt Chart - XLGantt(ver 5.0.0) June 5, 2022 Release - XLWorks","description":"XLGantt is an Excel macro program designed to manage project schedules in Microsoft Excel. You can input tasks and calculate progress, display Gantt charts, analyze project progress and resources, import schedules from other files, manage holiday calendars, etc.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/xlworks.net\/en\/xlgantt-project-scheduler\/","twitter_misc":{"Written by":"Admin","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/xlworks.net\/en\/xlgantt-project-scheduler\/#article","isPartOf":{"@id":"https:\/\/xlworks.net\/en\/xlgantt-project-scheduler\/"},"author":{"name":"Admin","@id":"https:\/\/xlworks.net\/en\/#\/schema\/person\/a1811d47aca1af1770b05a0a0938f33a"},"headline":"Excel WBS and Gantt Chart - XLGantt(ver 5.0.0) June 5, 2022 Release","datePublished":"2025-05-10T12:25:07+00:00","dateModified":"2025-05-17T16:43:46+00:00","mainEntityOfPage":{"@id":"https:\/\/xlworks.net\/en\/xlgantt-project-scheduler\/"},"wordCount":1283,"commentCount":0,"publisher":{"@id":"https:\/\/xlworks.net\/en\/#organization"},"image":{"@id":"https:\/\/xlworks.net\/en\/xlgantt-project-scheduler\/#primaryimage"},"thumbnailUrl":"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_06_en_05.png?fit=503%2C387&ssl=1","keywords":["gantt chart","schedule","project","scheduling","Schedule Management","Excel","Project","project","Scheduling","Schedule Management Tool","Gantt Chart","wbs","sample","excel"],"articleSection":["Excel Gantt","Excel Program Download"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/xlworks.net\/en\/xlgantt-project-scheduler\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/xlworks.net\/en\/xlgantt-project-scheduler\/","url":"https:\/\/xlworks.net\/en\/xlgantt-project-scheduler\/","name":"Excel WBS and Gantt Chart - XLGantt(ver 5.0.0) June 5, 2022 Release - XLWorks","isPartOf":{"@id":"https:\/\/xlworks.net\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/xlworks.net\/en\/xlgantt-project-scheduler\/#primaryimage"},"image":{"@id":"https:\/\/xlworks.net\/en\/xlgantt-project-scheduler\/#primaryimage"},"thumbnailUrl":"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_06_en_05.png?fit=503%2C387&ssl=1","datePublished":"2025-05-10T12:25:07+00:00","dateModified":"2025-05-17T16:43:46+00:00","description":"XLGantt is an Excel macro program designed to manage project schedules in Microsoft Excel. You can input tasks and calculate progress, display Gantt charts, analyze project progress and resources, import schedules from other files, manage holiday calendars, etc.","breadcrumb":{"@id":"https:\/\/xlworks.net\/en\/xlgantt-project-scheduler\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/xlworks.net\/en\/xlgantt-project-scheduler\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/xlworks.net\/en\/xlgantt-project-scheduler\/#primaryimage","url":"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_06_en_05.png?fit=503%2C387&ssl=1","contentUrl":"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_06_en_05.png?fit=503%2C387&ssl=1","width":503,"height":387},{"@type":"BreadcrumbList","@id":"https:\/\/xlworks.net\/en\/xlgantt-project-scheduler\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Excel Program","item":"https:\/\/xlworks.net\/en\/category\/excel_program\/"},{"@type":"ListItem","position":2,"name":"Excel Gantt","item":"https:\/\/xlworks.net\/en\/category\/excel_program\/xlgantt_excel_program\/"},{"@type":"ListItem","position":3,"name":"Excel WBS and Gantt Chart - XLGantt(ver 5.0.0) June 5, 2022 Release"}]},{"@type":"WebSite","@id":"https:\/\/xlworks.net\/en\/#website","url":"https:\/\/xlworks.net\/en\/","name":"\uc5d1\uc140\uc6cd\uc2a4","description":"Excel Works!","publisher":{"@id":"https:\/\/xlworks.net\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/xlworks.net\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/xlworks.net\/en\/#organization","name":"XLWorks","url":"https:\/\/xlworks.net\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/xlworks.net\/en\/#\/schema\/logo\/image\/","url":"https:\/\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlworks_logo_new_w512.png","contentUrl":"https:\/\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlworks_logo_new_w512.png","width":512,"height":512,"caption":"XLWorks"},"image":{"@id":"https:\/\/xlworks.net\/en\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.instagram.com\/excelworks\/","https:\/\/www.youtube.com\/c\/xlworks"]},{"@type":"Person","@id":"https:\/\/xlworks.net\/en\/#\/schema\/person\/a1811d47aca1af1770b05a0a0938f33a","name":"Admin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/xlworks.net\/en\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c51b70865d63eda5b2f50ebef685a6df4b9fac341c5132ce8541d9ba61101475?s=96&d=identicon&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c51b70865d63eda5b2f50ebef685a6df4b9fac341c5132ce8541d9ba61101475?s=96&d=identicon&r=g","caption":"Admin"}}]}},"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_06_en_05.png?fit=503%2C387&ssl=1","jetpack_shortlink":"https:\/\/wp.me\/p7qvkj-5tu","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/xlworks.net\/en\/wp-json\/wp\/v2\/posts\/21048","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/xlworks.net\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/xlworks.net\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/xlworks.net\/en\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/xlworks.net\/en\/wp-json\/wp\/v2\/comments?post=21048"}],"version-history":[{"count":6,"href":"https:\/\/xlworks.net\/en\/wp-json\/wp\/v2\/posts\/21048\/revisions"}],"predecessor-version":[{"id":21379,"href":"https:\/\/xlworks.net\/en\/wp-json\/wp\/v2\/posts\/21048\/revisions\/21379"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/xlworks.net\/en\/wp-json\/wp\/v2\/media\/20981"}],"wp:attachment":[{"href":"https:\/\/xlworks.net\/en\/wp-json\/wp\/v2\/media?parent=21048"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/xlworks.net\/en\/wp-json\/wp\/v2\/categories?post=21048"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/xlworks.net\/en\/wp-json\/wp\/v2\/tags?post=21048"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}