How to make a semicircle pie chart in Excel tutorial

Today's small series to teach you to make a semicircle pie chart, the need for friends do not miss the opportunity to learn!

Below, start making!

① first prepares the source data and enters the formula in the C2 cell: =b2/sum ($B $: $B $)

② carriage return, the result is a decimal, not the percentage we want to form. Select the number, click the menu bar--Start, and change the format to a percentage.

③ fills the cell down, calculates the data, and adds a 100% at the end.

④ hold down the CTRL key to select the A1:a8 and C1:c8 area, click the menu bar-insert-chart-pie--two-D pie chart.

⑤ pie is successfully inserted, right-click, and choose Set data series format from the pop-up right-click menu.

⑥ in the Set data series format interface, in the Series Option tab, change the first sector starting angle to 270.

⑦ then click the Layout tab and click on the data label--the data label. Click on the other data label options.

⑧ in the Label option, select the category name and set the separator to a line break.

⑨ the lower semicircle to a white fill, consistent with the background color.

⑩ the next semicircle data label to delete, as well as some unwanted parts, finally completes the semicircle pie chart production.