Excel2010 Gantt Chart Drawing method

The Gantt Chart (Gantt Chart) is also called a bar chart, which graphically represents the sequence and duration of the activity of a particular item. In Excel 2003, you can quickly draw a simple Gantt chart with a "suspended bar" in a custom chart type, while in Excel 2007/2010 there is no ready-made custom chart type available, but it is also easy to implement with stacked bar charts.

If the project is currently in progress, you can enter the current date in cell B11, such as the formula:

Add secondary columns

1. Insert two columns to the left of the original C column of the data range, representing the number of days that the items in the B11 cell have been completed and unfinished, respectively, in the current progress. After inserting two empty columns, enter the formula in the C2 cell, as shown in the figure:

=if ($B $11-b2>e2,e2,min (E2,max ($B $11-b2,0))

2. Fill the formula down to the C9 cell, which gets the number of days that have been completed. Enter in D2:

=e2-c2

3, fill down to D9 cell, the formula gets the number of days to complete.

Insert Stacked bar Chart

1, select a cell in the data range, in the Ribbon select "Insert → bar → stacked bar chart", delete the legend in the inserted chart, and then select Select Data on the chart tools-Design tab, pop-up the Select Data Source dialog box, and select the unwanted days and end date series, respectively. Click the Delete button to delete the two series and then determine the chart as shown below:

2. Double-click the Start Date series in the chart, pop the Format data Series dialog box, and if it is Excel 2007, right-click the series and choose Set Series Format on the shortcut menu. You do not close the dialog box throughout the entire process of setting the related elements of the chart.

3, select the Fill option in the dialog box and select No Fill.

4, then the "Start date" series becomes transparent, because the vertical axis in the order of each item name and data area in the opposite, it seems to be inconsistent with the habit, you can change the order by the following method. Select the vertical (category) axis, the dialog box title automatically changes to format axis, and in axis options, click Reverse category to move the horizontal axis above the chart to move it back below the chart to select maximum category in the cross-axis cross area.

5. Click the horizontal (value) axis again in the chart, in axis options, set maximum and minimum values to fixed, and enter the start and end dates for the entire project, in this case the minimum value is set to date "2011-10-9" and the maximum value is set to "2011-11-10". For Excel 2007, enter the sequence number of these two dates, 40825 and 40857, respectively. There are many ways to get the number of date series, such as setting a cell containing a date to general to display the sequence number of that date in a cell.

Select the number option to set the date format to show only the number format for the month day.

Close the dialog box, and the diagram below.