Tutorial on making Gantt chart in Excel

Open excel2010 and prepare the data that needs to be sorted.

Adjust the excel format. Generally, the excel format is time format and needs to be adjusted to normal.

##Select the data and click the 'Insert' menu , find the bar chart---two-dimensional bar chart---stacked bar chart, and click to select.

Display the time bar above for easy viewing. Click on the Y-axis of the generated graph, right-click, set the axis format, and check the reverse order category.

Set the X-axis properties so that the starting position is displayed at the origin and adjust the spacing appropriately.

Select the image in the list, select the blue part, right-click, and set the data series format to no padding.

Restore the previously set date cell format. Then you can complete the Gantt chart effect by dragging and adjusting appropriately.

##Related article tutorial recommendations:

excel tutorial

The above is the detailed content of Tutorial on making Gantt chart in Excel. For more information, please follow other related articles on the PHP Chinese website!