How does Excel make a gorgeous construction progress chart?

How does Excel make a gorgeous construction progress chart? Do construction management work, often to the progress of the project to do accurate statistics, although the Internet also has a variety of specialized software, but, or we use the Office every day in the most convenient use, today to share the work of Excel to create brilliant progress class chart.

1, first of all, open the Excel software, according to their own needs to fill the table first;

2, then, according to the data content to outline the number of tables, merged cells, and different color blocks filled,

3, so we have a relatively intuitive schedule of progress, but, this table can only be used to start planning when the schedule to use, followed by the progress of the time is not practical.

4, below we will design the progress bar to follow up the progress of the project in real time. Hold down the CTRL key, select all Progress boxes, right-click, set cell formatting, and adjust cell properties to percent format; then, to keep all progress box selections, under Conditional formatting in the toolbar, select a favorite style under "Data Bar".

5, Next, in all progress frame according to the work progress, the input progress degree the numerical value, after the numerical input, the corresponding progress ratio bar appears in the box, the color and the style may adjust casually, thus obtains the more practical project schedule.