Excel2013 how to make a semicircle pie chart

Excel2013 how to make a semicircle pie chart

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 been generated a pie chart, the left side of the blue figure is the summary results of the data ratio, select the Pie, right-click, select the Format data series.

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 blue graphics transfer to the bottom of the end 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 in the figure.

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.

       &NBSP more knowledge focus on triple excel tutorials   columns