{"id":21351,"date":"2025-05-19T00:04:47","date_gmt":"2025-05-18T15:04:47","guid":{"rendered":"https:\/\/xlworks.net\/?p=21351"},"modified":"2025-05-19T00:04:53","modified_gmt":"2025-05-18T15:04:53","slug":"xlgantt-howto-05-analysis-report","status":"publish","type":"post","link":"https:\/\/xlworks.net\/en\/xlgantt-howto-05-analysis-report\/","title":{"rendered":"Excel Gantt Chart - How to #5 \u2013 Analysis Report"},"content":{"rendered":"<p>XLGantt(Excel Gantt) provides you with analysis reports to help you keep track of your project.<\/p>\n<p>When you click the buttons in the ribbon menu&gt; XLGantt &gt; Analysis Group, reports are created and several features are provided as follows.<\/p>\n<p><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" data-attachment-id=\"21352\" data-permalink=\"https:\/\/xlworks.net\/en\/xlgantt-howto-05-analysis-report\/xlgantt_howto_05_en_01-2\/\" data-orig-file=\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_05_en_01.png?fit=436%2C132&amp;ssl=1\" data-orig-size=\"436,132\" 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=\"xlgantt_howto_05_en_01\" data-image-description=\"\" data-image-caption=\"\" data-medium-file=\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_05_en_01.png?fit=300%2C91&amp;ssl=1\" data-large-file=\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_05_en_01.png?fit=436%2C132&amp;ssl=1\" class=\"alignnone wp-image-21352 size-full\" src=\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_05_en_01.png?resize=436%2C132&#038;ssl=1\" alt=\"XLGantt(Excel Gantt) ribbon menu\" width=\"436\" height=\"132\" srcset=\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_05_en_01.png?w=436&amp;ssl=1 436w, https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_05_en_01.png?resize=300%2C91&amp;ssl=1 300w, https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_05_en_01.png?resize=150%2C45&amp;ssl=1 150w, https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_05_en_01.png?resize=210%2C64&amp;ssl=1 210w\" sizes=\"auto, (max-width: 436px) 100vw, 436px\" \/><\/p>\n<p>&nbsp;<\/p>\n<h3>1. Progresses by Resources<\/h3>\n<p>It shows you the total workloads, planned workloads, progresses(%Work complete), etc.<\/p>\n<ul>\n<li>When \"by Resource Allocation Ratio\" is selected in the \"Workload Calculation\" option \u2013 If you enter resources in the form of \"John[50%], Elsa\" in the resource field of the Schedule sheet, XLGantt calculates the workloads according to the percentage of the allocated resources.<\/li>\n<li>When \"by Weight\" is selected in the \"Workload Calculation\" option \u2013 If you allocate multiple resources to one task, XLGantt calculates the workload assigned to one person by dividing the workloads by the number of people. For example, if you assign 3 people with a 9 Man\/Day workload, XLGantt calculates that each person has 3 man\/day allocated.<\/li>\n<\/ul>\n<p>If a task has not been assigned to the person in charge, it is displayed as \"(Resources unspecified)\".<\/p>\n<h4>1) Progresses by Resources<\/h4>\n<p><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" data-attachment-id=\"21354\" data-permalink=\"https:\/\/xlworks.net\/en\/xlgantt-howto-05-analysis-report\/xlgantt_howto_05_en_02-2\/\" data-orig-file=\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_05_en_02.png?fit=860%2C522&amp;ssl=1\" data-orig-size=\"860,522\" 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=\"xlgantt_howto_05_en_02\" data-image-description=\"\" data-image-caption=\"\" data-medium-file=\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_05_en_02.png?fit=300%2C182&amp;ssl=1\" data-large-file=\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_05_en_02.png?fit=860%2C522&amp;ssl=1\" class=\"alignnone wp-image-21354 size-full\" src=\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_05_en_02.png?resize=860%2C522&#038;ssl=1\" alt=\"Progresses by Resources\" width=\"860\" height=\"522\" srcset=\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_05_en_02.png?w=860&amp;ssl=1 860w, https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_05_en_02.png?resize=300%2C182&amp;ssl=1 300w, https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_05_en_02.png?resize=150%2C91&amp;ssl=1 150w, https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_05_en_02.png?resize=768%2C466&amp;ssl=1 768w, https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_05_en_02.png?resize=210%2C127&amp;ssl=1 210w\" sizes=\"auto, (max-width: 860px) 100vw, 860px\" \/><\/p>\n<p>&nbsp;<\/p>\n<h4>2) Subtotals<\/h4>\n<p>Click on the number of the subtotal level in the upper left corner to see subtotals.<\/p>\n<p><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" data-attachment-id=\"21356\" data-permalink=\"https:\/\/xlworks.net\/en\/xlgantt-howto-05-analysis-report\/xlgantt_howto_05_en_03-2\/\" data-orig-file=\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_05_en_03.png?fit=856%2C312&amp;ssl=1\" data-orig-size=\"856,312\" 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=\"xlgantt_howto_05_en_03\" data-image-description=\"\" data-image-caption=\"\" data-medium-file=\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_05_en_03.png?fit=300%2C109&amp;ssl=1\" data-large-file=\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_05_en_03.png?fit=856%2C312&amp;ssl=1\" class=\"alignnone wp-image-21356 size-full\" src=\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_05_en_03.png?resize=856%2C312&#038;ssl=1\" alt=\"Subtotals\" width=\"856\" height=\"312\" srcset=\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_05_en_03.png?w=856&amp;ssl=1 856w, https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_05_en_03.png?resize=300%2C109&amp;ssl=1 300w, https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_05_en_03.png?resize=150%2C55&amp;ssl=1 150w, https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_05_en_03.png?resize=768%2C280&amp;ssl=1 768w, https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_05_en_03.png?resize=210%2C77&amp;ssl=1 210w\" sizes=\"auto, (max-width: 856px) 100vw, 856px\" \/><\/p>\n<p>&nbsp;<\/p>\n<h3>2. Workloads (by weeks, months, Resources)<\/h3>\n<p>When you click \"Workloads by Weeks\", \"Workloads by Months\", \"Workloads by Resources\" in the ribbon menu, XLGantt displays the Workloads by charts.<\/p>\n<p>Man-Month is one person's working time for a month<\/p>\n<p>The working days are usually 21, but it can be changed to 20 days, 22 days, etc., and Man-Month is calculated and displayed based on the changed working days.<\/p>\n<h4>1) Workloads by Weeks<\/h4>\n<p><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" data-attachment-id=\"21358\" data-permalink=\"https:\/\/xlworks.net\/en\/xlgantt-howto-05-analysis-report\/xlgantt_howto_05_en_04-2\/\" data-orig-file=\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_05_en_04.png?fit=617%2C407&amp;ssl=1\" data-orig-size=\"617,407\" 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=\"xlgantt_howto_05_en_04\" data-image-description=\"\" data-image-caption=\"\" data-medium-file=\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_05_en_04.png?fit=300%2C198&amp;ssl=1\" data-large-file=\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_05_en_04.png?fit=617%2C407&amp;ssl=1\" class=\"alignnone wp-image-21358 size-full\" src=\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_05_en_04.png?resize=617%2C407&#038;ssl=1\" alt=\"Workloads by weeks\" width=\"617\" height=\"407\" srcset=\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_05_en_04.png?w=617&amp;ssl=1 617w, https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_05_en_04.png?resize=300%2C198&amp;ssl=1 300w, https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_05_en_04.png?resize=150%2C99&amp;ssl=1 150w, https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_05_en_04.png?resize=210%2C140&amp;ssl=1 210w\" sizes=\"auto, (max-width: 617px) 100vw, 617px\" \/><\/p>\n<p>&nbsp;<\/p>\n<h4>2) Workloads by Months<\/h4>\n<p><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" data-attachment-id=\"21360\" data-permalink=\"https:\/\/xlworks.net\/en\/xlgantt-howto-05-analysis-report\/xlgantt_howto_05_en_05-2\/\" data-orig-file=\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_05_en_05.png?fit=615%2C224&amp;ssl=1\" data-orig-size=\"615,224\" 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=\"xlgantt_howto_05_en_05\" data-image-description=\"\" data-image-caption=\"\" data-medium-file=\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_05_en_05.png?fit=300%2C109&amp;ssl=1\" data-large-file=\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_05_en_05.png?fit=615%2C224&amp;ssl=1\" class=\"alignnone wp-image-21360 size-full\" src=\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_05_en_05.png?resize=615%2C224&#038;ssl=1\" alt=\"Workloads by Months\" width=\"615\" height=\"224\" srcset=\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_05_en_05.png?w=615&amp;ssl=1 615w, https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_05_en_05.png?resize=300%2C109&amp;ssl=1 300w, https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_05_en_05.png?resize=150%2C55&amp;ssl=1 150w, https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_05_en_05.png?resize=210%2C76&amp;ssl=1 210w\" sizes=\"auto, (max-width: 615px) 100vw, 615px\" \/><\/p>\n<p>&nbsp;<\/p>\n<h4>3) Workloads by Resources<\/h4>\n<p><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" data-attachment-id=\"21362\" data-permalink=\"https:\/\/xlworks.net\/en\/xlgantt-howto-05-analysis-report\/xlgantt_howto_05_en_08-2\/\" data-orig-file=\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_05_en_08.png?fit=607%2C293&amp;ssl=1\" data-orig-size=\"607,293\" 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=\"xlgantt_howto_05_en_08\" data-image-description=\"\" data-image-caption=\"\" data-medium-file=\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_05_en_08.png?fit=300%2C145&amp;ssl=1\" data-large-file=\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_05_en_08.png?fit=607%2C293&amp;ssl=1\" class=\"alignnone wp-image-21362 size-full\" src=\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_05_en_08.png?resize=607%2C293&#038;ssl=1\" alt=\"Workloads by Months\" width=\"607\" height=\"293\" srcset=\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_05_en_08.png?w=607&amp;ssl=1 607w, https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_05_en_08.png?resize=300%2C145&amp;ssl=1 300w, https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_05_en_08.png?resize=150%2C72&amp;ssl=1 150w, https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_05_en_08.png?resize=210%2C101&amp;ssl=1 210w\" sizes=\"auto, (max-width: 607px) 100vw, 607px\" \/><\/p>\n<p>&nbsp;<\/p>\n<h3>3. Project Progresses<\/h3>\n<p>Click \"Progress by Weeks\", \"Progress by Months\" on the ribbon to display the project progresses.<\/p>\n<h4>1) When not managing schedule changes<\/h4>\n<p>Only the \"Planned workload progress\" and \"Earned value progress\" are displayed.<\/p>\n<p><a href=\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_05_en_09.png?ssl=1\" target=\"_blank\" rel=\"noopener\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" data-attachment-id=\"21364\" data-permalink=\"https:\/\/xlworks.net\/en\/xlgantt-howto-05-analysis-report\/xlgantt_howto_05_en_09-2\/\" data-orig-file=\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_05_en_09.png?fit=1022%2C439&amp;ssl=1\" data-orig-size=\"1022,439\" 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=\"xlgantt_howto_05_en_09\" data-image-description=\"\" data-image-caption=\"\" data-medium-file=\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_05_en_09.png?fit=300%2C129&amp;ssl=1\" data-large-file=\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_05_en_09.png?fit=1022%2C439&amp;ssl=1\" class=\"alignnone wp-image-21364 size-full\" src=\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_05_en_09.png?resize=1022%2C439&#038;ssl=1\" alt=\"When not managing schedule changes\" width=\"1022\" height=\"439\" srcset=\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_05_en_09.png?w=1022&amp;ssl=1 1022w, https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_05_en_09.png?resize=300%2C129&amp;ssl=1 300w, https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_05_en_09.png?resize=150%2C64&amp;ssl=1 150w, https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_05_en_09.png?resize=768%2C330&amp;ssl=1 768w, https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_05_en_09.png?resize=210%2C90&amp;ssl=1 210w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<h4>2) When managing schedule changes<\/h4>\n<p>\"Planned workload progress\", \"Earned value progress\" and \"Actual workload progress\" are displayed.<\/p>\n<p><a href=\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_05_en_10.png?ssl=1\" target=\"_blank\" rel=\"noopener\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" data-attachment-id=\"21366\" data-permalink=\"https:\/\/xlworks.net\/en\/xlgantt-howto-05-analysis-report\/xlgantt_howto_05_en_10-2\/\" data-orig-file=\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_05_en_10.png?fit=1025%2C441&amp;ssl=1\" data-orig-size=\"1025,441\" 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=\"xlgantt_howto_05_en_10\" data-image-description=\"\" data-image-caption=\"\" data-medium-file=\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_05_en_10.png?fit=300%2C129&amp;ssl=1\" data-large-file=\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_05_en_10.png?fit=1024%2C441&amp;ssl=1\" class=\"alignnone wp-image-21366 size-full\" src=\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_05_en_10.png?resize=1025%2C441&#038;ssl=1\" alt=\"When managing schedule changes\" width=\"1025\" height=\"441\" srcset=\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_05_en_10.png?w=1025&amp;ssl=1 1025w, https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_05_en_10.png?resize=300%2C129&amp;ssl=1 300w, https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_05_en_10.png?resize=150%2C65&amp;ssl=1 150w, https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_05_en_10.png?resize=768%2C330&amp;ssl=1 768w, https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_05_en_10.png?resize=210%2C90&amp;ssl=1 210w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<h3>4. Export Workload data to the \u201cWorkload\u201d sheet<\/h3>\n<p>If you click \"Create Workload Data by Weeks\", \"Create Workload Data by Months\" in the menu, Workload data is exported to the \"Workload\" sheet.<br \/>\nUsing the \"Workload\" sheet data, you can perform analysis as desired by features such as Excel pivot.<\/p>\n<p><a href=\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_05_en_11.png?ssl=1\" target=\"_blank\" rel=\"noopener\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" data-attachment-id=\"21368\" data-permalink=\"https:\/\/xlworks.net\/en\/xlgantt-howto-05-analysis-report\/xlgantt_howto_05_en_11-2\/\" data-orig-file=\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_05_en_11.png?fit=1325%2C489&amp;ssl=1\" data-orig-size=\"1325,489\" 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=\"xlgantt_howto_05_en_11\" data-image-description=\"\" data-image-caption=\"\" data-medium-file=\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_05_en_11.png?fit=300%2C111&amp;ssl=1\" data-large-file=\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_05_en_11.png?fit=1024%2C378&amp;ssl=1\" class=\"alignnone wp-image-21368 size-full\" src=\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_05_en_11.png?resize=1325%2C489&#038;ssl=1\" alt=\"Export Workload data to the \u201cWorkload\u201d sheet\" width=\"1325\" height=\"489\" srcset=\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_05_en_11.png?w=1325&amp;ssl=1 1325w, https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_05_en_11.png?resize=300%2C111&amp;ssl=1 300w, https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_05_en_11.png?resize=1024%2C378&amp;ssl=1 1024w, https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_05_en_11.png?resize=150%2C55&amp;ssl=1 150w, https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_05_en_11.png?resize=768%2C283&amp;ssl=1 768w, https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_05_en_11.png?resize=210%2C78&amp;ssl=1 210w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><\/a><\/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>XLGantt(Excel Gantt) provides you with analysis reports to help you keep track of your project. When you click the buttons in the ribbon menu&gt; XLGantt &gt; Analysis Group, reports are created and several features are provided as follows. &nbsp; 1. Progresses by Resources It shows [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":21362,"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":[1023,1026,90,92],"class_list":["post-21351","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-xlgantt_howto","tag-excel-gantt-en","tag-analysis","tag--en","tag-xlgantt-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 #5 \u2013 Analysis Report - 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-05-analysis-report\/\" \/>\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=\"2 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-05-analysis-report\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/xlworks.net\/en\/xlgantt-howto-05-analysis-report\/\"},\"author\":{\"name\":\"Admin\",\"@id\":\"https:\/\/xlworks.net\/en\/#\/schema\/person\/a1811d47aca1af1770b05a0a0938f33a\"},\"headline\":\"Excel Gantt Chart - How to #5 \u2013 Analysis Report\",\"datePublished\":\"2025-05-18T15:04:47+00:00\",\"dateModified\":\"2025-05-18T15:04:53+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/xlworks.net\/en\/xlgantt-howto-05-analysis-report\/\"},\"wordCount\":398,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/xlworks.net\/en\/#organization\"},\"image\":{\"@id\":\"https:\/\/xlworks.net\/en\/xlgantt-howto-05-analysis-report\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_05_en_08.png?fit=607%2C293&ssl=1\",\"keywords\":[\"excel gantt\",\"analysis\",\"\uc5d1\uc140\uac04\ud2b8\",\"xlgantt\"],\"articleSection\":[\"Using Excel Gantt\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/xlworks.net\/en\/xlgantt-howto-05-analysis-report\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/xlworks.net\/en\/xlgantt-howto-05-analysis-report\/\",\"url\":\"https:\/\/xlworks.net\/en\/xlgantt-howto-05-analysis-report\/\",\"name\":\"Excel Gantt Chart - How to #5 \u2013 Analysis Report - XLWorks\",\"isPartOf\":{\"@id\":\"https:\/\/xlworks.net\/en\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/xlworks.net\/en\/xlgantt-howto-05-analysis-report\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/xlworks.net\/en\/xlgantt-howto-05-analysis-report\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_05_en_08.png?fit=607%2C293&ssl=1\",\"datePublished\":\"2025-05-18T15:04:47+00:00\",\"dateModified\":\"2025-05-18T15:04:53+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/xlworks.net\/en\/xlgantt-howto-05-analysis-report\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/xlworks.net\/en\/xlgantt-howto-05-analysis-report\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/xlworks.net\/en\/xlgantt-howto-05-analysis-report\/#primaryimage\",\"url\":\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_05_en_08.png?fit=607%2C293&ssl=1\",\"contentUrl\":\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_05_en_08.png?fit=607%2C293&ssl=1\",\"width\":607,\"height\":293,\"caption\":\"XLGantt Analysis Report\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/xlworks.net\/en\/xlgantt-howto-05-analysis-report\/#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 #5 \u2013 Analysis Report\"}]},{\"@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 #5 \u2013 Analysis Report - 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-05-analysis-report\/","twitter_misc":{"Written by":"Admin","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/xlworks.net\/en\/xlgantt-howto-05-analysis-report\/#article","isPartOf":{"@id":"https:\/\/xlworks.net\/en\/xlgantt-howto-05-analysis-report\/"},"author":{"name":"Admin","@id":"https:\/\/xlworks.net\/en\/#\/schema\/person\/a1811d47aca1af1770b05a0a0938f33a"},"headline":"Excel Gantt Chart - How to #5 \u2013 Analysis Report","datePublished":"2025-05-18T15:04:47+00:00","dateModified":"2025-05-18T15:04:53+00:00","mainEntityOfPage":{"@id":"https:\/\/xlworks.net\/en\/xlgantt-howto-05-analysis-report\/"},"wordCount":398,"commentCount":0,"publisher":{"@id":"https:\/\/xlworks.net\/en\/#organization"},"image":{"@id":"https:\/\/xlworks.net\/en\/xlgantt-howto-05-analysis-report\/#primaryimage"},"thumbnailUrl":"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_05_en_08.png?fit=607%2C293&ssl=1","keywords":["excel gantt","analysis","\uc5d1\uc140\uac04\ud2b8","xlgantt"],"articleSection":["Using Excel Gantt"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/xlworks.net\/en\/xlgantt-howto-05-analysis-report\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/xlworks.net\/en\/xlgantt-howto-05-analysis-report\/","url":"https:\/\/xlworks.net\/en\/xlgantt-howto-05-analysis-report\/","name":"Excel Gantt Chart - How to #5 \u2013 Analysis Report - XLWorks","isPartOf":{"@id":"https:\/\/xlworks.net\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/xlworks.net\/en\/xlgantt-howto-05-analysis-report\/#primaryimage"},"image":{"@id":"https:\/\/xlworks.net\/en\/xlgantt-howto-05-analysis-report\/#primaryimage"},"thumbnailUrl":"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_05_en_08.png?fit=607%2C293&ssl=1","datePublished":"2025-05-18T15:04:47+00:00","dateModified":"2025-05-18T15:04:53+00:00","breadcrumb":{"@id":"https:\/\/xlworks.net\/en\/xlgantt-howto-05-analysis-report\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/xlworks.net\/en\/xlgantt-howto-05-analysis-report\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/xlworks.net\/en\/xlgantt-howto-05-analysis-report\/#primaryimage","url":"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_05_en_08.png?fit=607%2C293&ssl=1","contentUrl":"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_05_en_08.png?fit=607%2C293&ssl=1","width":607,"height":293,"caption":"XLGantt Analysis Report"},{"@type":"BreadcrumbList","@id":"https:\/\/xlworks.net\/en\/xlgantt-howto-05-analysis-report\/#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 #5 \u2013 Analysis Report"}]},{"@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_05_en_08.png?fit=607%2C293&ssl=1","jetpack_shortlink":"https:\/\/wp.me\/p7qvkj-5yn","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/xlworks.net\/en\/wp-json\/wp\/v2\/posts\/21351","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=21351"}],"version-history":[{"count":2,"href":"https:\/\/xlworks.net\/en\/wp-json\/wp\/v2\/posts\/21351\/revisions"}],"predecessor-version":[{"id":21570,"href":"https:\/\/xlworks.net\/en\/wp-json\/wp\/v2\/posts\/21351\/revisions\/21570"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/xlworks.net\/en\/wp-json\/wp\/v2\/media\/21362"}],"wp:attachment":[{"href":"https:\/\/xlworks.net\/en\/wp-json\/wp\/v2\/media?parent=21351"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/xlworks.net\/en\/wp-json\/wp\/v2\/categories?post=21351"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/xlworks.net\/en\/wp-json\/wp\/v2\/tags?post=21351"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}