Select the plan progress bar, add a data tag, and then select the number tag to set the display value as column G.
Set the formula in the next two columns to generate the text information displayed on the bar chart.
The chart clearly indicates the start and end dates and total days of each stage, and compares them with the actual completion progress.
As shown in the figure below, on the third and fourth floors above the ground, when does it start and end? How many days has it experienced? It can only be seen roughly from the figure, but can’t be seen Specific data.
d”))&CHAR (10)&”Total”&E2&”Day” Note: CHAR (10) is to generate a new line 2.
Gantt Chart, also called “Bar chart, which uses a bar chart to show the progress of the project.
Cuplock Scaffolding Bottom Cup
m.
Blue has made a new Gantt Chart, which perfectly solves the two defects of the ordinary Gantt Chart.
2.
It has two defects: 1.
(Useful later) Select the X axis, set the minimum value of 44502 (44562-60), and set the unit as 30 (days).
The specific chart beautification will not be detailed here.
G2 Cell Formula=TEXT (C2, “m.d”)&”~”&IF (YEAR (C2)=YEAR (D2), TEXT (D2, “m.d”), TEXT (D2, “yy.
Adjust the bar chart format, select the Y axis, and select “Reverse Category” to arrange items according to the source table.
Set the width of the series gap to 0%, and then set the fill color of the blue bar to none.
The duration is calculated by formula in two columns (as shown in columns E and F).
It is impossible to compare with the actual progress.
Sort out the data source plan and the actual amount, and arrange them in intervals.
Look at the number sequence of 2022-1-1, and the result is 44562.
It is impossible to prepare to see that a bar chart is the start date and the total number of days.
Finally, let’s look at the results: example template.
3.
The same goes for adding an actual progress bar.
The purpose of setting the number of days in this way is to display the date interval of 30 days, while the third from the bottom is 2022-1-1 (cross year separator).
The following is our most common Gantt chart style: it looks OK, but Blue thinks that this Gantt chart is too low.
After adding, it is shown in the following figure.
To create a partial chart: 1.
Insert bar chart to hide column B, Select AC column to insert stacked bar chart, copy EF column, select chart and press Ctrl+v to paste.
