{"id":21304,"date":"2025-05-19T00:04:25","date_gmt":"2025-05-18T15:04:25","guid":{"rendered":"https:\/\/xlworks.net\/?p=21304"},"modified":"2025-05-19T00:04:25","modified_gmt":"2025-05-18T15:04:25","slug":"xlgantt-howto-04-project-progress","status":"publish","type":"post","link":"https:\/\/xlworks.net\/en\/xlgantt-howto-04-project-progress\/","title":{"rendered":"Excel Gantt Chart - How to #4 \u2013 Keeping track the progress of the project"},"content":{"rendered":"<p>You can use \"%work complete(progress)\" to keep track of the progress of the project. Let's look at how XLGantt(Excel Gantt) manages and tracks the progress of the project.<\/p>\n<p>To track the \"%work complete\" of individual tasks, see <a href=\"https:\/\/xlworks.net\/en\/xlgantt-howto-2-input-task-update-schedule\/\" target=\"_blank\" rel=\"noopener noreferrer\">\"XLGantt(Excel Gantt) How to #2 \u2013 Input task, Update schedule\"<\/a><\/p>\n<p>&nbsp;<\/p>\n<h3>1. Concept of \"%work complete\" to track project progress.<\/h3>\n<p>To track the overall progress of a project, we use the following two indicators a lot.<\/p>\n<h4 style=\"text-align: left;\">1) Planned %work complete<\/h4>\n<p>Planned %work complete to the current date. Calculate with the following formula.<\/p>\n<p style=\"padding-left: 40px;\"><strong><span style=\"color: #800080;\">= Workloads planned to the current date\/total workloads of the project (total workloads)<\/span><\/strong><\/p>\n<p>&nbsp;<\/p>\n<h4 style=\"text-align: left;\">2)\u00a0 %Work complete<\/h4>\n<p>The actual %work complete to the current date. Calculate with the following formula.<\/p>\n<p style=\"padding-left: 40px;\"><strong><span style=\"color: #800080;\">= the actual workloads carried to the current day\/total workloads of the project (total workloads)<\/span><\/strong><\/p>\n<p>&nbsp;<\/p>\n<p><strong>* In addition, the above two indicators can be used to calculate the achievement rate.<\/strong><\/p>\n<p>It is possible to quickly determine whether a goal has been achieved(based on the current date). Calculate with the following formula.<\/p>\n<p style=\"padding-left: 40px;\"><strong><span style=\"color: #800080;\">= %Work complete\/<\/span><span style=\"color: #800080;\">Planne<\/span><span style=\"color: #800080;\">d<\/span><span style=\"color: #800080;\"> %work complete<\/span><\/strong><\/p>\n<p>&nbsp;<\/p>\n<h3>2. How to track %work complete in XLGantt<\/h3>\n<p>XLGantt automatically calculates the above indicators and can be found on the Schedule sheet and Progress sheet.<\/p>\n<h4>1) First, let's find out how to calculate the workload which is the basis of %work complete calculation.<\/h4>\n<p style=\"margin: 0in; line-height: 15pt; font-size: 12.0pt; color: black;\"><span style=\"color: #808080;\"><em>* The workload is based on Man\/Day. Man\/Day is the number of people assigned during a particular period. If 5 Man\/Day, 5 people are assigned for 1 day, or 1 person is assigned for 5 days.<\/em><\/span><\/p>\n<h6><\/h6>\n<p><strong>Since the workloads in XLGantt are added to the group task, the total workload and the planned workload are obtained as follows.<\/strong><\/p>\n<ul>\n<li>Total workload : \"Analysis\" total workload 9 + \"Design\" total workload 20 + \"Development\" total workload 27 = 56<\/li>\n<\/ul>\n<ul>\n<li>Planned workload : \"Analysis\" planned workload 9\u00a0 + \"Design\" planned workload 18 + \"Development\" planned workload 0 = 27<\/li>\n<\/ul>\n<p style=\"padding-left: 40px;\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" data-attachment-id=\"21305\" data-permalink=\"https:\/\/xlworks.net\/en\/xlgantt-howto-04-project-progress\/excel_gantt_howto_04_en_new_01-2\/\" data-orig-file=\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/excel_gantt_howto_04_en_new_01.png?fit=515%2C231&amp;ssl=1\" data-orig-size=\"515,231\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"excel_gantt_howto_04_en_new_01\" data-image-description=\"\" data-image-caption=\"\" data-medium-file=\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/excel_gantt_howto_04_en_new_01.png?fit=300%2C135&amp;ssl=1\" data-large-file=\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/excel_gantt_howto_04_en_new_01.png?fit=515%2C231&amp;ssl=1\" class=\"alignnone wp-image-21305 size-full\" src=\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/excel_gantt_howto_04_en_new_01.png?resize=515%2C231&#038;ssl=1\" alt=\"how to calculate the workload\" width=\"515\" height=\"231\" srcset=\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/excel_gantt_howto_04_en_new_01.png?w=515&amp;ssl=1 515w, https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/excel_gantt_howto_04_en_new_01.png?resize=300%2C135&amp;ssl=1 300w, https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/excel_gantt_howto_04_en_new_01.png?resize=150%2C67&amp;ssl=1 150w, https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/excel_gantt_howto_04_en_new_01.png?resize=210%2C94&amp;ssl=1 210w\" sizes=\"auto, (max-width: 515px) 100vw, 515px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><strong>The actual workload is calculated only when the \"%work complete\" is entered.<\/strong><\/p>\n<ul>\n<li>Actual workload: In the example below, three tasks were entered.<br \/>\n- The actual workload of \"Define scope\" task is 6 because the %work complete was entered as 100%.<br \/>\n- The actual workload of \"Design Database\" task is 8 because the %work complete was entered as 100%.<br \/>\n- The actual workload of \"Design UI\" is 12*80% = 9.6 since only 80% of total work was completed.<br \/>\nWhen summed up, the actual workload is 6+8+9.6 = 23.6.<\/li>\n<\/ul>\n<p style=\"padding-left: 40px;\"><a href=\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/excel_gantt_howto_04_en_new_02.png?ssl=1\" target=\"_blank\" rel=\"noopener\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" data-attachment-id=\"21307\" data-permalink=\"https:\/\/xlworks.net\/en\/xlgantt-howto-04-project-progress\/excel_gantt_howto_04_en_new_02-2\/\" data-orig-file=\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/excel_gantt_howto_04_en_new_02.png?fit=731%2C231&amp;ssl=1\" data-orig-size=\"731,231\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"excel_gantt_howto_04_en_new_02\" data-image-description=\"\" data-image-caption=\"\" data-medium-file=\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/excel_gantt_howto_04_en_new_02.png?fit=300%2C95&amp;ssl=1\" data-large-file=\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/excel_gantt_howto_04_en_new_02.png?fit=731%2C231&amp;ssl=1\" class=\"alignnone wp-image-21307 size-full\" src=\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/excel_gantt_howto_04_en_new_02.png?resize=731%2C231&#038;ssl=1\" alt=\"actual workload calculation\" width=\"731\" height=\"231\" srcset=\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/excel_gantt_howto_04_en_new_02.png?w=731&amp;ssl=1 731w, https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/excel_gantt_howto_04_en_new_02.png?resize=300%2C95&amp;ssl=1 300w, https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/excel_gantt_howto_04_en_new_02.png?resize=150%2C47&amp;ssl=1 150w, https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/excel_gantt_howto_04_en_new_02.png?resize=210%2C66&amp;ssl=1 210w\" sizes=\"auto, (max-width: 731px) 100vw, 731px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<h4>2) %Work complete calculation<\/h4>\n<p>The planned %work complete and actual %work complete are calculated in the following manner and can be found in the Schedule sheet and Progress sheet.<\/p>\n<p style=\"padding-left: 40px;\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" data-attachment-id=\"21309\" data-permalink=\"https:\/\/xlworks.net\/en\/xlgantt-howto-04-project-progress\/excel_gantt_howto_04_en_new_05-2\/\" data-orig-file=\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/excel_gantt_howto_04_en_new_05.png?fit=525%2C149&amp;ssl=1\" data-orig-size=\"525,149\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"excel_gantt_howto_04_en_new_05\" data-image-description=\"\" data-image-caption=\"\" data-medium-file=\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/excel_gantt_howto_04_en_new_05.png?fit=300%2C85&amp;ssl=1\" data-large-file=\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/excel_gantt_howto_04_en_new_05.png?fit=525%2C149&amp;ssl=1\" class=\"alignnone wp-image-21309 size-full\" src=\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/excel_gantt_howto_04_en_new_05.png?resize=525%2C149&#038;ssl=1\" alt=\"%Work complete calculation\" width=\"525\" height=\"149\" srcset=\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/excel_gantt_howto_04_en_new_05.png?w=525&amp;ssl=1 525w, https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/excel_gantt_howto_04_en_new_05.png?resize=300%2C85&amp;ssl=1 300w, https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/excel_gantt_howto_04_en_new_05.png?resize=150%2C43&amp;ssl=1 150w, https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/excel_gantt_howto_04_en_new_05.png?resize=210%2C60&amp;ssl=1 210w\" sizes=\"auto, (max-width: 525px) 100vw, 525px\" \/><\/p>\n<p>&nbsp;<\/p>\n<h5><\/h5>\n<h4>3) Display Progress<\/h4>\n<p><strong>The upper part of the Schedule sheet<\/strong><\/p>\n<p style=\"padding-left: 40px;\">After entering tasks, click \"Update Schedule\" on the ribbon. The planned progress rate and the actual progress rate are calculated and displayed at the upper part of the sheet.<\/p>\n<p style=\"padding-left: 40px;\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" data-attachment-id=\"21311\" data-permalink=\"https:\/\/xlworks.net\/en\/xlgantt-howto-04-project-progress\/excel_gantt_howto_04_en_new_04-2\/\" data-orig-file=\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/excel_gantt_howto_04_en_new_04.png?fit=378%2C127&amp;ssl=1\" data-orig-size=\"378,127\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"excel_gantt_howto_04_en_new_04\" data-image-description=\"\" data-image-caption=\"\" data-medium-file=\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/excel_gantt_howto_04_en_new_04.png?fit=300%2C101&amp;ssl=1\" data-large-file=\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/excel_gantt_howto_04_en_new_04.png?fit=378%2C127&amp;ssl=1\" class=\"alignnone wp-image-21311 size-full\" src=\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/excel_gantt_howto_04_en_new_04.png?resize=378%2C127&#038;ssl=1\" alt=\"Display Progress\" width=\"378\" height=\"127\" srcset=\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/excel_gantt_howto_04_en_new_04.png?w=378&amp;ssl=1 378w, https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/excel_gantt_howto_04_en_new_04.png?resize=300%2C101&amp;ssl=1 300w, https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/excel_gantt_howto_04_en_new_04.png?resize=150%2C50&amp;ssl=1 150w, https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/excel_gantt_howto_04_en_new_04.png?resize=210%2C71&amp;ssl=1 210w\" sizes=\"auto, (max-width: 378px) 100vw, 378px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><strong>Progress sheet<\/strong><\/p>\n<p style=\"padding-left: 30px;\">After entering tasks, click \"Update Schedule\" on the ribbon. Indicators are automatically calculated and displayed on the Progress sheet as shown below.<\/p>\n<p style=\"padding-left: 40px;\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" data-attachment-id=\"21313\" data-permalink=\"https:\/\/xlworks.net\/en\/xlgantt-howto-04-project-progress\/excel_gantt_howto_04_en_new_06-2\/\" data-orig-file=\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/excel_gantt_howto_04_en_new_06.png?fit=352%2C372&amp;ssl=1\" data-orig-size=\"352,372\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"excel_gantt_howto_04_en_new_06\" data-image-description=\"\" data-image-caption=\"\" data-medium-file=\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/excel_gantt_howto_04_en_new_06.png?fit=284%2C300&amp;ssl=1\" data-large-file=\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/excel_gantt_howto_04_en_new_06.png?fit=352%2C372&amp;ssl=1\" class=\"alignnone wp-image-21313 size-full\" src=\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/excel_gantt_howto_04_en_new_06.png?resize=352%2C372&#038;ssl=1\" alt=\"Progress sheet\" width=\"352\" height=\"372\" srcset=\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/excel_gantt_howto_04_en_new_06.png?w=352&amp;ssl=1 352w, https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/excel_gantt_howto_04_en_new_06.png?resize=284%2C300&amp;ssl=1 284w, https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/excel_gantt_howto_04_en_new_06.png?resize=142%2C150&amp;ssl=1 142w, https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/excel_gantt_howto_04_en_new_06.png?resize=132%2C140&amp;ssl=1 132w\" sizes=\"auto, (max-width: 352px) 100vw, 352px\" \/><\/p>\n<h5><\/h5>\n<p><strong>* Tip \u2013 What if you want to see progress rate in the future or past?<\/strong><\/p>\n<p>There may be times when you need to find a \"planned progress\" at a certain point in project practice. For example, today's Wednesday, and you're looking for the \"planned progress\" on the coming Friday.<\/p>\n<p style=\"padding-left: 30px;\">Set the date you want in the ribbon menu&gt; XLGantt &gt; Options&gt; General&gt; \"Calculation Base Date of Planned %Work Complete\".<br \/>\n(If you select \"Today\", it is always calculated based on the current day).<\/p>\n<p style=\"padding-left: 40px;\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" data-attachment-id=\"21315\" data-permalink=\"https:\/\/xlworks.net\/en\/xlgantt-howto-04-project-progress\/excel_gantt_howto_04_en_new_07-2\/\" data-orig-file=\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/excel_gantt_howto_04_en_new_07.png?fit=557%2C261&amp;ssl=1\" data-orig-size=\"557,261\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"excel_gantt_howto_04_en_new_07\" data-image-description=\"\" data-image-caption=\"\" data-medium-file=\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/excel_gantt_howto_04_en_new_07.png?fit=300%2C141&amp;ssl=1\" data-large-file=\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/excel_gantt_howto_04_en_new_07.png?fit=557%2C261&amp;ssl=1\" class=\"alignnone wp-image-21315 size-full\" src=\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/excel_gantt_howto_04_en_new_07.png?resize=557%2C261&#038;ssl=1\" alt=\"Calculation Base Date of Planned %Work Complete\" width=\"557\" height=\"261\" srcset=\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/excel_gantt_howto_04_en_new_07.png?w=557&amp;ssl=1 557w, https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/excel_gantt_howto_04_en_new_07.png?resize=300%2C141&amp;ssl=1 300w, https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/excel_gantt_howto_04_en_new_07.png?resize=150%2C70&amp;ssl=1 150w, https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/excel_gantt_howto_04_en_new_07.png?resize=210%2C98&amp;ssl=1 210w\" sizes=\"auto, (max-width: 557px) 100vw, 557px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p><strong>[ Using XLGantt(Excel Gantt) ]<\/strong><\/p>\n<ul>\n<li><a href=\"https:\/\/xlworks.net\/en\/xlgantt-project-scheduler\/\" target=\"_blank\" rel=\"noopener\">Excel WBS and Gantt Chart - XLGantt<\/a><\/li>\n<\/ul>\n<ul class=\"display-posts-listing\"><li class=\"listing-item\"><a class=\"title\" href=\"https:\/\/xlworks.net\/en\/xlgantt-howto-15-color-theme\/\">Excel Gantt Chart - How to #15 \u2013 Setting WBS Area and Color Theme<\/a><\/li><li class=\"listing-item\"><a class=\"title\" href=\"https:\/\/xlworks.net\/en\/xlgantt-howto-14-workloads\/\">Excel Gantt Chart - How to #14 \u2013 Workload calculation<\/a><\/li><li class=\"listing-item\"><a class=\"title\" href=\"https:\/\/xlworks.net\/en\/xlgantt-howto-13-server-data\/\">Excel Gantt Chart - How to #13 \u2013 Importing Server Data<\/a><\/li><li class=\"listing-item\"><a class=\"title\" href=\"https:\/\/xlworks.net\/en\/xlgantt-howto-12-integration-with-excel\/\">Excel Gantt Chart - How to #12 \u2013 Integration with Excel Features<\/a><\/li><li class=\"listing-item\"><a class=\"title\" href=\"https:\/\/xlworks.net\/en\/xlgantt-howto-11-calendar\/\">Excel Gantt Chart - How to #11 \u2013 Calendar<\/a><\/li><li class=\"listing-item\"><a class=\"title\" href=\"https:\/\/xlworks.net\/en\/xlgantt-howto-10-import-schedule\/\">Excel Gantt Chart - How to #10 \u2013 Importing Schedules<\/a><\/li><li class=\"listing-item\"><a class=\"title\" href=\"https:\/\/xlworks.net\/en\/xlgantt-howto-09-multilingual-support\/\">Excel Gantt Chart - How to #9 - Multilingual Support<\/a><\/li><li class=\"listing-item\"><a class=\"title\" href=\"https:\/\/xlworks.net\/en\/xlgantt-howto-08-add-tasks-to-outlook\/\">Excel Gantt Chart - How to #8 - Adding Tasks to Microsoft Outlook Calendar<\/a><\/li><li class=\"listing-item\"><a class=\"title\" href=\"https:\/\/xlworks.net\/en\/xlgantt-howto-07-deliverables\/\">Excel Gantt Chart - How to #7 \u2013 Deliverables<\/a><\/li><li class=\"listing-item\"><a class=\"title\" href=\"https:\/\/xlworks.net\/en\/xlgantt-howto-06-schedule-change-management\/\">Excel Gantt Chart - How to #6 \u2013 Managing Schedule Change<\/a><\/li><li class=\"listing-item\"><a class=\"title\" href=\"https:\/\/xlworks.net\/en\/xlgantt-howto-05-analysis-report\/\">Excel Gantt Chart - How to #5 \u2013 Analysis Report<\/a><\/li><li class=\"listing-item\"><a class=\"title\" href=\"https:\/\/xlworks.net\/en\/xlgantt-howto-04-project-progress\/\">Excel Gantt Chart - How to #4 \u2013 Keeping track the progress of the project<\/a><\/li><li class=\"listing-item\"><a class=\"title\" href=\"https:\/\/xlworks.net\/en\/xlgantt-howto-03-gantt-chart\/\">Excel Gantt Chart - How to #3 - Setting Gantt chart display styles<\/a><\/li><li class=\"listing-item\"><a class=\"title\" href=\"https:\/\/xlworks.net\/en\/xlgantt-howto-2-input-task-update-schedule\/\">Excel Gantt Chart - How to #2 - Enter tasks, Update schedule<\/a><\/li><li class=\"listing-item\"><a class=\"title\" href=\"https:\/\/xlworks.net\/en\/xlgantt-howto-1-getting-started-with-xlgantt\/\">Excel Gantt Chart - How to #1 - Getting Started With XLGantt<\/a><\/li><\/ul>\n","protected":false},"excerpt":{"rendered":"<p>You can use \"%work complete(progress)\" to keep track of the progress of the project. Let's look at how XLGantt(Excel Gantt) manages and tracks the progress of the project. To track the \"%work complete\" of individual tasks, see \"XLGantt(Excel Gantt) How to #2 \u2013 Input task, [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":21307,"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":[984],"tags":[92,1022,1023],"class_list":["post-21304","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-xlgantt_howto","tag-xlgantt-en","tag-progress","tag-excel-gantt-en"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Excel Gantt Chart - How to #4 \u2013 Keeping track the progress of the project - XLWorks<\/title>\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-howto-04-project-progress\/\" \/>\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=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/xlworks.net\/en\/xlgantt-howto-04-project-progress\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/xlworks.net\/en\/xlgantt-howto-04-project-progress\/\"},\"author\":{\"name\":\"Admin\",\"@id\":\"https:\/\/xlworks.net\/en\/#\/schema\/person\/a1811d47aca1af1770b05a0a0938f33a\"},\"headline\":\"Excel Gantt Chart - How to #4 \u2013 Keeping track the progress of the project\",\"datePublished\":\"2025-05-18T15:04:25+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/xlworks.net\/en\/xlgantt-howto-04-project-progress\/\"},\"wordCount\":588,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/xlworks.net\/en\/#organization\"},\"image\":{\"@id\":\"https:\/\/xlworks.net\/en\/xlgantt-howto-04-project-progress\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/excel_gantt_howto_04_en_new_02.png?fit=731%2C231&ssl=1\",\"keywords\":[\"xlgantt\",\"progress\",\"excel gantt\"],\"articleSection\":[\"Using Excel Gantt\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/xlworks.net\/en\/xlgantt-howto-04-project-progress\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/xlworks.net\/en\/xlgantt-howto-04-project-progress\/\",\"url\":\"https:\/\/xlworks.net\/en\/xlgantt-howto-04-project-progress\/\",\"name\":\"Excel Gantt Chart - How to #4 \u2013 Keeping track the progress of the project - XLWorks\",\"isPartOf\":{\"@id\":\"https:\/\/xlworks.net\/en\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/xlworks.net\/en\/xlgantt-howto-04-project-progress\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/xlworks.net\/en\/xlgantt-howto-04-project-progress\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/excel_gantt_howto_04_en_new_02.png?fit=731%2C231&ssl=1\",\"datePublished\":\"2025-05-18T15:04:25+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/xlworks.net\/en\/xlgantt-howto-04-project-progress\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/xlworks.net\/en\/xlgantt-howto-04-project-progress\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/xlworks.net\/en\/xlgantt-howto-04-project-progress\/#primaryimage\",\"url\":\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/excel_gantt_howto_04_en_new_02.png?fit=731%2C231&ssl=1\",\"contentUrl\":\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/excel_gantt_howto_04_en_new_02.png?fit=731%2C231&ssl=1\",\"width\":731,\"height\":231,\"caption\":\"Keeping track the progress of the project\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/xlworks.net\/en\/xlgantt-howto-04-project-progress\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Excel Program\",\"item\":\"https:\/\/xlworks.net\/en\/category\/excel_program\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Using Excel Gantt\",\"item\":\"https:\/\/xlworks.net\/en\/category\/excel_program\/xlgantt_howto\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Excel Gantt Chart - How to #4 \u2013 Keeping track the progress of the project\"}]},{\"@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 Gantt Chart - How to #4 \u2013 Keeping track the progress of the project - XLWorks","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-howto-04-project-progress\/","twitter_misc":{"Written by":"Admin","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/xlworks.net\/en\/xlgantt-howto-04-project-progress\/#article","isPartOf":{"@id":"https:\/\/xlworks.net\/en\/xlgantt-howto-04-project-progress\/"},"author":{"name":"Admin","@id":"https:\/\/xlworks.net\/en\/#\/schema\/person\/a1811d47aca1af1770b05a0a0938f33a"},"headline":"Excel Gantt Chart - How to #4 \u2013 Keeping track the progress of the project","datePublished":"2025-05-18T15:04:25+00:00","mainEntityOfPage":{"@id":"https:\/\/xlworks.net\/en\/xlgantt-howto-04-project-progress\/"},"wordCount":588,"commentCount":0,"publisher":{"@id":"https:\/\/xlworks.net\/en\/#organization"},"image":{"@id":"https:\/\/xlworks.net\/en\/xlgantt-howto-04-project-progress\/#primaryimage"},"thumbnailUrl":"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/excel_gantt_howto_04_en_new_02.png?fit=731%2C231&ssl=1","keywords":["xlgantt","progress","excel gantt"],"articleSection":["Using Excel Gantt"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/xlworks.net\/en\/xlgantt-howto-04-project-progress\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/xlworks.net\/en\/xlgantt-howto-04-project-progress\/","url":"https:\/\/xlworks.net\/en\/xlgantt-howto-04-project-progress\/","name":"Excel Gantt Chart - How to #4 \u2013 Keeping track the progress of the project - XLWorks","isPartOf":{"@id":"https:\/\/xlworks.net\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/xlworks.net\/en\/xlgantt-howto-04-project-progress\/#primaryimage"},"image":{"@id":"https:\/\/xlworks.net\/en\/xlgantt-howto-04-project-progress\/#primaryimage"},"thumbnailUrl":"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/excel_gantt_howto_04_en_new_02.png?fit=731%2C231&ssl=1","datePublished":"2025-05-18T15:04:25+00:00","breadcrumb":{"@id":"https:\/\/xlworks.net\/en\/xlgantt-howto-04-project-progress\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/xlworks.net\/en\/xlgantt-howto-04-project-progress\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/xlworks.net\/en\/xlgantt-howto-04-project-progress\/#primaryimage","url":"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/excel_gantt_howto_04_en_new_02.png?fit=731%2C231&ssl=1","contentUrl":"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/excel_gantt_howto_04_en_new_02.png?fit=731%2C231&ssl=1","width":731,"height":231,"caption":"Keeping track the progress of the project"},{"@type":"BreadcrumbList","@id":"https:\/\/xlworks.net\/en\/xlgantt-howto-04-project-progress\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Excel Program","item":"https:\/\/xlworks.net\/en\/category\/excel_program\/"},{"@type":"ListItem","position":2,"name":"Using Excel Gantt","item":"https:\/\/xlworks.net\/en\/category\/excel_program\/xlgantt_howto\/"},{"@type":"ListItem","position":3,"name":"Excel Gantt Chart - How to #4 \u2013 Keeping track the progress of the project"}]},{"@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\/excel_gantt_howto_04_en_new_02.png?fit=731%2C231&ssl=1","jetpack_shortlink":"https:\/\/wp.me\/p7qvkj-5xC","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/xlworks.net\/en\/wp-json\/wp\/v2\/posts\/21304","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=21304"}],"version-history":[{"count":5,"href":"https:\/\/xlworks.net\/en\/wp-json\/wp\/v2\/posts\/21304\/revisions"}],"predecessor-version":[{"id":21569,"href":"https:\/\/xlworks.net\/en\/wp-json\/wp\/v2\/posts\/21304\/revisions\/21569"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/xlworks.net\/en\/wp-json\/wp\/v2\/media\/21307"}],"wp:attachment":[{"href":"https:\/\/xlworks.net\/en\/wp-json\/wp\/v2\/media?parent=21304"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/xlworks.net\/en\/wp-json\/wp\/v2\/categories?post=21304"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/xlworks.net\/en\/wp-json\/wp\/v2\/tags?post=21304"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}