Today I am going to show you how to create a dynamic Gantt chart in excel 2007. A Gantt chart helps you plan and track various elements of a project. A dynamic chart automatically adds new values to the chart. Let's start!
Create a table
Select cell range (A1:D7)
Click "Insert" tab on the ribbon
Click "table" button
Create a stacked chart
Go to "Insert" tab
Click "Bar chart" button and then click "Stacked bar" button.