Gantt Chart
Gantt chart
A chart in which a series of horizontal line shows the amount of work done or production completed in certain periods of time in relation to the amount planned for those periods.
It is commonly used in Project Management which displays activity against time. This allows us to see at a glance:
The first Gantt chart was devised in the mid 1890s by Karol Adamiecki, a Polish engineer who ran a steelworks in southern Poland and had become interested in management ideas and techniques. Some 15 years after Adamiecki , Henry Gantt, an American engineer and management consultant, devised his own version of the chart and it was this that became widely known and popular in western countries. Consequently it was Henry Gantt whose name was to become associated with charts of this type.
Originally Gantt charts were prepared laboriously by hand; each time a project changed it was necessary to amend or redraw the chart and this limited their usefulness, continual change being a feature of most projects. Nowadays, however, with the advent of computers and project management software, Gantt charts can be created, updated and printed easily.
Let’s Create Gantt chart
1) Create one Sample Project Plan in Excel
2) On the Insert Tab, click Bar Category and select 2d Stack Bar
3) Select Data for Chart
4) Click OK
5) Click the legend on the right side and press Delete
6) Right Click on Step category, right click and select format axis and select “Categories in Reverser Order”
7) Right click the blue bars, click Format Data Series, Fill, No fill.
8) Right click the dates on the chart, click Format Axis
*To get the Minimum and Maximum Date you have to convert dates in number format based on your dates.
9) Result. A Gantt chart in Excel.
Happy Reading
Sanjay Bakshi
mesanjaybakshi@gmail.com
A chart in which a series of horizontal line shows the amount of work done or production completed in certain periods of time in relation to the amount planned for those periods.
It is commonly used in Project Management which displays activity against time. This allows us to see at a glance:
- What the activities are
- When each activity begins and ends
- How long each activity is schedule to last
- Where activities overlap with other activities and by how much
- The start date and end date of Project
The first Gantt chart was devised in the mid 1890s by Karol Adamiecki, a Polish engineer who ran a steelworks in southern Poland and had become interested in management ideas and techniques. Some 15 years after Adamiecki , Henry Gantt, an American engineer and management consultant, devised his own version of the chart and it was this that became widely known and popular in western countries. Consequently it was Henry Gantt whose name was to become associated with charts of this type.
Originally Gantt charts were prepared laboriously by hand; each time a project changed it was necessary to amend or redraw the chart and this limited their usefulness, continual change being a feature of most projects. Nowadays, however, with the advent of computers and project management software, Gantt charts can be created, updated and printed easily.
Let’s Create Gantt chart
1) Create one Sample Project Plan in Excel
2) On the Insert Tab, click Bar Category and select 2d Stack Bar
3) Select Data for Chart
4) Click OK
5) Click the legend on the right side and press Delete
6) Right Click on Step category, right click and select format axis and select “Categories in Reverser Order”
7) Right click the blue bars, click Format Data Series, Fill, No fill.
8) Right click the dates on the chart, click Format Axis
*To get the Minimum and Maximum Date you have to convert dates in number format based on your dates.
9) Result. A Gantt chart in Excel.
Happy Reading
Sanjay Bakshi
mesanjaybakshi@gmail.com
