Gantt chart is a project management tool that shows the start date, end date and duration of the project. It's a graphical representation of the project schedule and can help you visualize the tasks, milestones and deadlines.
To create a Gantt chart in Excel, start by entering the tasks into separate columns. Then, use conditional formatting to make it easy for you to see at a glance which tasks have already been completed and which ones are still outstanding.
The final step is to create a timeline chart that shows the duration of each task. This can be accomplished by setting up multiple rows of data with different time periods for each task, then creating an area chart that shows all of those pieces stacked on top of each other as if they were layers on top of each other (see example below).
Microsoft Excel has many features that make it easy to create Gantt charts. The following steps will show you how to create a Gantt chart in Excel:
Step 1: Select a blank sheet of paper in Microsoft Excel and click on "Insert" menu then choose "Gantt Chart" option from the drop-down menu.
Step 2: Click on "Chart Elements" tab from ribbon bar at top of your screen then select desired layout from drop-down menu under "Chart Type" group. Once selected layout click on OK button located at bottom right corner of screen.
Step 3: Select an empty cell where you want to add data then click on "Data" tab from ribbon bar then choose "Insert Task…" option from drop-down menu under "Task" group, select task name/description/start date/duration/finish date for each task and click OK button when done adding all tasks for project.