Create Gantt Chart in Excel

Gantt Chart

1)Open the excel

2)Insert Bar chat

3)right-click and choose "Select Data Source"

4)click "Add"

5)choose Start in Series name，select B3 to B16 in Series value，and then click "OK"

6)Click "Add" again，Select "Days" in Series Name，select C3~C16 in Series value. It will show red bar and blue bar.

7)Click "Edit"and select A3~A16. It will display Task Name in Bar Chart

8)You also can change color in CHART TOOLS

9) Click blue bar

10)select "Format Data Series..."

11)You will see "Format Data Series" Dialog

12)select "No fill" in Fill option and select "No line" in Border

13)Blue bar will be disappeared.

14)Click tasks and right click. Select "Format Axis..."

15) Enable "Categories in reverse order" in Axis option.

16)The tasks will follow the beginning of the date from the top row to the following, then we have to modify the date of the Y axis, marked the work of the first day of the date and the end of the date (red date)

17)select these dates and then select "Accounting" in number. Next is to click "comma style". You will get two numbers.

18)click on the date part of the chart, right click, select "Format Axis..."

19) Type the number of the first day in Minimum and and the number of the second day in Maxmum.

20)You can change date format in Value panel

21)Done!!

You can download file from there. https://1drv.ms/x/s!Aj7aP_ymnvA3gZ5GuA64nq5G-7zpXw