Unused Wii Pin Numbers

Agenda Task (Gantt Charts)

During this Last week I had several inquiries regarding the generation of graphics for the control of project schedules, or whatever it is, Gantt charts. Excel does not have this type of graphics by default but easy enough to get by following a few steps ...

from the following example where we can see in the task column B, column C the date of commencement of the task, and in column D the number of days from the date of beginning of each task:

1. Select the range B2: D8 and proceed to insert horizontal bar chart type, subtype stacked bar:

2. directly press Finish . The graph obtained is as follows:

3. We have the basis to start working ... What we must do then is click the right mouse button on the Y axis (vertical axis) and select Format Axis ...

4. In the Scale tab We check the option Categories in reverse order . Thus excel tasks placed in the correct order (not as presented in the chart above) and the dates on the top of the chart. We click on the legend and suppress:

5. Double click on the data series in blue, which refers to the start date, and we remove the fill and border:

6. Double click on the dates found on the top of the chart to format, and select the window that opens up the tab Scale. Excel does not recognize this date formats, so you must use the general format. To do this he must return to the worksheet and set, for example in cell F3. In this cell copy the date from the first task and go to Format / Cells / Number and select the General . Please copy the F4 and start date of the last project plus the number of days (in our example the last date is 7/8/2010 and the duration of this last task is 7 days, so far will end 14/08/2010) and do the same as in the previous case. So we get the serial numbers corresponding to these two dates that interest us (specifically the 40369 and 40404 Why? To return to our window Format Axis tab scale we write as the least 40369 (The date of commencement of the first task) and as a maximum the 40,404 (which is the end date of the last job):

And with some improvements format (font color, color of lines of division, etc) get a simple Gantt chart as shown below: