Home > Excel Program > XLGantt > XLGantt How to > XLGantt(Excel Gantt) How to #3 – Setting Gantt chart display styles

XLGantt(Excel Gantt) How to #3 – Setting Gantt chart display styles

  • by

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 and Primavera.

See Wikipedia for Gantt chart

XLGantt also shows Gantt charts in the form of bar charts, and you can set various display styles in the options menu.

 

1. Components of Gantt chart

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.

XLGantt(Excel Gantt) How to #3 - Setting Gantt chart display styles

① Subtasks: Bar charts are displayed in blue.
② Summary tasks : Bar charts are displayed in yellow.
③ %Work Complete : It is indicated by the solid blue line. It is easy to see how much work has been done.
④ Today line : a vertical red line
⑤ 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.

 

2. Set Gantt chart display styles

Go to the ribbon menu> XLGantt tab > Options> Gantt chart > “Gantt Chart Display”, set the Gantt chart display style.

XLGantt(Excel Gantt) How to #3 - Setting Gantt chart display styles

 

1) Display text in Gantt chart area

When you check the following items in the options, each text is displayed in the Gantt chart area.

XLGantt(Excel Gantt) How to #3 - Setting Gantt chart display styles

 

The figure below shows an example of the text displayed when all checkboxes are checked.

XLGantt(Excel Gantt) How to #3 - Setting Gantt chart display styles

 

2) Text display position of the bar chart

You can set the text display position on the left, inside and right of the bar chart.

XLGantt(Excel Gantt)  bar chart

 

  • Left of the chart : The text except the %Work Complete are displayed on the left.
    XLGantt(Excel Gantt)  bar chart zoom ratio

 

  • Inside the chart: The text are displayed inside the chart.
    XLGantt(Excel Gantt)  bar chart zoom ratio

 

  • Right of the chart: The text are displayed at the end of the chart.
    XLGantt(Excel Gantt)  bar chart zoom ratio

 

 

3) Gantt chart view styles

You can select daily, weekly or monthly views.

XLGantt(Excel Gantt)  view style

 

  • Daily View :
    XLGantt(Excel Gantt)  view style - daily① Date scale is displayed by 1 day unit.
    ② If a nonworking day is entered in the calendar sheet, the nonworking is displayed as a pink vertical bar.

 

  • Weekly View : Displays the date scale weekly. You can save display space than the daily view.
    XLGantt(Excel Gantt)  view style - weekly

 

  • Monthly View : Displays the date scale monthly.  You can save display space than the daily and weekly views.
    XLGantt(Excel Gantt)  view style - monthly

 

 

4) Gantt Chart Zoom Ratio

You can set the zoom ratio of the Gantt chart by using the spin button in the options.
You can set a minimum of 10% and a maximum of 999%.

XLGantt(Excel Gantt)  zoom ratio

 

  • The Gantt chart zoom ratio is set to 50%.
    XLGantt(Excel Gantt)  zoom ratio

 

  • The Gantt chart zoom ratio is set to 100%.
    XLGantt(Excel Gantt)  zoom ratio

 

  • The Gantt chart zoom ratio is set to 200%.
    XLGantt(Excel Gantt)  zoom ratio

 

3. If the format of the Schedule sheet is damaged

If the Gantt chart does not display properly while using the XLGantt,
go to the ribbon menu> XLGantt tab, click “Reformatting” to reformat the Schedule sheet.

XLGantt(Excel Gantt)  reformatting

 

 

[ XLGantt(Excel Gantt) How to ]

Leave a Reply

Your email address will not be published.