Make a Dissertation Gantt chartIn Microsoft Excel 2007 In Seven Steps?
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.
By following these steps you can easily
create a dissertation gantt chartin no more than 60 minutes.
How to Create a Dissertation Grant Chart in Microsoft Excel 2007?
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.
EFFORTLESS PLANNING WITH OUR RESEARCH PROJECT PLAN EXAMPLE
Planning a research project such as a dissertation is really simple if you think about it. Unlike in project management, most of the tasks come one after the other, not in the same time, making it a lot easier to see through. On the other hand, most of the tasks need to be performed by none other than yourself, so there's really no one else to control. You can make things even easier by moving the tasks about when needed or adding comments and icons to them. Feel like rewarding yourself after a completed chapter? Add a little cake icon at the end of the box for extra incentive. Yum!
SHARING MADE EASY
Making a good impression on your tutor (so he will accept the proposal you botched together last night) and keeping him happy throughout the process is vital for your success. That's why we made sure that Tom's Planner great for sharing, online or offline. Show him the research project timeline you created in Tom's Planner (watch him get blown away), keep him informed in real time on your progress, wherever you are, or export the schedule to the desired format in case of personal consults. Schedule your dissertation project the easy way: with Tom's Planner. Be sure to check out our blog as well, where you'll find lots more useful tips and tricks about writing and scheduling dissertations.