Progress Completion Chart

Answer 1

The following are the contents related to the completion of the progress chart:

** I. Confirm the project scope to draw the schedule (software development project example)**
1. ** Clear goal **
- Before drawing the progress chart, the scope of the project had to be determined first. This was based on a clear definition of the project objectives. For example, in a software development project, the goal might be to develop an application with a specific function.
2. ** Confirm the delivery results **
- The delivery included software code, user manuals, and installation packages, which helped to plan the relevant indicators for the completion of the progress chart.

** 2. Operations related to the progress chart in Excel **
1. ** Simple steps to create a project progress chart **
- Construct the framework: Enter the sub-project name and start and end dates in columns A, B, and C respectively, and enter the project construction date in D2:X2.
- Cell format setting: select D3:X3, set the cell to a light gray bottom border, and drag the fill handle down from the lower right corner of the X3 cell.
- Condition format setting: select D3:X6,[Start] → [Condition format] → [New rule], use the formula =(D$2> = $B3)*(D$2< = $C3) and click the [format] button to set the fill color (note that the formula reference method changes).
- Today's line setting: select D3:X6,[Start] → [Condition format] → [New rule], use the formula =D$2=TODAY(), click the [format] button to set the right border to red.
2. ** Fillet bar progress completion rate chart creation **
- In the creation of Excel charts, traditional bar charts were mostly designed with square heads, and the format did not have rounded corners or square corners. Although it could be softened by color, it was not ideal. There were two ways to make a "rounded bar progress completion rate" chart.
3. ** Create a multi-step project completion schedule **
- He could use a combination of the "tick" symbol and the signal grid icon. For example, a project includes multiple stages and projects. By counting the number of "tick" symbols, enter the statistics formula "=Countif(B2:H2," tick ")" in the "I2" cell and fill it down to count the number of "tick" symbols in front.
- Choose the column I data area, right-click to select "Set Cell format", select "custom" under "Category" on the "Number" tab, and enter "[<1]" Not started ";[<7]" In progress ";" Completed ";" in the type.
- He selected the data area of column I, switched to the "Start" tab, and clicked "Style → Condition format → icon set → other rules". In the "icon style", he chose "four levels"(you can also choose other styles as needed), and set the "type" below to "number". The first group was ">6", the second group was ">=4", and the third group was ">=1" to indicate different completion states.

While waiting for the TV series, he could also read the exciting content related to this site!