Excel WBS and Gantt Chart - XLGantt How to #15 – Setting WBS Area and Color Theme

In this chapter, you will learn how to set the appearance and color of the XLGantt (Excel Gantt) "Schedule" sheet.

Contents

1. Schedule sheet

The “Schedule” sheet in XLGantt looks like the following illustration. You can set the display style and color in the options.

you can set the appearance of the WBS area in the ribbon menu “XLGantt> Options> Appearance” tab.

If you check all items above, the WBS area is displayed as follows.

Color themes are available from version 4.0.

you can change the color theme in the ribbon menu “XLGantt> Options> Appearance” tab.

XLGantt provides 5 color themes, and you can change the color you want in the custom theme.

If you select the “Custom” theme, you can change the 8 items to the color you want as shown below.

Select the “Custom” theme from the color theme list box and change colors in the following order.

① Click the color to change
② After choosing the color you want in the colors dialog box
③ Click the “OK” button.

[ XLGantt(Excel Gantt) How to ]