{"id":21482,"date":"2025-05-19T00:08:22","date_gmt":"2025-05-18T15:08:22","guid":{"rendered":"https:\/\/xlworks.net\/?p=21482"},"modified":"2025-05-19T00:08:29","modified_gmt":"2025-05-18T15:08:29","slug":"xlgantt-howto-12-integration-with-excel","status":"publish","type":"post","link":"https:\/\/xlworks.net\/en\/xlgantt-howto-12-integration-with-excel\/","title":{"rendered":"Excel Gantt Chart - How to #12 \u2013 Integration with Excel Features"},"content":{"rendered":"<p>You can include the formulas and functions of Excel in XLGantt.<\/p>\n<h2>1. Display project information using functions provided by XLGantt<\/h2>\n<p>You can add rows above the title and use the functions provided by XLGantt to display the project start date, etc. at the range you want.<\/p>\n<p><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" data-attachment-id=\"21483\" data-permalink=\"https:\/\/xlworks.net\/en\/xlgantt-howto-12-integration-with-excel\/xlgantt_howto_12_en_01-2\/\" data-orig-file=\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_12_en_01.png?fit=417%2C209&amp;ssl=1\" data-orig-size=\"417,209\" 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_12_en_01\" data-image-description=\"\" data-image-caption=\"\" data-medium-file=\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_12_en_01.png?fit=300%2C150&amp;ssl=1\" data-large-file=\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_12_en_01.png?fit=417%2C209&amp;ssl=1\" class=\"alignnone wp-image-21483 size-full\" src=\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_12_en_01.png?resize=417%2C209&#038;ssl=1\" alt=\"Display project information using functions provided by XLGantt\" width=\"417\" height=\"209\" srcset=\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_12_en_01.png?w=417&amp;ssl=1 417w, https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_12_en_01.png?resize=300%2C150&amp;ssl=1 300w, https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_12_en_01.png?resize=150%2C75&amp;ssl=1 150w, https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_12_en_01.png?resize=210%2C105&amp;ssl=1 210w\" sizes=\"auto, (max-width: 417px) 100vw, 417px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><strong>Functions provided by XLGantt<\/strong><\/p>\n<ul>\n<li>xlgantt.ProjectName(): Get project name<\/li>\n<li>xlgantt.ProjectStartDate(): Get project start date<\/li>\n<li>xlgantt.ProjectFinishDate(): Get project finish date<\/li>\n<li>xlgantt.ProjectPlanProgress(): Get planned progress of project(Planned %Work Complete)<\/li>\n<li>xlgantt.ProejctActualProgress(): Get actual progress of project(%Work Complete)<\/li>\n<li>xlgantt.ProjectProgressString(): Get project progress summary information<\/li>\n<li>xlgantt.CommentOnHeadArea(): Get comment to display at the top of the Schedule sheet<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<h2>2. Add columns and enter Excel formulas<\/h2>\n<p>You can add columns and enter formulas.<\/p>\n<p>For example, you can easily track the progress of the project by adding the SPI column as follows.<\/p>\n<p><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" data-attachment-id=\"21485\" data-permalink=\"https:\/\/xlworks.net\/en\/xlgantt-howto-12-integration-with-excel\/xlgantt_howto_12_en_02-2\/\" data-orig-file=\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_12_en_02-1.png?fit=302%2C306&amp;ssl=1\" data-orig-size=\"302,306\" 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_12_en_02\" data-image-description=\"\" data-image-caption=\"\" data-medium-file=\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_12_en_02-1.png?fit=296%2C300&amp;ssl=1\" data-large-file=\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_12_en_02-1.png?fit=302%2C306&amp;ssl=1\" class=\"alignnone wp-image-21485 size-full\" src=\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_12_en_02-1.png?resize=302%2C306&#038;ssl=1\" alt=\"Add columns and enter Excel formulas\" width=\"302\" height=\"306\" srcset=\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_12_en_02-1.png?w=302&amp;ssl=1 302w, https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_12_en_02-1.png?resize=296%2C300&amp;ssl=1 296w, https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_12_en_02-1.png?resize=148%2C150&amp;ssl=1 148w, https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_12_en_02-1.png?resize=138%2C140&amp;ssl=1 138w\" sizes=\"auto, (max-width: 302px) 100vw, 302px\" \/><\/p>\n<p>*SPI(Schedule Performance Index): The Schedule Performance Index indicates how efficiently you are actually progressing compared to the planned project schedule.<\/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 include the formulas and functions of Excel in XLGantt. 1. Display project information using functions provided by XLGantt You can add rows above the title and use the functions provided by XLGantt to display the project start date, etc. at the range you [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":21483,"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,186,1023],"class_list":["post-21482","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-xlgantt_howto","tag-xlgantt-en","tag-gantt-chart-en","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 #12 \u2013 Integration with Excel Features - 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-12-integration-with-excel\/\" \/>\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=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/xlworks.net\/en\/xlgantt-howto-12-integration-with-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/xlworks.net\/en\/xlgantt-howto-12-integration-with-excel\/\"},\"author\":{\"name\":\"Admin\",\"@id\":\"https:\/\/xlworks.net\/en\/#\/schema\/person\/a1811d47aca1af1770b05a0a0938f33a\"},\"headline\":\"Excel Gantt Chart - How to #12 \u2013 Integration with Excel Features\",\"datePublished\":\"2025-05-18T15:08:22+00:00\",\"dateModified\":\"2025-05-18T15:08:29+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/xlworks.net\/en\/xlgantt-howto-12-integration-with-excel\/\"},\"wordCount\":191,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/xlworks.net\/en\/#organization\"},\"image\":{\"@id\":\"https:\/\/xlworks.net\/en\/xlgantt-howto-12-integration-with-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_12_en_01.png?fit=417%2C209&ssl=1\",\"keywords\":[\"xlgantt\",\"gantt chart\",\"excel gantt\"],\"articleSection\":[\"Using Excel Gantt\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/xlworks.net\/en\/xlgantt-howto-12-integration-with-excel\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/xlworks.net\/en\/xlgantt-howto-12-integration-with-excel\/\",\"url\":\"https:\/\/xlworks.net\/en\/xlgantt-howto-12-integration-with-excel\/\",\"name\":\"Excel Gantt Chart - How to #12 \u2013 Integration with Excel Features - XLWorks\",\"isPartOf\":{\"@id\":\"https:\/\/xlworks.net\/en\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/xlworks.net\/en\/xlgantt-howto-12-integration-with-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/xlworks.net\/en\/xlgantt-howto-12-integration-with-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_12_en_01.png?fit=417%2C209&ssl=1\",\"datePublished\":\"2025-05-18T15:08:22+00:00\",\"dateModified\":\"2025-05-18T15:08:29+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/xlworks.net\/en\/xlgantt-howto-12-integration-with-excel\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/xlworks.net\/en\/xlgantt-howto-12-integration-with-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/xlworks.net\/en\/xlgantt-howto-12-integration-with-excel\/#primaryimage\",\"url\":\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_12_en_01.png?fit=417%2C209&ssl=1\",\"contentUrl\":\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_12_en_01.png?fit=417%2C209&ssl=1\",\"width\":417,\"height\":209,\"caption\":\"XLGantt(Excel Gantt) \u2013 Integration with Excel Features\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/xlworks.net\/en\/xlgantt-howto-12-integration-with-excel\/#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 #12 \u2013 Integration with Excel Features\"}]},{\"@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 #12 \u2013 Integration with Excel Features - 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-12-integration-with-excel\/","twitter_misc":{"Written by":"Admin","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/xlworks.net\/en\/xlgantt-howto-12-integration-with-excel\/#article","isPartOf":{"@id":"https:\/\/xlworks.net\/en\/xlgantt-howto-12-integration-with-excel\/"},"author":{"name":"Admin","@id":"https:\/\/xlworks.net\/en\/#\/schema\/person\/a1811d47aca1af1770b05a0a0938f33a"},"headline":"Excel Gantt Chart - How to #12 \u2013 Integration with Excel Features","datePublished":"2025-05-18T15:08:22+00:00","dateModified":"2025-05-18T15:08:29+00:00","mainEntityOfPage":{"@id":"https:\/\/xlworks.net\/en\/xlgantt-howto-12-integration-with-excel\/"},"wordCount":191,"commentCount":0,"publisher":{"@id":"https:\/\/xlworks.net\/en\/#organization"},"image":{"@id":"https:\/\/xlworks.net\/en\/xlgantt-howto-12-integration-with-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_12_en_01.png?fit=417%2C209&ssl=1","keywords":["xlgantt","gantt chart","excel gantt"],"articleSection":["Using Excel Gantt"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/xlworks.net\/en\/xlgantt-howto-12-integration-with-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/xlworks.net\/en\/xlgantt-howto-12-integration-with-excel\/","url":"https:\/\/xlworks.net\/en\/xlgantt-howto-12-integration-with-excel\/","name":"Excel Gantt Chart - How to #12 \u2013 Integration with Excel Features - XLWorks","isPartOf":{"@id":"https:\/\/xlworks.net\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/xlworks.net\/en\/xlgantt-howto-12-integration-with-excel\/#primaryimage"},"image":{"@id":"https:\/\/xlworks.net\/en\/xlgantt-howto-12-integration-with-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_12_en_01.png?fit=417%2C209&ssl=1","datePublished":"2025-05-18T15:08:22+00:00","dateModified":"2025-05-18T15:08:29+00:00","breadcrumb":{"@id":"https:\/\/xlworks.net\/en\/xlgantt-howto-12-integration-with-excel\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/xlworks.net\/en\/xlgantt-howto-12-integration-with-excel\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/xlworks.net\/en\/xlgantt-howto-12-integration-with-excel\/#primaryimage","url":"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_12_en_01.png?fit=417%2C209&ssl=1","contentUrl":"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_12_en_01.png?fit=417%2C209&ssl=1","width":417,"height":209,"caption":"XLGantt(Excel Gantt) \u2013 Integration with Excel Features"},{"@type":"BreadcrumbList","@id":"https:\/\/xlworks.net\/en\/xlgantt-howto-12-integration-with-excel\/#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 #12 \u2013 Integration with Excel Features"}]},{"@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_12_en_01.png?fit=417%2C209&ssl=1","jetpack_shortlink":"https:\/\/wp.me\/p7qvkj-5Au","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/xlworks.net\/en\/wp-json\/wp\/v2\/posts\/21482","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=21482"}],"version-history":[{"count":2,"href":"https:\/\/xlworks.net\/en\/wp-json\/wp\/v2\/posts\/21482\/revisions"}],"predecessor-version":[{"id":21629,"href":"https:\/\/xlworks.net\/en\/wp-json\/wp\/v2\/posts\/21482\/revisions\/21629"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/xlworks.net\/en\/wp-json\/wp\/v2\/media\/21483"}],"wp:attachment":[{"href":"https:\/\/xlworks.net\/en\/wp-json\/wp\/v2\/media?parent=21482"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/xlworks.net\/en\/wp-json\/wp\/v2\/categories?post=21482"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/xlworks.net\/en\/wp-json\/wp\/v2\/tags?post=21482"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}