EXCEL2010 chart semicircle Percent Progress chart

A semicircle percent Progress chart is a special pie chart that expresses the percentage of work progress completed, including data model setting, formatting, adding data labels, and so on. Below, the small make up to lead everybody together to produce a semicircle percent progress chart.

1. Create a chart, you must have data, we start Excel2010, simple input some data, including performance goals, unfinished and completed percentages, each month's performance.

2. We see a complete and unfinished cell above, which is used to calculate the proportions, first enter the formula in the completed cell: =sum (B5:B16)/a2, which means calculating the sum of the data in the B5:b16 area and dividing by the A2 cell value, which is the performance goal 5000, Get is the ratio of completion, here to remind you that the formula to be in the English half-width state input only valid.

3. For unfinished proportions, you can use 1 minus the completed ratio. Then enter 100% in the secondary column.

4. Select B1:d2 Range, click the menu bar---Insert--"chart"--"pie," select the first style in a two-dimensional pie chart.

5. Pie chart inserted in, but the feeling is left and right apart, not up and down, right-click the chart, from the pop-up right-click menu, select "Format data series."

6. Pop-up Set data Series Format dialog box, in the Series Option tab, the first sector starting angle set to 270.

7. Select the Chart, click the menu bar--layout--data label, first set it to center, and then repeat the operation, click the other data label options below.

8. Pop-up Settings Data Label Format dialog box, we check the label options directly select the category name, close the dialog box.

9. At this point the chart area already contains a percentage of data labels, for the area produced by the secondary column, this is meaningless, we first delete the above label, press the DELETE key, delete the label, and then select this area, click the menu bar-format-color fill, set the color to the same color as the background, This is white.

10. In this way, the lower semicircle area is not visible, only the upper half of the semicircle, the semicircle percentage of the progress chart is made.

Note : More wonderful tutorials Please pay attention to the triple computer Tutorials section, triple Office group: 185219299 welcome you to join