Project Timeline with Excel Gantt Chart




About this tutorial:

Video duration: 5:11

To create a timeline in Excel, you can list your tasks on the worksheet. Then, insert a stacked bar chart, and format the bar chart so it becomes a Gantt chart, showing the project timeline.

This video shows how to calculate the start date for each task, and create and format the Gantt chart to show the timeline.

‘———————–
Transcript:

In this workbook I have a list of tasks for preparing our company budget I’ve put the start date for our first task and estimated how many days each of these steps will take us….

Post Author: OfficeTutes.com

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads

17 thoughts on “Project Timeline with Excel Gantt Chart

    Vinit Singh

    (March 24, 2019 - 3:47 am)

    Thank you very much for the walkthrough!

    Ashutosh S

    (March 24, 2019 - 3:47 am)

    Thank you. Great work 🙂

    CTA NS

    (March 24, 2019 - 3:47 am)

    Thank you! But how can I do to add a recurring task on the same line as the last one? Is that possible?

    ArburnAve

    (March 24, 2019 - 3:47 am)

    Thank you!

    Riaz Hossain

    (March 24, 2019 - 3:47 am)

    Thanks for your great work. This help me.

    RNtmop Ntmop

    (March 24, 2019 - 3:47 am)

    Great explanation !!!

    ds williams

    (March 24, 2019 - 3:47 am)

    good pace, very clear. thank you.

    Subjectmoney

    (March 24, 2019 - 3:47 am)

    thanks

    Paul Harraby

    (March 24, 2019 - 3:47 am)

    These are very clear. Thanks.

    thea abdulrahman

    (March 24, 2019 - 3:47 am)

    nice tutorial 🙂

    Michael Pusateri

    (March 24, 2019 - 3:47 am)

    Very useful. Thank you for posting. Saved me a lot of time.

    rune spammail

    (March 24, 2019 - 3:47 am)

    Is there anyone who can help me with the following.
    If I have a recurring task such as a meeting every other day, every week, every two weeks or once a month ect. Can this task be displayed on the same row, or should I create a new task every time I hold a meeting even though it is a meeting with the same angenda? Can anyone send me a link to a video or a screenshot showing / demonstrating how I solve this problem. thanks alot

    Jessica M

    (March 24, 2019 - 3:47 am)

    I'm wondering how you manage your timeline when weekends are not included in the duration of the task?

    Benjameen Benjamin

    (March 24, 2019 - 3:47 am)

    How to include more than one series in the timeline?

    Brian Mudd

    (March 24, 2019 - 3:47 am)

    So how would I roll all of the tasks into a single project timeline, truly stacking the bar, then inputing several projects into the graph?

    pakialamerong henyo

    (March 24, 2019 - 3:47 am)

    That looks reallly interesting because I also create schedule program in excel and that function can really be useful in my application. Meanwhile you may be intersted to view my youtube presentation for the Excel Macro program I developed. Check for "Excheduler"

    يوتيوب

    (March 24, 2019 - 3:47 am)

    Interesting… But How it will be if I have Sequel for the same task?

Leave a Reply

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