Join

Join TheConstructor to ask questions, answer questions, write articles, and connect with other people. When you join you get additional benefits.

Have an account? Log in
Continue with Facebook
Continue with Google
or use


Have an account? Log in Now

Log in

Log in to TheConstructor to ask questions, answer people’s questions, write articles & connect with other people. When you join you get additional benefits.

Join Here

Join for free or log in to continue reading...

Continue with Facebook
Continue with Google
or use


Forgot Password?

Don't have account, Join Here

Forgot Password

Lost your password? Please enter your email address. You will receive a link and will create a new password via email.

Have an account? Log in Now

Sorry, you do not have permission to ask a question, You must log in to ask a question. Join now!

Join for free or log in to continue reading...

Continue with Facebook
Continue with Google
or use


Forgot Password?

Don't have account, Join Here
Join now!
The Constructor Logo The Constructor Logo
Log inJoin

The Constructor

The Constructor Navigation

  • Articles
    • Recent Articles
    • Popular Articles
    • Write for us
  • Community
  • Categories
    • How To Guide
      • Material Testing Guide
    • Concrete
    • Building
      • Brick Masonry
      • Building Materials
      • Building Tips
    • Construction
      • Equipments
      • Management
    • Digital Construction
    • Geotechnical
      • Foundation
  • Case Studies
Search
Ask A Question

Mobile menu

Close
Ask a Question
  • Questions
  • Ask Questions
  • Write for us
  • Artificial Intelligence
  • Sustainability
  • Building
    • Brick Masonry
    • Building Materials
    • Building Tips
    • Formwork/Shuttering
  • Concrete
    • Concrete Admixtures
    • Cement
    • Concrete Cracks
    • Concrete Properties
  • Construction
    • Construction Equipments
    • Construction Management
    • Construction Project
    • Estimating & Costing
  • How To Guide
    • Material Estimation
    • Repair/Protection Guide
    • Material Testing Guide
    • Mix Design Guide
    • Rate Analysis
  • Geotechnical
    • Foundation Engineering
    • Ground Improvement
  • Structural Engineering
    • Strengthening of Structure
    • Structual Inspection
    • Structural Detailing
  • Surveying
  • Tips

How to prepare a Gantt chart in Excel?

Home/ Questions/Q 40733
Next
In Process

Do you need to remove the ads? Join now!

Asked: May 15, 20202020-05-15T20:51:36-07:00 2020-05-15T20:51:36-07:00In: Construction
KetanPurohit
KetanPurohit

KetanPurohit

  • 1 Question
  • 0 Answers
  • 0 Best Answers
  • 10 Points
View Profile
KetanPurohit User

How to prepare a Gantt chart in Excel?

  • 0
  • 4 4 Answers
  • 607 Views
  • 0 Followers
  • 0
  • Share
    Share
    • Share on Facebook
    • Share on Twitter
    • Share on LinkedIn
    • Share on WhatsApp

