We will use the stacked bar chart option in Excel to create our Gantt chart. First, as shown in the image below, hold down the CTRL key and select the columns that contain the Task, Start Date, Days Completed, and Days Remaining Data.

click to enlarge
Next, navigate to the Insert screen of Excel and choose the option to insert a stacked bar chart. You’ll end up with an image like that in the following screenshot.

click to enlarge
This isn’t at all what we want as a final version, but we now have a representation that contains our basic information that we can modify to reach our desired appearance.