Projektplan Excel Gantt. Hello friends in this video you will learn how to create a good looking project plan or a gantt chart in excel. To create a gantt chart execute the following steps.
The completed gantt chart shows the timeline for the project tasks with the first task s bar starting at the vertical axis and the project name appears at the top. Select the range a3 c11. Well done for getting all the way through i hope you have found this useful and can now create excellent project plans in excel.
Excel does not offer gantt as chart type but it s easy to create a gantt chart by customizing the stacked bar chart type.
The chart will also display task percentage completed as a bar inside the actual bar. You can enter start dates duration and current status of each task and share with your team to keep task owners accountable. I have not used any kind of chart or macro. Excel does not offer gantt as chart type but it s easy to create a gantt chart by customizing the stacked bar chart type.