Excel Gantt Chart - 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.

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.

[ Using XLGantt(Excel Gantt) ]

엑셀웍스 책 출간 안내

그동안 엑셀웍스에 올린 '엑셀 강좌', '함수 사용법', 여러 '실무 예제'에서 핵심만 뽑아 '된다! 엑셀 수식 & 함수' 책으로 출간하였습니다.

온라인 구매처: 예스24 교보문고 알라딘