How does Excel make a gorgeous construction progress chart?

Source: Internet
Author: User

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.

Related Article

E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.