4 Answers

  • Voted
  • Oldest
  • Recent
  1. AdityaBhandakkar

    AdityaBhandakkar

    • 12 Questions
    • 250 Answers
    • 2 Best Answers
    • 0 Points
    View Profile
    AdityaBhandakkar User
    2020-09-22T13:47:58-07:00Added an answer on September 22, 2020 at 1:47 pm
    How to prepare a Gantt chart in Excel?

    Hi,

    Following are the steps of preparing a Gantt chart in excel

    1. Create a new table for the project
    2. Based on the start date, made a standard excel bar chart
    3. Insert duration data in chart
    4. Adding a task description in the Gantt chart
    5. Then transform a bar graph into an excel chart.
    6. Improve your design

    You may also download a Gantt chart template from the internet.

    Hope you get the answer.

    • 44
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
      • Share on LinkedIn
      • Share on WhatsApp
  2. nikeetasharma

    nikeetasharma

    • 23 Questions
    • 303 Answers
    • 0 Best Answers
    • 2,680 Points
    View Profile
    nikeetasharma Guru
    2020-10-14T19:52:24-07:00Added an answer on October 14, 2020 at 7:52 pm

    A Gantt chart helps you schedule your project tasks and then helps you track your progress.

    The steps for preparing a gantt chart in excel are as follows :-

    1. Create a project table
    2. Make a standard Excel Bar chart based on Start date
    3. Add Duration data to the chart
    4. Add task descriptions to the Gantt chart
    5. Transform the bar graph into the Excel Gantt chart
    6. Improve the design of your Excel Gantt chart and done.

    • 31
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
      • Share on LinkedIn
      • Share on WhatsApp
  3. aviratdhodare

    aviratdhodare

    • 37 Questions
    • 252 Answers
    • 0 Best Answers
    • 480 Points
    View Profile
    aviratdhodare
    2020-10-15T21:44:03-07:00Added an answer on October 15, 2020 at 9:44 pm

    Gantt chart enable the user(s) or a team to create and share a visual planning regarding a project or event you are managing to your colleagues or management. By doing this, you will increase the chance on finishing the project in a more efficient way, which will increase the companies effectiveness.

    Therefore, Gantt charts are seen as a very effective project management planning tools, especially when more than 1 person is involved in the success that follows after succeeding of a project. The total of all elementary project components can be called “the work breakdown structure of the project”.

    This is how it looks like in a Gantt chart:

    As you can see, the difference between the list of activities, and the Gantt chart that shows the work breakdown structure, are the following advantages:

    • Simplifying the complexity of a project;
    • Synergy effect among all team members, and making it more effective;
    • Every stakeholder is on the same page;
    • Determining milestones and deliverables according a fixed time schedule;
    • Creating team productivity;
    • Making everything visual and manageable.

    Advanced Gantt charts additionally demonstrate the reliance (i.e., priority) connections between deliverables (which shows a liability as well for all team members). Gantt charts can be applied to show current project status by informing the percentage of successful completion of the project, and a vertical “Today” line can be implemented here as well.

    Gantt charts allow you to schedule activities and resources and are helpful when you are planning and tracking various business processes. For example, you can have a list of activities on the left and a suitable time scale along the top in order to see the following at a glance:

    List of activities that are needed to be done

    • Beginning and ending of activity;
    • Time that is available per activity;
    • The liability between 2 ore more activities;
    • The whole project’s start and end dates.

    For example, here you can see a generic Event Gantt chart, which structures the following activities:

    1. Determine host event
    2. Pick a budget
    3. Pick a location
    4. Pick a date
    5. Make a guest list
    6. Choose a theme
    7. Send out invitations
    8. Order equipment
    9. Plan the food menu
    10. Line up extra hands
    11. Execute last minute orders
    12. Help with thank you notes
    13. Prepare some games
    14. Follow up RSVP stragglers
    15. Make the goody bags
    16. Plan take away gifts
    17. Assign photographer
    18. Clean up
    19. Prepare food
    20. Complete groceries
    21. Quick cleaning sweep
    22. Set up party space
    23. Pick up the cake
    24. Designate honoree

    • 12
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
      • Share on LinkedIn
      • Share on WhatsApp
  4. Structural Engineer

    Structural Engineer

    • 0 Questions
    • 11 Answers
    • 0 Best Answers
    • 308 Points
    View Profile
    Structural Engineer Beginner
    2020-07-22T18:17:20-07:00Added an answer on July 22, 2020 at 6:17 pm
    1. Select the data you want to chart. …
    2. Click Insert > Insert Bar Chart > Stacked Bar chart.
    3. Next, we’ll format the stacked bar chart to appear like a Gantt chart. …
    4. If you don’t need the legend or chart title, click it and press DELETE.
    5. Let’s also reverse the task order so that it starts with Task1
    • 0
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
      • Share on LinkedIn
      • Share on WhatsApp

You must log in to add an answer.

Join for free or log in to continue reading...

Continue with Facebook
Continue with Google
or use


Forgot Password?

Need An Account, Join Here

Sidebar

Popular Articles

  • Gopal Mishra

    Types of Foundation for Buildings and their Uses [PDF]

  • Gopal Mishra

    Compressive Strength of Concrete -Cube Test [PDF], Procedure, Results

  • Sadanandam Anupoju

    16 Types of Heavy Equipment Used in Construction

  • Gopal Mishra

    Calculate Quantities of Materials for Concrete -Cement, Sand, Aggregates

  • Padmanabhan G

    Methods of Rainwater Harvesting [PDF]: Components, Transportation, and Storage

Recent Articles

  • constructororghq

    The Art and Science of Masonry: Techniques and Best Practices

  • constructororghq

    Mastering Concrete Mix Design: Proven Strategies for Quality Construction

  • constructororghq

    Demystifying Reinforced Concrete: Key Principles for Construction

  • constructororghq

    The Importance of Fire Safety in High-Rise Buildings

  • constructororghq

    Innovative Materials for Concrete Reinforcement and Durability

Recent Questions

  • jkshah

    Which is the code used for the design of the RCC Bridge?

    • 1 Answer
  • AKM59

    What is the tolerance for compression test results of concrete, according to the standards?

    • 1 Answer
  • Gopal Mishra

    What must be the maximum dry density of Granular Sub Base & Wet Mix Macadam used ...

    • 1 Answer
  • Gopal Mishra

    What is the Safe Bearing Capacity values for Different Soils?

    • 1 Answer
  • Gopal Mishra

    What are the different types of handrails used in bridges?

    • 1 Answer

Explore

  • Questions
  • Ask Questions
  • Write for us
  • Artificial Intelligence
  • Sustainability
  • Building
    • Brick Masonry
    • Building Materials
    • Building Tips
    • Formwork/Shuttering
  • Concrete
    • Concrete Admixtures
    • Cement
    • Concrete Cracks
    • Concrete Properties
  • Construction
    • Construction Equipments
    • Construction Management
    • Construction Project
    • Estimating & Costing
  • How To Guide
    • Material Estimation
    • Repair/Protection Guide
    • Material Testing Guide
    • Mix Design Guide
    • Rate Analysis
  • Geotechnical
    • Foundation Engineering
    • Ground Improvement
  • Structural Engineering
    • Strengthening of Structure
    • Structual Inspection
    • Structural Detailing
  • Surveying
  • Tips

Footer

  • Home
  • About Us
  • Contact Us
  • Privacy Policy
  • Terms & Conditions
  • Ask Questions
  • Write for us
  • Popular Questions
  • Facebook
  • Instagram
  • Twitter
  • Telegram

© 2009-2021 The Constructor. All Rights Reserved.