Pie charts are one of the basic graphic types of Excel, and we usually use pie charts to represent each item's ratio, and sometimes we see a semicircle pie chart, but there's no such type in Excel, so how do we make it?
1, open excel2013, the other version of the operation is virtually the same, enter the various project categories of data, as shown in the figure, and then summary statistics, the results are placed at the bottom of the list, as shown in the figure
2, first the data to sort, descending, all selected data, including the results of the summary, click Insert, select Pie chart, using the most basic two-dimensional pie chart on the line
3, the table has generated a pie chart, the left side of the blue figure is the summary of the data ratio of the results, select the pie, right-click, select Set data series format
4, on the right side of Excel to find the first sector starting position, enter 270 degrees, that is, starting from-90 degrees, as shown, the original left side of the blue graphics transfer to the bottom of the position
5. Click on the blue Area two times, select it, in the right data series format, switch to color, click the set fill color for a solid fill, select pure white in the color, so that in the white background can not see the following section, the initial display of the semicircle pie chart
6, select the pie chart, on the right side of the data label settings, check the percentages and data labels, cancel the value, display position in the data label, as shown
7, on the pie chart to select the data labels, each of the label's hundred points to expand twice times the manual input, finished can use this pie chart