• Home
  • Blog
  • Courses
  • Tools
  • Jobs
  • Forums
Have any question?
(00) 201277767728
[email protected]
RegisterLogin

Login with your site account

Lost your password?

Not a member yet? Register now

Register a new account

Are you a member? Login now

Planning Engineer Est.
  • Home
  • Blog
  • Courses
  • Tools
  • Jobs
  • Forums
      • Cart

        0

    Excel in Planning

    • Home
    • Blog
    • Excel in Planning
    • 14 easy steps to create a gantt chart with Excel in 3 minutes

    14 easy steps to create a gantt chart with Excel in 3 minutes

    • Posted by Hany Ismail, MSC, PMP
    • Categories Excel in Planning
    • Date January 16, 2013
    • Comments 1 comment

    14 easy steps to create a Gantt chart with Excel in 3 minutes, just follow the steps shown in the photos and you can download the sample excel template.


    Follow these simple 14 steps and Download Gantt Chart template at the end of this post.

    Step No. 1: create a table contains your activity name, start date, duration and finish date.

     

    Create a Gantt Chart with Excel-Step No.1
    Create a Gantt Chart with Excel-Step No.1

     

    Step no. 2:from the excel bar choose insert tape, then bar then choose stacked bar

    Step No.2
    Step No.2

     


    Step no. 3: right click in the chart area and choose select data.

    Step no. 3
    Step no. 3

     

     


    Step no. 4: from the select data window click Add.

     

    Step No.4
    Step No.4

     

     

     


    Step no. 5: Add the start date values into the series values.

    Step No.5
    Step No.5

     

     


    Step no. 6: Add a new value same we did in step no. 4 for the duration.

    Step No.6
    Step No.6

     

     


    Step no. 7: edit the horizontal axis values .

    Step No.7
    Step No.7

     

     


    Step no. 8: add the activities names in the horizontal axis values.

     

    Step No.8
    Step No.8

     

     


    Step no. 9: after adding all the data as per steps no. 5,6,7 and 8 just click OK

     

    Step No.9
    Step No.9

     

     


    Step no. 10: Right click on the blue bar and choose format data series.

    Step No.10
    Step No.10

     

     


    Step No. 11: from the fill menu choose no fill

     

    Step No.11
    Step No.11

     

     


    Step no. 12: right click on the axis include the activities name and choose format axis

     

    Step no. 12
    Step no. 12

     

     


    Step no. 13: from axis options check categories in reserve order.

    Step no. 13
    Step no. 13

     


    Step no. 14: now you have a gantt chart matching with your data in step no. 1, whenever you change any date or duration the bar chart will be changed automatically.

     

     

    Create a Gantt Chart with Excel-Step No.14
    Create a Gantt Chart with Excel-Step No.14

     


     

    Download the Gantt excel template:

    Creat-Gantt-Chart-in-Excel

     

    Tag:create a gantt chart with Excel, excel, excel gantt chart, excel template, gantt chart, gantt chart template

    • Share:
    Hany Ismail, MSC, PMP
    Hany Ismail, MSC, PMP

    Hany Ismael is the founder and CEO of Planning Engineer Est. in Egypt. He has started his career back in 2003 as a site engineer, technical office engineer, planning engineer, planning manager, and finally planning department manager where he has been involved in several mega construction projects in Egypt and Saudi Arabia. In 2016, he established his own company in Egypt “Planning Engineer Est.” Hany gained his MSc degree in project management from Liverpool University-UK 2013-2016, PMP certified from PMI-USA 2010, and BSc Civil Engineer Tanta University-Egypt 2003. Hany provided more than 3,500 hours of planning and project management training on his website planningengineer.net, YouTube channel, and offline courses since 2011. He enjoys teaching project management in simple and practical way, and he developed several planning tools, techniques and courses.

    Previous post

    PMBOK V5 is the new standard from PMI
    January 16, 2013

    Next post

    method of statement for slab on grade
    January 17, 2013

    You may also like

    Materials Procurement Scheduling in a Baseline Programme
    Materials Procurement Scheduling in a Baseline Programme
    7 May, 2022
    Planned VS Actual Excel Sheet
    Mini Schedule Planned VS Actual Excel Sheet
    18 August, 2021
    3 weeks look ahead schedule
    3 weeks look ahead schedule excel sheet
    24 July, 2021

      1 Comment

    1. blank
      Hasan Jlelaty
      January 16, 2013
      Log in to Reply

      thank you

    Leave A Reply Cancel reply

    You must be logged in to post a comment.

    Cart

    0

    Planning Courses

    Cost Control for Construction Projects

    Cost Control for Construction Projects

    $299.00
    Power Bi Monitoring and Controlling with P6

    Power Bi Monitoring and Controlling with P6

    $299.00
    Advanced Planning 3 Courses Package

    Advanced Planning 3 Courses Package

    $499.00
    Data Management and Reporting

    Data Management and Reporting

    $199.00
    Primavera Online Basic Course -Arabic

    Primavera Online Basic Course -Arabic

    $99.00
    Professional Planning Engineer (PPE)

    Professional Planning Engineer (PPE)

    $335.00
    Claims Management and (EOT)

    Claims Management and (EOT)

    $175.00
    Primavera Online Basic Course -English

    Primavera Online Basic Course -English

    $99.00

    Follow Us:

    About Us | Contact Us | Terms of Service | Privacy Policy | Refund Policy

    Copyright ©2012- 2018 planningengineer.net | All materials, unless otherwise noted, were developed originally for Planning Engineer Website. In the event that there is still a problem or error with copyrighted material, the break of the copyright is unintentional and noncommercial and the material will be removed immediately upon presented proof.

    • Planning Courses
    • Planning Jobs
    • Planning Blog
    Posting....