Microsoft Office Tutorials and References
In Depth Information
Creating a Gantt Chart
Creating a Gantt Chart
A Gantt chart is a horizontal bar chart that’s often used in project management applications.
Although Excel doesn’t support Gantt charts per se, creating a simple Gantt chart is fairly easy.
The key is setting up your data properly.
Figure 137-1 shows a Gantt chart created from the data in the range A2:C13. In the chart, the
horizontal axis represents the total time span of the project, and each bar represents a project task.
The viewer can quickly see the duration for each task and identify overlapping tasks.
Figure 137-1: You can create a simple Gantt chart from a stacked bar chart.
Column A contains the task name, column B contains the corresponding start date, and column C
contains the duration of the task, in days. Note that cell A1 does not have a descriptive label.
Leaving that cell empty ensures that Excel does not use columns A and B as the category axis.
Follow these steps to create this chart:
1. Select the range A1:C13, choose Insert
Charts
Bar, and select the Stacked Bar Chart
option.
2. Delete the legend.
 
Search JabSto ::




Custom Search