Excel practical analysis project progress chart

This article brings you relevant knowledge about excel, which mainly introduces the method of making project progress chart. The main step is to first build the framework to set the cell format, and then set the conditional format. Wait, let’s take a look at it together, I hope it will be helpful to everyone.

Related learning recommendations: excel tutorial

Share a simple and practical method of making a project progress chart, let’s take a look at the effect first:

Next let’s take a look at the specific steps.

Step one: Build a framework first

Enter the subproject name and start and end dates in columns A, B, and C respectively.

Enter the project construction date at D2:X2.

Step 2: Set the cell format

Select D3:X3 and set the cell to a light gray lower border.

The cursor is close to the lower right corner of cell X3 and drag the fill handle downward.

Step 3: Set conditional formatting

Select D3:X6, [Start]→[Conditional Formatting]→[New Rule]→Use the formula as ：

=(D$2>=$B3)*(D$2

Click the [Format] button to set the fill color.

Pay attention to the changes in the reference method in the formula.

Step 4: Set today’s line

Select D3:X6, [Start]→[Conditional Formatting]→[New Rule]→Use the formula as ：

=D$2=TODAY()

Click the [Format] button and set the right border to red.

OK, let’s see the effect:

Related learning recommendations: excel tutorial

The above is the detailed content of Excel practical analysis project progress chart. For more information, please follow other related articles on the PHP Chinese website!