巧用Excel绘制动态甘特图

The Skillful Drawing Dynamic Gantt Chart With Excel

甘特图通过活动列表和时间刻度形象地表示出任何特定项目的活动顺序与持续时间,应用领域广泛。通过设置函数公式、定义有关联的名称、设置坐标轴、设置系列格式、插入滚动条,可以用Excel的堆积条形图巧妙绘制有进度对比和能动态选择项目的甘特图。

Gantt chart through the activity list and the time scale the image to show any specific project activity order and duration, wide application field. By setting the function formula, the definition of related name, axis settings, set the series format, insert the scroll bar, you can use the Excel stacked bar chart drawing Gantt chart schedule has artful contrast and can dynamically select the project.