How to generate a time schedule in Excel--Gantt chart

The recent study of software engineering needs to make a project progress chart. Small problems in my count, do not obey, the end of the, a way to live. Share it with your friends here.

The steps are as follows:

1. First we build a data table in Excel that contains time periods.

2. Select the attribute column that contains the time period and the ordinate attribute column, such as:

3. From the menu bar, select Insert---bar--two-dimensional bar--stacked bar chart, as

4. Convert the produced chart into Figure two form. Select the Data Source window by right-clicking in the chart area, selecting Select data into Figure II, and clicking Toggle Row/column is shown in Figure two. At the same time, select the corresponding row and column property name in the data source to be shown in the Excel table to ensure the same attribute name (advantageous behind clear idea), three.

Figure A

Figure II

Might

5. Each attribute in a bar chart (for example: Start time, end time) component is the point in time from the source to the point of the attribute, and the different attributes have an overlay effect on each color displayed on the same ordinate item (for example, class, recess). Therefore, the end of each item in the beginning and end of the paragraph indicates the need to set the end time as the primary coordinates, the start time is set to the horizontal axis (mainly to ensure that the start time of each period of the color can not be the end of the color to represent the full coverage), This way, when the attribute display color of the ordinate is adjusted to be the same as the background, the final elapsed time period is seen.

A. Figure one sets the start time from coordinates (which are displayed at the top coordinates of the graph graph as from coordinates), selects the start time in the chart, right-click to select Set data series format, second.

Figure A

Figure II

B. Figure III Sets the end time as the primary coordinate (shown below the bar chart).

Might

6. In the Excel table, select the start time of the horizontal axis (such as 7:45) to convert the final time (for example: 11:00) to a numeric representation. One, select the right click to select the format of the cell, go in and choose a value, the general default OK on the line (if the format is not correct can be customized to retain two decimal places), two.

Figure A

Figure II

7. Set the minimum and maximum values of the master, slave coordinates to the two values converted above.

A. Select Main, right-click from coordinates to enter the format axis.

Figure A

B. Set the minimum and maximum values to the values converted above in the format axis, and the primary and secondary units default to the line. Below you can also choose to display the scale, selected as the inside on the line. The finished effect is shown in the second horizontal axis.

Figure II

8. Finally, adjust the color bar from the start time of the coordinate display to the same color as the background, and adjust the grid display to the horizontal axis display effect.

A. Select all the color bars from the coordinates, right-click into the Format data series, select Fill as solid fill and choose the same color as background, one.

Figure A

B. When the above operation is complete, select the layout-Grid line in the menu bar to cancel the ordinate display and open the horizontal axis display. Finally get three effects.

Might

Note: Note the details of each graphic change, which is the key to quickly understand the nature of its operation. The same project name appears in the data table items such a small mistake to apologize, but also hope will not affect the understanding of good scholars.

How to generate a time schedule in Excel--Gantt chart