Creating Gantt Chart In Excel

Asked By Aliza Ross 0 points N/A Posted on - 07/09/2020

I am having trouble creating Gantt chart in excel. Can you please teach me how to create one. It would be really helpful!

• Status: Open
• Question Views: 68
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Sound Cards
• Question Tags: Excel

Answered By Carlos C Perkins 0 points N/A #332290

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!

 

 

About Carlos C Perkins

Questions
16

Answers
1

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 07/09/2020
• Question Category: Sound Cards