How do I use Excel to make a Gantt chart? Excel Gantt Chart making method

Using Excel to make a Gantt chart, you can clearly indicate the tasks for parallel processing, the time required to process each task, and so on. Here for you to introduce a look at it!

Software Name: Excel2003 Green version EXCEL2003 Lite Green version (with excel2003 green tools) software size: 13.3MB update Time: 2012-06-19

Steps

1, open the excel2010, ready to better collate the data.

2, adjust the Excel format, the general Excel format for the time format, needs to be adjusted to normal.

3, select the data, click the ' Insert ' menu, find the bar---two-dimensional bar chart---Stacked bar chart, click to select.

4, the time bar is shown above for easy viewing. Click the y-axis of the build graph, right-click, set the axis format, and check the reverse category.

5, set the x-axis properties, so that the starting position displayed at the origin, appropriate adjustment spacing.

6, select the image in the list, select the Blue section, right button, set the data series format is no fill.

7, the cell format of the date that was set before the restore. You can complete the Gantt Chart effect, drag appropriately, and adjust.

Attention matters

The display color size can be adjusted to suit your needs.

Above is the Excel Gantt Chart production method Introduction, the operation is very simple, everybody has learned? Hope this article can be helpful to everyone!