If you need to manage and chart your project and do not have or know how to use Project Manager.  Do not worry, with Excel you can set up the timeline and chart it as well.

Steps:             

Design the timeline in a simple table.

Click in a blank cell

Insert Bar 2-D Stacked bar (no cells selected)

Right Click in the empty chart and Select Data…

Click the Add button to add series

In the Name Series area, Click on Start Date Label located in B1

To include the values of the date (series), DELETE the existing information ={1} and select range of cells of Start Date

Located in B2:B9

Click OK

To add the next series, click on the Add button and click in the name series, click on Duration(days) in C2

To include the values of the date (series), DELETE the existing information ={1} and select range of cells of Duration (days)

Located in C2:C9

Click OK

Click on Edit  button to change the labels from 1 through 8 by selecting the Task 1 through Task 8

Located in A2:A9

Click OK

Steps to Design Chart into a Gantt Chart:

Select and Delete the legend on the right side of the chart

Modify the series of the blue bars. Right Click on the blue bar and Format Data Series…

Fill choose No fill

Border Color choose No line

Close

Duration bars are still visible

To reverse the Task 8 to start as Task 1

Right Click on Task 8 through Task 1 labels

Format Axis… and check where it says Categories in reverse order

Close

In order to set the minimum and maximum for the dates,
you need to type in two cells the beginning and ending date and format them as Number

Right Click in the Date Labels and Format Axis…

In Minimum area, click on fixed and type in the starting date that was formatted as number.

In Maximum area, click on fixed and type in the ending date that was formatted as number.

To format the date without the year as MM/DD

Right Click in the Date Labels and Format Axis…

Choose Number

Choose 3/14

Close

This is your final product: The Gantt Chart!

Advertisements