You have searched every corner of Microsoft excel but can’t find a Gantt chart option? Wondering if you are missing something?
NOTE:There is no such option as gantt chart in Microsoft excel but it is fairly easy to create one.
Start a new workbook and enter you data as shown in the figure below.
First column that is column A would contain the task description, column B, the start date, C the number of days to complete a task and D will show the formulas that will determine the completion of a particular task. For instance, to calculate D2, the formula will be B2 + C2 – 1. Here, column D isn’t important but including it will tell you the exact date of the completion of a task.
Make a stacked bar chart from the data having a range of A2:C13. The chart wizard will take out the incorrect answers; therefore, you will have to set out the category axis labels and data series on your own. The x-axis labels should have a range of A2:A13, the series 1 data must be in B2:B13 and the series 2 data must be in the range of C2:C13.
Delete the chart’s legend and adjust the chart’s height as required. It is advisable to change the fonts to smaller size so as to show the x-axis labels.
In the dialog box of format axis, select “categories in reverse order” and for y-axis, “cross at maximum category”. This will display the task in order from top to bottom.
Open the dialogue box to format y axis. Input the max and min values to correspond to the latest and earliest dates of your project. Make sure you have entered real dates. Now for the weekly intervals, set the min to Monday and max to Sunday while the major unit to seven.
Opt for the data series that co-relates to the data mentioned in column B and go for the format data series dialogue box. Set the border and area to none. This will hide the first data series that are the starting dates that will make the chart looks like a Gantt chart.
Just like this, apply other formatting as desired. For example, to make it look good, you can add grid lines
and an intriguing title.
Thus by following the easy effective steps done down in pen above would help to construct the best Dissertation Gantt’s chart on Micro soft Excel.
Haven’t found your research topic yet?
Get your Research Topic Brief of 250 words on your field of study in just 3-5 business days including…