Project Timeline in Excel

Project Timeline in Excel

Project Timeline is the list of tasks recorded in an order to be accomplished to finish the project within the given period. In simple words, it is nothing but the Project Schedule/Timetable. All the tasks listed will be having a Start date, Duration and End date so that it becomes easy to track the status of the project and have it completed within the given timeline.

Project Timeline is one of the important aspects of Project Management.  It is required to plan & determine the flow of tasks from the beginning to the end of the project.

The easiest way of representing the Project timeline in excel is through graphical representation.  This can be done using the charts in Excel, and it is called “Gantt Chart.” Gantt chart (named after its inventor Henry Laurence Gantt) is one of the types in Bar Charts in ExcelBar Charts In ExcelBar charts in excel are helpful in the representation of the single data on the horizontal bar, with categories displayed on the Y-axis and values on the X-axis. To create a bar chart, we need at least two independent and dependent more and a popular tool used in Project Management, which is helpful in visualizing the project schedule.

How to Create a Project Timeline in Excel? (Step by Step)

Below are the steps for creating a simple Gantt chart to represent Project Timeline in Excel.

Example #1

Creating a Gantt chart using a normal stacked bar graph:Stacked Bar Graph:The stacked bar chart in Excel represents data in the shape of bars, with the bars representing different segments or categories for comparison. A stacked bar chart is used to compare different types of data in terms of their more

  1. List down the tasks/activities need to be completed in the excel sheet(as shown below)

  2. Enter the Start Date for each of the tasks in the column next to the activities.

  3. Update the Duration of the task next to the Start Date column (Duration is the no. of days required for the particular task/activity to be completed)

  4. The End Date for the activities can be entered next to the Duration column. This column is optional because this is just for the reference and will not be used in the chart.

    Project timeline Example 1

    Note: Duration can be entered directly, or a formula can be used to find out Duration.

    Project timeline Example 1-1

    In the above table, Duration is calculated using the formula, i.e., End Date (-) Start Date.

    In the formula, +1 is used to include the day of the starting date.

Now let’s begin to build a chart.

In the Ribbon, go to the “INSERT” tab and select the Bar graph option in the “Charts” sub-tab. Select the Stacked Bar (second option in 2-D Bar Section)

Project timeline Example 1-2

By selecting this graph, a blank chart area will appear. Select that blank area and do a right-click to select the “Select Data” option.

Project timeline Example 1-3
  • “Select Data Source” pop up will appear to select the data. Click on the “Add” button under Legend Entries (Series).
Project timeline Example 1-4

When the “Edit Series” Pop up appears, Select the “Starting Date” label as Series name.  In this example, it is cell B1.  And Select the list of dates in the Series Values field.  Hit the OK button.

Project timeline Example 1-5

Again hit on the “Add” button to select the Series name and Values of Duration column the same as above.

Project timeline Example 1-6

After adding both Starting Date and Duration data into the chart,

  • Click on “Edit” under Horizontal (Category) Axis labels on the right-hand side of the Select Data Source Window.
Project timeline Example 1-7
  • In the Axis label range, select the list of tasks starting from “Task 1” to the end and click on OK.
Project timeline Example 1-8

Below given is the output you can see after completing all the above steps.

Project timeline Example 1-9

In the above chart, you can see the list of tasks on the Y-axis and dates on the X-axis.  But the list of tasks shown in the chart is in reverse order.

To change this,

  • Select the axis data and right-click to select “Format Axis.”
Project timeline Example 1-10
  • In a Format Axis panel, under Axis Options Section, check the “Categories in reverse order” box.
Project timeline Example 1-11

When the categories are reversed, you can see the chart below.

Project timeline Example 1-12

We need to make a blue bar invisible to show only the orange bars, which indicate the duration.

  • Click on the blue bar to select and right-click, select format data series.
Project timeline Example 1-13
  • In the Format Data Series panel, select “No fill” under Fill Section and “No line” under Border Section.
Project timeline Example 1-14
  • The chart looks as below.
Project timeline Example 1-15

Now your Project Timeline Excel Gantt chart is almost done.

Remove the white space at the beginning of the chart.

  • Do a right-click on the date given for the first task in a table and select format cells.
Project timeline Example 1-16
  • Note down the number shown in the window under the “Number tab” and “General” category.

(In this example, it is 43102)

Example 1-17
  • Click on the dates on the top in the chart and do a right-click, select Format Axis.
Example 1-18
  • In the panel, change the Minimum number under Bounds options to the number you have noted.
Example 1-19
  • The units of date can adjust the scale as you want to see in the chart. (in this example, I’ve considered units 5)
Example 1-20

The Chart looks like as given below.

Example 1-21

Now trim the chart to make it look even nicer by eliminating the white space between the bars.

  • Click on the bar anywhere and right-click, select Format Data Series.
Example 1-22
  • Keep the Series Overlap at 100% and adjust the Gap Width to 10% under Plot Series on Section.
Example 1-23
  • The data labels can be added to the bars by selecting Add data labels using right-click.
Example 1-24

Data Labels are added to the charts.

Example 1-25
  • 3D Format can be applied to the chart to give some effects by removing the gridlines, and the color of the bar and font can be changed as required in the Format Data Series panel.
  • The dates can be shown horizontally by changing the text alignment if required to show all dates.

And, in the end, your Project Timeline Gantt chart in Excel will look like this.

Example 1-26

Example #2

Creating a Gantt chart using the project timeline templateProject Timeline TemplateA project timeline template is an excel chart that systematically tracks the start and end dates, status, and duration of every task involved in a project. It provides an idea to the project manager about the expected time a project may take to more available in Excel:

Gantt chart can be created using the template readily available in Excel provided by Microsoft.

Example 2
  • Click on Gantt Project Planner and click on Create in the Pop-up window.
Example 2-1

The template is ready to start by entering your project details in the given column as per the headers and see the bars reflecting the timeline.

Example 2-2

Things to Remember

Recommended Articles

This has been a guide to Project Timeline in Excel. Here we discuss how to Create Project Timeline Excel Template using Gantt Chart and Project Planner along with practical examples and downloadable excel template. You may learn more about excel from the following articles –

  • 35+ Courses
  • 120+ Hours
  • Full Lifetime Access
  • Certificate of Completion

Reader Interactions

Leave a Reply

Your email address will not be published. Required fields are marked *