I. Overview
1) The Gantt chart, also known as the Bar chart, is a chart that graphically shows the activity sequence and duration of any specific project through an activity list and a time scale.
2) The Gantt chart is a line chart, the horizontal axis represents time, the vertical axis represents the activity (project), and the lines represent the planned activities and the completion of actual activities in the whole time period.
3) The Gantt chart visually displays when the task plan is carried out and the actual progress compared with the plan requirements, which can be used to evaluate the current work progress or the implementation of the work plan.
4) The Gantt chart is simple and intuitive, which is easy for ordinary users to understand. Generally, it is suitable for small and medium-sized projects with no more than 30 activities, and there is no need to worry about complicated calculation and analysis.
5) In fact, the Gantt chart only partially reflects the triple constraints (time, cost and scope) of project management, because it mainly focuses on process management (time).
| You will learn |
|---|
|
II. Steps
1. Data preparation
Create a new embedded dataset software.
2. Insert a chart
Taking the project progress of each module of the software as an example, this document introduces the basic method of making a Gantt chart. The insertion method of a Gantt chart is basically the same as that of a pie chart.
Pop up the [Chart Type] panel, and select [Gannt Chart] on the left.
Select [Gannt Chart] on the right.
Click [OK] to complete the insertion of the Gantt chart.
3. Data Binding
1) Bind Gantt chart data
Select [Dataset data] for [Data source], [software] for [Dataset], and [module] for [Project Name].
Select [task] for [Series], [start time] for [Start Time], [end time] for [End Time], [milestone time] for [Milestone Time], and [completion rate] for [Progress].
2) Bind task associated data
Click [Data]-[Gantt Chart].
Select [Dataset data] for [Data source] and [software] for [Dataset], and the data below need not to be set.
4. Style Setting
1) Delete the chart title
Remove the tick before [Show Title].
2) Set the series
Click the [Style] label.
Select [Series].
Select [Custom Combined Color] for [Color]-[Color Scheme].
Set [Pattern]-[Series New Line] to [Off].
Select [Rule] for [Milestone]-[Point Style], [Shape] and [Color] settings are as shown in the figure.
3) Set the project axis
Click the [Style] label.
Select [Project Axis].
Set [Proportion]-[Horizontal Proportion] to [Auto].
The specific settings of [Horizontal Header], [Vertical Header], and [Content] are shown below:
4) Set the time line
Click the [Style] label.
Select [Time Line].
Select [On] for both [Status config]-[Time Zoom] and [Weekend Tips]. Set [Initial Level] to [Automatic].
The specific settings of [Upper Header] and [Lower Header] are shown below:
5. Preview
An example of a Gantt chart with style setting is as follows.
Previous：Word Cloud
