Creating Gantt Chart In Excel

Creating Gantt Chart In Excel

Hey! First, start with selecting data and creating a graph with stacked bars. After selecting data, click on the bar from the insert tab. Select a stacked bar in a 2-D section and a stacked bar graph would display on your screen.

Next, right-click on the graph and press select data. In the next box, click on Add under Legend Entries and select another field. Name the series and click on OK. Click on OK again in the next box.

Next, select a blue bar and click on Format data. Choose No fill in the Fill section and No line in the border color section. Select the values on the y-axis and in the next box select Categories in reverse order. To understand better on creating Gantt chart in excel, look at the images attached to the text. I hope this helps!