• Home
  • About Us
    • Why Us
    • Gallery
    • Testimonials
  • Courses

    About Courses

    • Actuarial Science
    • Computer and Data Analytics
    • CFA Program
    • Sales and Digital Marketing
    • Graphic Desgining
    • Finance & Management
    • Certified Credit Research Analyst
    • Chartered Alternative Investment Analyst
    • Financial Risk Management
    CM1 with MS Excel [Earlier CT1 & CT5] (Actuarial Science)

    CM1 with MS Excel [Earlier CT1 & CT5] (Actuarial Science)

    ₹ 23,000 ₹ 20,999
    Read More
  • Corporate Training
  • IT Solutions
  • Blog
  • FAQs
  • Clients
  • Contact
    Have any question?
    +91 9015696833 , 8076456526
    cc@wkvedu.com
    Investment Banking Courses, Data Science Using R, Actuarial Science ClassesInvestment Banking Courses, Data Science Using R, Actuarial Science Classes
    • Home
    • About Us
      • Why Us
      • Gallery
      • Testimonials
    • Courses

      About Courses

      • Actuarial Science
      • Computer and Data Analytics
      • CFA Program
      • Sales and Digital Marketing
      • Graphic Desgining
      • Finance & Management
      • Certified Credit Research Analyst
      • Chartered Alternative Investment Analyst
      • Financial Risk Management
      CM1 with MS Excel [Earlier CT1 & CT5] (Actuarial Science)

      CM1 with MS Excel [Earlier CT1 & CT5] (Actuarial Science)

      ₹ 23,000 ₹ 20,999
      Read More
    • Corporate Training
    • IT Solutions
    • Blog
    • FAQs
    • Clients
    • Contact

      Blog

      • Home
      • Blog
      • Blog
      • Gantt Chart – MS Excel Tips and Tricks

      Gantt Chart – MS Excel Tips and Tricks

      • Posted by White Knight Ventures
      • Categories Blog, News
      • Date December 10, 2019
      • Comments 0 comment
      Gantt Chart

      In this tutorial we are going to learn how to make a Gantt Chart. To make learning easy and fun we have given both video tutorial and step-by-step instructions in this article.

      Gantt charts are widely in use for project planning and tracking. A Gantt chart provides a graphical illustration of a schedule that helps to plan, coordinate, and track specific tasks in a project. There are software applications that provide Gantt chart as a means of planning work and tracking the same such as Microsoft Project. However, you can create a Gantt chart easily in Excel also.

      What is a Gantt Chart?

      A Gantt chart is a chart in which a series of horizontal lines shows the amount of work done in certain periods of time with relation to the amount of work planned for those periods. The horizontal lines depict tasks, task duration and task hierarchy.

      Henry L. Gantt, an American engineer and social scientist, developed gantt chart as a production control tool in 1917.

      In Excel, you can create a Gantt chart by customizing a Stacked Bar chart type with the Bars representing tasks. An Excel Gantt chart typically uses days as the unit of time along the horizontal axis.

      Advantages of Gantt Charts

      Gantt chart is frequently used in project management to manage project schedule.

      • It provides visual timeline for starting and finishing specific tasks.
      • It accommodates multiple tasks and timelines into a single chart.
      • It is an easy way to understand visualization that shows the amount of work done, the remaining work, and schedule slippages, if any at any point of time.
      • If the Gantt chart is shared at a common place, it limits the number of status meetings.
      • Gantt chart promotes on-time deliveries, as the timeline is visible to everyone who is involved in the work.
      • It promotes collaboration and team spirit with project completion on-time as a common goal.
      • It provides a realistic view of the project progress and eliminates project end surprises.

      Preparation of Data

      Arrange your data in a table in the following way ?

      • Create three columns – Task, Start and Duration.
      • In the Task column, give the names of the Tasks in the project.
      • In the Start column, for each Task, place the number of days from the Start Date of the project.
      • In the Duration column, for each Task, place the duration of the Task in days.

      Note ? When the Tasks are in a hierarchy, Start of any Task – Taskg is Start of previous Task + it’s Duration. That is, Start of a Task Taskh is the End of the previous Task, Taskgif they are in a hierarchy, meaning that Taskh is dependent on Taskg. This is referred to as Task Dependency.

      Following is the data ?

      Creating a Gantt Chart

      Step 1  Select the data.

      Step 2  Insert a Stacked Bar chart.

      Step 3  Right click on a bar representing Start series.

      Step 4  Click the Fill icon. Select No Fill from the dropdown list.

      Step 5  Right click on the Vertical Axis (Categories Axis).

      Step 6  Select Format Axis from the dropdown list.

      Step 7  On the AXIS OPTIONS tab, in the Format Axis pane, check the box – Categories in reverse order.

      You will see that the Vertical Axis values are reversed. Moreover, the Horizontal Axis shifts to the top of the chart.

      Step 8  Make the chart appealing with some formatting.

      • In Chart Elements, deselect the following ?
        • Legend.
        • Gridlines.
      • Format the Horizontal Axis as follows ?
        • Adjust the range.
        • Major Tick Marks at 5 day intervals.
        • Minor Tick Marks at 1 day intervals.
      • Format Data Series to make the Bars look impressive.
      • Give a Chart Title.

      Your Gantt chart is ready.

       

      Hope this was helpful and happy learning.

      To checkout more stuff on MS Excel visit www.wkvedu.com/blog/

      To learn more visit www.wkvedu.com

      Tag:chart, Excel, gantt, gantt chart, MS Excel, tips, tips and tricks, tricks

      • Share:
      Admin bar avatar
      White Knight Ventures

        Previous post

        Waterfall Chart - MS Excel Tips & Tricks
        December 10, 2019

        Next post

        Waffle Chart - MS Excel Tips & Tricks
        December 31, 2019

        You may also like

        Make purchases based on design (1)
        Band Chart – MS Excel Tips & Tricks
        10 January, 2020
        Make purchases based on design (7)
        Waffle Chart – MS Excel Tips & Tricks
        31 December, 2019
        Make purchases based on design (2)
        Waterfall Chart – MS Excel Tips & Tricks
        9 November, 2019

        Leave A Reply Cancel reply

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

        Search

        Categories

        • Blog
        • News
        • Uncategorized

        [eStore_multi_currency_widget code=” INR,USD “]

        © 2017 - White Knight Ventures

        • Actuarial Science
        • Computer and Data Analytics
        • CFA Program
        • Sales and Digital Marketing
        • Graphic Desgining
        • Finance & Management
        • Certified Credit Research Analyst
        • Chartered Alternative Investment Analyst
        • Financial Risk Management

        Login with your site account

        Lost your password?

        Not a member yet? Register now

        Register a new account

        Are you a member? Login now