XLGantt(Excel Gantt) also shows Gantt charts in the form of bar charts, and you can set various display styles in the options menu.<\/p>\n
<\/p>\n
1. Components of Gantt chart<\/h3>\n
In the XLGantt(Excel Gantt), Gantt charts are displayed on the right side of the sheet as shown below. Each component is displayed as follows.<\/p>\n
\u2460 Subtasks: Bar charts are displayed in blue. <\/p>\n Go to the ribbon menu> XLGantt tab > Options> Gantt chart > \u201cGantt Chart Display\u201d, set the Gantt chart display style.<\/p>\n <\/p>\n When you check the following items in the options, each text is displayed in the Gantt chart area.<\/p>\n <\/p>\n The illustration below shows an example of the text displayed when all checkboxes are checked.<\/p>\n <\/p>\n <\/p>\n You can set the text display position on the left, inside, and right of the bar chart.<\/p>\n <\/p>\n <\/p>\n <\/p>\n <\/p>\n <\/p>\n You can select daily, weekly or monthly views.<\/p>\n <\/p>\n <\/p>\n <\/p>\n <\/p>\n You can set the zoom ratio of the Gantt chart by using the spin button in the options. <\/p>\n <\/p>\n <\/p>\n <\/p>\n You can set the Gantt chart timescale to display the date, year, and project week.<\/p>\n <\/p>\n <\/p>\n If the zoom ratio is set to 350%, the date is displayed under the week number. <\/p>\n The project week number and week number based on 52 weeks are displayed, and the year is displayed only in the week in which the year changes. <\/p>\n If the Gantt chart does not display properly while using the XLGantt, <\/p>\n <\/p>\n [ Using XLGantt(Excel Gantt) ]<\/strong><\/p>\n A Gantt chart is a type of bar chart that illustrates a project schedule. It is used for visual representation of schedules in project management software such as Microsoft Project or Primavera. See Wikipedia for Gantt chart XLGantt(Excel Gantt) also shows Gantt charts in the […]<\/p>\n","protected":false},"author":2,"featured_media":21296,"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":[186,92],"class_list":["post-21253","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-xlgantt_howto","tag-gantt-chart-en","tag-xlgantt-en"],"yoast_head":"\n![\"Components](\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_03_en_new_08.png?resize=1013%2C228&ssl=1\")
<\/a><\/p>\n
\n\u2461 Summary tasks: Bar charts are displayed in yellow.
\n\u2462 %Work Complete: It is indicated by the solid blue line. It is easy to see how much work has been done.
\n\u2463 Today line: a vertical red line
\n\u2464 Area where the dates are displayed: Depending on the setting, the interval of the scale can be displayed in units of days, weeks, and months.<\/p>\n2. Set Gantt chart display styles<\/h3>\n
![\"Set](\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_03_en_new_01.png?resize=557%2C575&ssl=1\")
<\/a><\/p>\n1) Display text in the Gantt chart area<\/h4>\n
![\"Display](\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_03_en_new_03.png?resize=264%2C155&ssl=1\")
<\/a><\/p>\n![\"Display](\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_03_en_new_09.png?resize=1027%2C182&ssl=1\")
<\/a><\/p>\n2) Text display position of the bar chart<\/h4>\n
![\"Text](\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_03_11.png?resize=384%2C62&ssl=1\")
<\/a><\/p>\n\n
\n![\"Text](\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_03_en_new_10.png?resize=503%2C181&ssl=1\")
<\/a><\/li>\n<\/ul>\n\n
\n![\"Text](\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_03_en_new_13_inside.png?resize=421%2C214&ssl=1\")
<\/a><\/li>\n<\/ul>\n\n
\n![\"Text](\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_03_en_new_14_right.png?resize=519%2C214&ssl=1\")
<\/a><\/li>\n<\/ul>\n3) Gantt chart view styles<\/h4>\n
![\"Gantt](\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_03_16.png?resize=370%2C56&ssl=1\")
<\/a><\/p>\n\n
\n![\"Gantt](\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_03_en_new_15.png?resize=380%2C132&ssl=1\")
<\/a><\/li>\n<\/ul>\n\n
\n![\"Gantt](\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_03_en_new_17.png?resize=295%2C131&ssl=1\")
<\/a><\/li>\n<\/ul>\n\n
\n![\"Gantt](\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_03_en_new_18.png?resize=282%2C130&ssl=1\")
<\/a><\/li>\n<\/ul>\n4) Gantt Chart Zoom Ratio<\/h4>\n
\nYou can set a minimum of 10% and a maximum of 999%.<\/p>\n![\"Gantt](\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_03_17.png?resize=220%2C62&ssl=1\")
<\/a><\/p>\n\n
\n![\"Gantt](\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_03_en_new_19-daily50.png?resize=396%2C181&ssl=1\")
<\/a><\/li>\n<\/ul>\n\n
\n![\"Gantt](\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_03_en_new_19-daily100.png?resize=503%2C180&ssl=1\")
<\/a><\/li>\n<\/ul>\n\n
\n![\"Gantt](\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_03_en_new_19-daily200.png?resize=693%2C179&ssl=1\")
<\/a><\/li>\n<\/ul>\n5) Display text on the timescale<\/h4>\n
\n
\nTo display the date on the timescale, the timescale area must be wide enough, so increase the zoom ratio.
\n![\"Display](\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_03_en_new_04.png?resize=415%2C417&ssl=1\")
<\/a><\/li>\n<\/ul>\n
\n![\"Display](\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_03_en_new_05.png?resize=575%2C169&ssl=1\")
<\/a><\/p>\n\n
\n![\"Display](\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_03_en_new_07.png?resize=343%2C238&ssl=1\")
<\/a>
\n<\/strong><\/li>\n<\/ul>\n
\n![\"Display](\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_03_en_new_06.png?resize=349%2C241&ssl=1\")
<\/a><\/p>\n3. If the format of the Schedule sheet is damaged<\/h3>\n
\ngo to the ribbon menu> XLGantt tab, click \"Reformatting\u201d to reformat the Schedule sheet.
\n![\"Reformatting\"](\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_03_22.png?resize=524%2C115&ssl=1\")
<\/a><\/p>\n<\/div>\n\n